AdAssets
Query the available Assets linked to Ads in Bing Ads.
Table Specific Information
Select
The following queries are processed server-side:
SELECT * FROM AdAssets
SELECT * FROM AdAssets WHERE AdGroupId = '2562405'
SELECT * FROM AdAssets WHERE AdGroupId IN ('1562405', '2562405', '3562405')
SELECT * FROM AdAssets WHERE AdType = 'ResponsiveAd'
SELECT * FROM AdAssets WHERE AdType IN ('ResponsiveAd', 'ResponsiveSearch')
SELECT * FROM AdAssets WHERE AccountId = '2562405'
SELECT * FROM AdAssets WHERE AccountId IN ('1562405', '2562405', '3562405')
Columns
| Name | Type | Select requirement | Metric | Aggregate | Description |
| AdGroupId | Long | The system generated identifier of the ad group. | |||
| AdId | Long | The unique Bing Ads identifier for the ad. | |||
| AdType | String | The ad type.
The allowed values are ResponsiveAd, ResponsiveSearch. | |||
| Id | Long | The ID of the asset. | |||
| AssetPerformanceLabel | String | This lets you know how well the asset is performing. | |||
| EditorialStatus | String | The editorial review status of the asset link, which indicates whether the asset is pending review, has been approved, or has been disapproved. | |||
| PinnedField | String | Determines whether the asset should only be used for a specific ad component, or whether you want Bing AI to optimize the layout for this asset. | |||
| Name | String | The asset name. | |||
| Type | String | The type of the asset. | |||
| Text | String | Text for the asset. | |||
| SubType | String | Represents the aspect ratio for the asset. | |||
| CropHeight | Int | The number of pixels to use from the image asset source, starting from the CropY position and moving upwards. | |||
| CropWidth | Int | The number of pixels to use from the image asset source, starting from the CropX position and moving to the right. | |||
| CropX | Int | Starting from the lower left corner of image asset source, this is the number of pixels to skip to the right on the x-axis before applying the CropWidth. | |||
| CropY | Int | Starting from the lower left corner of image asset source, this is the number of pixels to skip upwards on the y-axis before applying the CropHeight. | |||
| TargetHeight | Int | The target height dimension of an image asset. | |||
| TargetWidth | Int | The target width dimension of an image asset. | |||
| ThumbnailImageSubType | String | Represents the aspect ratio for this image asset. | |||
| ThumbnailImageCropHeight | Int | The number of pixels to use from the image asset source, starting from the CropY position and moving upwards. | |||
| ThumbnailImageCropWidth | Int | The number of pixels to use from the image asset source, starting from the CropX position and moving to the right. | |||
| ThumbnailImageCropX | Int | Starting from the lower left corner of image asset source, this is the number of pixels to skip to the right on the x-axis before applying the CropWidth. | |||
| ThumbnailImageCropY | Int | Starting from the lower left corner of image asset source, this is the number of pixels to skip upwards on the y-axis before applying the CropHeight. | |||
| ThumbnailImageTargetHeight | Int | The target height dimension of an image asset. | |||
| ThumbnailImageTargetWidth | Int | The target width dimension of an image asset. | |||
| AccountId | Long | The Bing Ads assigned identifier of an account. |