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')";
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/aa69a22f-bf81-4506-a55d-2750d53bcef2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
