Ads
Query the available Ads in Bing Ads.
Table Specific Information
Select
You must specify the AdGroupId and Type columns in the WHERE clause to query this table. The connector uses the Microsoft Ads API to filter the results by AdGroup and Type, while the rest of the filter is executed client side within the connector.
For example, the following query is processed server side:
SELECT * FROM [Ads] WHERE AdGroupId = '5179946006' AND Type = 'Text'
SELECT * FROM Ads WHERE AdGroupId = '1297424037031698' AND Type = 'DynamicSearch' AND AccountId = '135093022'
SELECT * FROM Ads WHERE AdGroupId = '1302921473177959' AND Type = 'Text' AND AccountId IN ('2562405', '141163457', '180394748')
Columns
| Name | Type | Select requirement | Metric | Aggregate | Description |
| Id [KEY] | Long | The unique Bing Ads identifier for the ad. | |||
| AdGroupId | Long | The system generated identifier of the ad group. | |||
| Type | String | The ad type. One of Text,Image,Product,AppInstall,ExpandedText,DynamicSearch | |||
| Title | String | The title of the ad. The title must contain at least one word. The ad's copy and title combined must total at least three words. | |||
| TitlePart1 | String | The first title part of the ad. | |||
| TitlePart2 | String | The second title part of the ad. | |||
| Text | String | The ad copy. The copy must contain at least one word. The ad's copy and title combined must total at least three words. | |||
| Domain | String | The URL to display in the ad. | |||
| DestinationUrl | String | The URL of the webpage to take the user to when they click the ad. | |||
| UrlCustomParameters | String | Your custom collection of key and value parameters for URL tracking. | |||
| TrackingUrlTemplate | String | The tracking template to use as a default for all landing page URLs. | |||
| Status | String | The status of the ad. | |||
| ForwardCompatibilityMap | String | The list of key and value strings for forward compatibility. This element can be used to avoid otherwise breaking changes when new elements are added in future releases. | |||
| FinalUrls | String | The last or final URL where a user is ultimately taken, whether or not the click to final URL path included any redirects. | |||
| FinalMobileUrls | String | The mobile landing page URL. | |||
| FinalAppUrls | String | Reserved for future use. | |||
| EditorialStatus | String | The editorial review status of the ad, which indicates whether the ad is pending review, has been approved, or has been disapproved. | |||
| DevicePreference | Integer | Determines the device preference for showing the ad. | |||
| AdFormatPreference | String | The Ad Format Preference is used to indicate whether or not you prefer the ad copy to be shown to users as a search or native ad. Search ads tend to be written as a call to action, whereas native ads should be written in more of an informational style. | |||
| AccountId | Long | The Bing Ads assigned identifier of an account. |