Rows with zero impressions wrongly excluded

[Daan Groot]

Hi,

We found some strange behavior in the google ads api.

When requesting impressions and other metrics, rows are missing where impressions are zero but some other metric is greater than zero.

According to this article this should not happen because all rows with at least one metric greater than zero should be returned.

GAQL query for which we have the problem:

return "SELECT ad_group.id,\n" +
" segments.date,\n" +
" metrics.impressions,\n" +
" metrics.absolute_top_impression_percentage,\n" +
" metrics.content_impression_share,\n" +
" metrics.content_rank_lost_impression_share,\n" +
" metrics.search_absolute_top_impression_share,\n" +
" metrics.search_budget_lost_absolute_top_impression_share,\n" +
" metrics.search_budget_lost_top_impression_share,\n" +
" metrics.search_exact_match_impression_share,\n" +
" metrics.search_impression_share,\n" +
" metrics.search_rank_lost_absolute_top_impression_share,\n" +
" metrics.search_rank_lost_impression_share,\n" +
" metrics.search_rank_lost_top_impression_share,\n" +
" metrics.search_top_impression_share,\n" +
" metrics.top_impression_percentage\n" +
"FROM\n" +
" ad_group\n" +
"WHERE\n" +
" segments.date >= '" + startDate.toString() + "' AND\n" +
" segments.date <= '" + endDate.toString() + "'";

Could you give us some more information on why this is happening? Thanks!

Best,

Daan

[Google Ads API Forum Advisor]

Hello Daan,

Thanks for reaching out to the Google Ads API support. I am just wondering if your issue is related to the selectable_segment_fields while using the ad_group resource.
Can you please confirm if you are using the GoogleAds API v9? If you are already on version 9 and still having issues, for us to investigate could you please provide the complete request and response logs with request ID and request header generated on your end or share the screenshot of UI where specific metrics values are visible. Please use the  Reply privately to the author option while sharing the details.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2Ugkwp:ref