The reason why your query returns 0 results when adding metrics.clicks is that performance metrics (like metrics.clicks) may not be available directly for ad_group_asset. Try using the asset_performance_view instead
Blobr <https://www.blobr.io/> - AI agents to optimise Google Ads spending On Wednesday, 12 February 2025 at 13:52:29 UTC+1 Shahil Verma wrote: > Hi team, > > Why I am unable to fetch performance metric data of assets that are > present at adgroup level using this query - > > > SELECT asset.id, asset.type, campaign.id, metrics.clicks FROM > ad_group_asset WHERE campaign.id = 22148688913 > > When I ran the query, I got 0 results. But when I removed the > metrics.clicks field, it returned one row. > [image: Screenshot 2025-02-12 181631.png] > > Right now, we need two separate queries to fetch assets—one from > campaign_asset for campaign-level assets and another from ad_group_asset > for ad group-level assets. Is there a way to fetch both in a single query, > so we can get all assets at the ad group level along with campaign-level > assets? > > Thanks in advance! > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/5da1dca2-09dd-4dea-a74b-a9f9100905d0n%40googlegroups.com.
