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 [email protected] schrieb am Dienstag, 14. Dezember 2021 um 17:50:42 UTC+1: > 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 > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/3061204f-f941-44c6-9b14-b36638dc6b2dn%40googlegroups.com.
