Google-Ads API V1.0 - How to include zero impression metrics.

[Priya]

I would like to include zero impression  and also Paused & Removed Ads in my performance report. But below query gets only non-zero impressions and enabled Ads only.  What do I need to change to include zero impressions data and get all status. Thank you. 

 string query =

                $@"SELECT

                 ad_group_ad.ad.id,

                 campaign.id,

                 segments.date,

                 metrics.impressions,

                 metrics.clicks,

                 metrics.cost_micros,

                         metrics.average_position,

                 ad_group_ad.status,

                 ad_group_ad.ad.call_only_ad.business_name,

                 ad_group_ad.ad.call_only_ad.description1,

                 ad_group_ad.ad.call_only_ad.description2,

                 ad_group_ad.ad.call_only_ad.phone_number,

                 ad_group_ad.ad.expanded_text_ad.headline_part1,

                 ad_group_ad.ad.expanded_text_ad.headline_part2,

                 ad_group_ad.ad.expanded_text_ad.description,

                 ad_group_ad.ad.expanded_text_ad.path1,

                 ad_group_ad.ad.expanded_text_ad.path2,

                 ad_group_ad.ad.display_url

                FROM

                ad_group_ad

                WHERE segments.date = '2019-04-17'                  

                    AND metrics.impressions IS NULL 

                    AND ad_group_ad.status IN ('ENABLED','PAUSED')";

[googleadsapi...@google.com]

Hi Priya, 

The GAQL will include the data that includes the zero impressions if not explicitly specified. You can exclude zero impressions from your queries by adding metrics.impressions > 0 in your predicate. Please check this guide for more information. You may use the ad_group_ad.status with enum values as PAUSED and REMOVED in the predicate to get the Paused and removed ads. 

Let me know if you have any questions.

Regards,

Bharani, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=