Following query retrieves clicks, conversions, impressions grouped by campaign, asset and date:
SELECT metrics.clicks,
metrics.conversions,
metrics.impressions,
asset.name,
asset.text_asset.text,
asset.youtube_video_asset.youtube_video_id,
campaign.name,
segments.date
FROM ad_group_ad_asset_view
WHERE segments.date BETWEEN '2020-01-01' AND '2020-01-14'
AND metrics.impressions > 0
When I add metrics.engagements field to the query it fails with message:
Cannot select or filter on the following metrics: 'engagements'(could not support requested resources: 'AD_GROUP_AD_ASSET_VIEW', 'AD_GROUP_AD_ASSET_VIEW'), since metric is incompatible with the resource in the FROM clause or other selected segmenting resources.
Is there a way to retrieve clicks, conversions, impressions and engagements grouped by campaign, asset and date?Hi Aleksandr,
Thank you for reaching out. You could only choose the metrics from the ad_group_ad_asset_view resource. You would encounter such an error if you try to use metrics from another resource which are not included in the resource you specified in the FROM clause. Please let me know if you have any further questions.
Thanks and regards,
Xiaoming, Google Ads API Team
Hi Aleksandr,
It is not supported to query metrics.engagements per asset. I have submitted a feature request to include this metric for ad_group_ad_asset_view resource. Please keep an eye on our blog for the announcements and updates on new releases.
Thanks and regards,
Xiaoming, Google Ads API Team