AdExtensions
Query the available Ad Extensions in Bing Ads.
Table Specific Information
Select
The following queries are processed server-side:
SELECT * FROM AdExtensions
SELECT * FROM AdExtensions WHERE Id = '2562405'
SELECT * FROM AdExtensions WHERE Id IN ('1562405', '2562405', '3562405')
SELECT * FROM AdExtensions WHERE Type = 'ActionAdExtension'
SELECT * FROM AdExtensions WHERE Type IN ('ActionAdExtension', 'AppAdExtension')
SELECT * FROM AdExtensions WHERE AccountId = '2562405'
SELECT * FROM AdExtensions WHERE AccountId IN ('1562405', '2562405', '3562405')
Columns
| Name | Type | Select requirement | Metric | Aggregate | Description |
| Id [KEY] | Long | The ID of the ad extension. | |||
| Type | String | The type of ad extension.
The allowed values are ActionAdExtension, AppAdExtension, CallAdExtension, CalloutAdExtension, DisclaimerAdExtension, FilterLinkAdExtension, FlyerAdExtension, ImageAdExtension, LocationAdExtension, LogoAdExtension, PriceAdExtension, PromotionAdExtension, ReviewAdExtension, SitelinkAdExtension, StructuredSnippetAdExtension, VideoAdExtension. | |||
| Version | Int | Tracks the number of times the ad extension has been updated. | |||
| DevicePreference | Long | This element determines whether the preference is for the ad extension to be displayed on mobile devices or all devices. | |||
| SchedulingStartDate | Date | The scheduled start date. | |||
| SchedulingEndDate | Date | The scheduled end date. | |||
| SchedulingUseSearcherTimeZone | Bool | Determines whether to use the account time zone or the time zone of the search user where the ads could be delivered. | |||
| SchedulingDayTimeRanges | String | The list of day and time ranges. | |||
| Language | String | The language for the ad extension. | |||
| ActionType | String | The action text. | |||
| FinalUrls | String | The landing page URL. | |||
| FinalUrlSuffix | String | The suffix added to the landing page URL. | |||
| FinalMobileUrls | String | The mobile landing page URL. | |||
| TrackingUrlTemplate | String | The tracking template to use as a default for all FinalUrls and FinalMobileUrls. | |||
| UrlCustomParameters | String | Your custom collection of key and value parameters for URL tracking. | |||
| AppPlatform | String | The application platform. | |||
| AppStoreId | String | The application identifier provided by the app store. | |||
| DestinationUrl | String | The URL of the webpage to take the user to when they click. | |||
| DisplayText | String | The text displayed in the ad extension. | |||
| CountryCode | String | The country code where the phone number is registered. | |||
| IsCallOnly | Bool | The option to show both your phone number and website, or just your phone number, to people seeing your ads on a smartphone. | |||
| IsCallTrackingEnabled | Bool | Determines whether call tracking is enabled for the call ad extension. | |||
| PhoneNumber | String | The phone number to include in the ad. | |||
| RequireTollFreeTrackingNumber | Bool | You can either use your own phone number or use a Bing Ads forwarding phone number. | |||
| Text | String | Text value relevant to the extension. | |||
| AdExtensionHeaderType | String | The header that is appended with a colon and precedes the filter link values in the ad that is shown. | |||
| Texts | String | The text values that follow after the AdExtensionHeaderType component of the ad that is shown. | |||
| Description | String | Description that can be used by the advertiser, agency, or account manager to track, label, or manage extensions. | |||
| FlyerName | String | The flyer name. | |||
| ImageMediaIds | String | The identifier of the image to include in the ad. | |||
| Images | String | Image assets with different sizes and aspect ratios so they can flexibly display across a variety of publishers and placements. | |||
| ImageMediaUrls | String | The URL of the media that you already added. | |||
| StoreId | Long | The unique identifier of a Microsoft Merchant Center store used for product ads. | |||
| AlternativeText | String | Alternative description of the image media for usability. If the image could not be displayed, the alternative text is used instead. | |||
| Layouts | String | The list of eligible image layouts. | |||
| SourceType | String | The source type. | |||
| AddressCityName | String | The name of the city where the street address is located. | |||
| AddressCountryCode | String | The country where the street address is located. | |||
| AddressPostalCode | String | The postal or zip code. | |||
| AddressProvinceCode | String | A code that identifies the state or province where the street address is located. | |||
| AddressProvinceName | String | The name of the state or province where the street address is located. | |||
| AddressStreetAddress | String | The first line of the address. | |||
| AddressStreetAddress2 | String | The second line of the address. | |||
| CompanyName | String | The name of the business. | |||
| GeoCodeStatus | String | A status value that indicates whether the business latitude and longitude coordinates have been determined. | |||
| GeoPointLatitudeInMicroDegrees | Int | The latitude specified in micro degrees | |||
| GeoPointLongitudeInMicroDegrees | Int | The longitude specified in micro degrees | |||
| BusinessLogo | Long | The asset ID for the business logo. | |||
| BusinessLogoUrl | String | The URL of the business logo. | |||
| BusinessName | String | The business name. | |||
| DomainName | String | The domain name. | |||
| PriceExtensionType | String | The type of the price ad extension. | |||
| TableRows | String | The price table rows. | |||
| CurrencyCode | String | The currency code for the promotion price or discount. | |||
| DiscountModifier | String | The promotion discount modifier. | |||
| MoneyAmountOff | Double | The money off promotion value. | |||
| OrdersOverAmount | Double | The orders over amount value appended to the promotion target. | |||
| PercentOff | Double | The percent off promotion value. | |||
| PromotionCode | String | The promotion code appended to the promotion target. | |||
| PromotionItem | String | The promotion target or item. | |||
| PromotionOccasion | String | The promotion occasion. | |||
| PromotionStartDate | Date | The start date helps to inform the promotion date or dates that will be displayed in the ad. | |||
| PromotionEndDate | Date | The end date helps to inform the promotion date or dates that will be displayed in the ad. | |||
| IsExact | Bool | Determines whether the review text is an exact quote or paraphrased. | |||
| Source | String | The review source name. | |||
| Url | String | The review source Url. | |||
| Description1 | String | The site link description line 1. | |||
| Description2 | String | The site link description line 2. | |||
| Header | String | The header that is appended with a colon and precedes the snippet values. | |||
| Values | String | The snippet values that follow after the Header component of the ad that is shown. | |||
| AccountId | Long | The Bing Ads assigned identifier of an account. |