Google Ads - Excluding zero impressions

[Hannes Fischer]

Hello everybody,

Refering to documentation (https://developers.google.com/google-ads/api/docs/reporting/zero-impressions) zero imprressions could be excluded using segments. However, that's not working properly. If I try to execute following query, I still get many zero impression values:

SELECT
campaign.id
,ad_group.id
,ad_group_ad.ad.id
,segments.date
,metrics.impressions
,metrics.clicks
,metrics.cost_micros
,metrics.conversions
,metrics.conversions_value
,metrics.gmail_secondary_clicks
,metrics.absolute_top_impression_percentage
,metrics.top_impression_percentage
,metrics.video_views


FROM ad_group_ad


WHERE segments.date '2019-12-01'

Do you have any idea, how to exclude zero impressions and zero clicks? I need all values where

metrics.impressions > 0
OR metrics.clicks > 0
OR metrics.cost_micros > 0
OR metrics.conversions > 0
OR metrics.conversions_value > 0
OR metrics.gmail_secondary_clicks > 0
OR metrics.absolute_top_impression_percentage > 0
OR metrics.top_impression_percentage > 0
OR metrics.video_views > 0

However, OR condition is not available in WHERE clause (https://developers.google.com/google-ads/api/docs/query/grammar). So what could I do?

Best regards,

Hannes 

[Hannes Fischer]

Hello everyone,

I checked again and it seems, that issue exists since 2019-12-11. @Google API Team: Could you please check, if you commited any API changes between 2019-12-11 and 2019-12-12, which is causing this issue? I'm using following endpoint: https://googleads.googleapis.com/v2/customers/%CUSTOMERID%/googleAds:search.

Due to this issue we noticed a really high number of results in each response and customer id. Number of zero impression/click values increased dramaticlly (36 times more than before!)

I would really appreciate, if you could check!

Best regards,

Hannes

[Google Ads API Forum Advisor Prod]

Hi Hannes,

Can you please provide me your CID and report results through reply privately to author so I can have a look?

Thanks,
Anthony
Google Ads API Team

ref:_00D1U1174p._5001UOEQoL:ref

[Hannes Fischer]

Issue is solved now. Only for few cases I still get zero impressions/clicks/etc values. But that's ok for me. Thanks for your quick support Google API Team!