AI-generated Key Takeaways
-
The
asset_group_assetresource allows you to obtain asset-level performance, including theperformance_labelfield which ranks an asset against others of the same type. -
The
asset_group_top_combination_viewresource can be used to query the top performing combinations of assets within asset groups, mirroring the Combinations report in the Google Ads UI. -
Queries on
asset_group_top_combination_viewcan be adapted to identify top asset combinations for specific asset groups or campaigns, potentially filtered by metrics like asset group ad strength.
It's possible to obtain asset level performance by using the
asset_group_asset resource.
Asset performance with asset_group_asset
On the asset_group_asset resource, the
performance_label
field ranks the asset against other assets of the same type. For more details,
see About asset reporting in Performance
Max.
SELECT
asset_group_asset.asset,
asset_group_asset.performance_label,
asset_group_asset.status
FROM asset_group_asset
WHERE asset_group.id = ASSET_GROUP_ID
AND asset_group_asset.status != 'REMOVED'
Top asset combinations
The
asset_group_top_combination_view
resource can be used to query the top performing combinations of assets in asset
groups. This corresponds to the Combinations
report in the
Google Ads UI. For example, the following query produces a list of the top asset
combinations in a specified asset_group. Each row in the response contains a
list of asset_group_top_combination_view.asset_group_top_combinations messages
of type
AssetGroupAssetCombinationData.
Each item in that list contains a list of the assets in the respective
combination represented as an AssetUsage message.
SELECT asset_group_top_combination_view.asset_group_top_combinations
FROM asset_group_top_combination_view
WHERE asset_group.id = ASSET_GROUP_ID
You can adapt this query to help with asset selection and campaign optimization.
The following query retrieves the top asset combination for a single campaign,
but only for asset groups with an
asset_group.ad_strength of
GOOD or EXCELLENT. This helps you identify the best-performing asset
combinations within your top-performing asset groups.
SELECT
asset_group_top_combination_view.asset_group_top_combinations,
asset_group.ad_strength,
asset_group.id
FROM asset_group_top_combination_view
WHERE asset_group.ad_strength IN ('GOOD', 'EXCELLENT')
AND campaign.id = CAMPAIGN_ID