This is unfortunate that there is no longer an option to retrieve the zero metrics rows.
Here is an example of a real-world situation. When looking at bid_adjustments broken down by household income segments, segmented however one wishes (Date + maybe device, etc...) , if the metrics for that segment are all 0 it won't return the result, but you can see the result in the UI. This particular segment has a bid_adjustmnet of say -59%, but that becomes invisible in API reports, leading to discrepancies between API and UI displayed information and leads to a lack of trust from our clients of the API data when compared to the UI. This is frustrating to say the least. This was not an issue in adwords, as there was an explicit option to include or exclude zero-metric rows in the API reports. The left side of the screenshot is the API report, Right side is the UI downloaded report all filtered to the same campaign, ad group, and date. Ordered by impressions for easy comparison. As you can see, the bottom two rows on the right (from the UI) do not appear on the left (from the API) You can clearly see how not being able to provide rows with zero metrics results, fails to provide needful and valuable information about bid_adjustments. If i used the API only, then i would not see that the other two segments are currently -59% and -22% for bid_adjustments. [image: zero-metrics-results.jpg] On Thursday, February 17, 2022 at 3:36:49 AM UTC-7 adsapi wrote: > Hi, > > Thank you for raising this concern to Google Ads API Team. > > With regard to your concern, *"What is the reason that zero metrics are > included in the Ads GAQL query?", *I recommend to use v10 > <https://developers.google.com/google-ads/api/docs/release-notes#v10> as > according to the first bullet of this document > <https://developers.google.com/google-ads/api/docs/release-notes#reporting>, > fixed there the inconsistencies where rows with zero metrics were returned > when segments were selected in some reports. All reports will now follow > the expected behavior > <https://developers.google.com/google-ads/api/docs/reporting/zero-metrics#exclude_zero_metrics_by_segmenting> > of > ignoring zero-metric rows in reports that select metrics and segments. > > Let me know if you have any questions with the provided documents. > > Best regards, > [image: Google Logo] > Jinky > Google Ads API Team > > > ref:_00D1U1174p._5004Q2WwZDs:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 on the web visit https://groups.google.com/d/msgid/adwords-api/e7d7bac6-065e-449a-a54d-a80d1c9a9a2en%40googlegroups.com.
