Missing metrics in view: ad_group_ad_asset_view, after API update to v9.0

[Nati-An Ben Itach]

Hi!

We've started to see unexpected responses for our customer's accounts, after updating the API to v9.0.

When querying the endpoint ad_group_ad_asset_view, for various metrics, such as cost_micros, clicks, and impressions, for some accounts, we are getting only impressions.

i.e, not zeros, but the metric doesn't return at all.

Query for example:
SELECT segments.date, campaign.id, campaign.name, customer.currency_code, campaign.app_campaign_setting.app_id, campaign.app_campaign_setting.app_store, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, metrics.impressions, metrics.clicks, metrics.cost_micros, campaign.final_url_suffix, campaign.tracking_url_template, ad_group.name, ad_group.id, segments.ad_network_type, ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.ad.type, asset.id, asset.name, asset.type, ad_group_ad.ad.final_urls, ad_group_ad.ad.final_url_suffix, ad_group_ad.ad.tracking_url_template, asset.youtube_video_asset.youtube_video_title FROM ad_group_ad_asset_view WHERE segments.date >= '2021-12-03' AND segments.date <= '2021-12-07' AND campaign.name IS NOT NULL ORDER BY segments.date

example row in response:
{"customer": {"resourceName": "xxxxx","currencyCode": "EUR"},"campaign": {"resourceName": "xxxx","advertisingChannelType": "SEARCH","name": "xxxxxxx","id": "xxxxx"},"adGroup": {"resourceName": "xxxx","id": "xxxx","name": "xxxxx"},"metrics": {"impressions": "1"},"adGroupAd": {"resourceName": "xxxxxx","ad": {"type": "RESPONSIVE_SEARCH_AD","resourceName": "xxxxx","id": "xxxxxx","finalUrls": ["xxx"]}},"segments": {"adNetworkType": "SEARCH","date": "2021-12-03"},"asset": {"resourceName": "xxxxxxx","type": "TEXT","id": "xxxxxxx"},"adGroupAdAssetView": {"resourceName": "xxxxxxxx"}}

Let me know if there's any further information I can share to help investigate it.

Looking forward to hearing from you.

Nati-An

[Google Ads API Forum Advisor]

Hi Nati-An,

Thanks for reaching out to us.

Could you provide us with the complete request and response logs with the request-id, so our team can better check?

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2TL5nR:ref

[Mat]

Hi Nati-An,

in segmented reports (like "segments.date" and "segments.ad_network_type" in the "select" clause of your example), fields with zero values will not show up in the report.

Rows where all selected metrics are zero are not returned at all.

Reference:

https://developers.google.com/google-ads/api/docs/reporting/zero-impressions#exclude_zero_impressions_by_segmenting

Regards

Mat

[Google Ads API Forum Advisor]

Hi Mat,

Thank you for chiming in, for the rows where only impressions that are non 0 are returned and no other metrics fields are returned we will have to see the log sent privately. Setting the log level to 'DEBUG' will get the requested log.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2TL5nR:ref