Ads
Query the available Ads in Bing Ads.
Table Specific Information
Select
The following queries are processed server-side:
SELECT * FROM Ads
SELECT * FROM Ads WHERE AdGroupId = '5179946006'
SELECT * FROM Ads WHERE Type = 'Text'
SELECT * FROM Ads WHERE Type IN ('ExpandedText','Text')
SELECT * FROM Ads WHERE AdGroupId = '5179946006' AND Type = 'Text'
SELECT * FROM Ads WHERE AdGroupId IN ('5179946006',''5179946007'') AND Type = 'Text'
SELECT * FROM Ads WHERE AdGroupId IN ('5179946006',''5179946007'') AND Type IN ('ExpandedText','Text')
SELECT * FROM Ads WHERE AdGroupId = '1297424037031698' AND Type = 'DynamicSearch' AND AccountId = '135093022'
SELECT * FROM Ads WHERE 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.
The allowed values are Text, Image, Product, AppInstall, ExpandedText, DynamicSearch, ResponsiveAd, ResponsiveSearch, Hotel. | |||
| 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. |