AssetGroupAssets
Query the available Assets linked to Asset Groups in Bing Ads.
Table Specific Information
Select
The following queries are processed server-side:
SELECT * FROM AssetGroupAssets
SELECT * FROM AssetGroupAssets WHERE CampaignId = '2562405'
SELECT * FROM AssetGroupAssets WHERE CampaignId IN ('1562405', '2562405', '3562405')
SELECT * FROM AssetGroupAssets WHERE AccountId = '2562405'
SELECT * FROM AssetGroupAssets WHERE AccountId IN ('1562405', '2562405', '3562405')
Columns
| Name | Type | Select requirement | Metric | Aggregate | Description |
| AssetGroupId | Long | The asset group ID. | |||
| Id | Long | The ID for 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. | |||
| CampaignId | Long | The system generated identifier of the campaign. | |||
| AccountId | Long | The Bing Ads assigned identifier of an account. |