Hi there, 

I know in the Google Ads API zero impression rows will be filtered out if 
you segment by date. However we have been seeing rows with zeros for all 
metrics, including impressions, come in when segmenting by date. 

We are actually looking to get the zero impression rows to handle the case 
where data is corrected after delivery (e.g. there was 1 impression on date 
X deemed to be invalid, so it gets adjusted to 0 several days later). This 
allows us to update the data stored in our own system and ensure the 
delivery numbers are accurate.

How does the API handle this case of corrected/adjusted data and returning 
the zero impression rows? Is there logic in place to return zero rows in 
this scenario, and that is why we do get some zero rows returned? 

Example query:

SELECT segments.date, segments.device, ad_group_ad.ad.id, campaign.id, 
ad_group.id, metrics.active_view_cpm, metrics.active_view_ctr, 
metrics.active_view_impressions, metrics.active_view_measurability, 
metrics.active_view_measurable_cost_micros, 
metrics.active_view_measurable_impressions, 
metrics.active_view_viewability, metrics.all_conversions, 
metrics.all_conversions_value, metrics.clicks, metrics.conversions, 
metrics.conversions_value, metrics.cost_micros, 
metrics.cross_device_conversions, metrics.engagements, metrics.impressions, 
metrics.interactions, metrics.interaction_event_types, 
metrics.video_quartile_100_rate, metrics.video_quartile_25_rate, 
metrics.video_quartile_50_rate, metrics.video_quartile_75_rate, 
metrics.video_views, metrics.view_through_conversions  
FROM ad_group_ad 
WHERE segments.date BETWEEN '2019-10-01' AND '2019-10-07'


Thanks!
Ryan 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/e3553caa-e3c1-416e-a953-dc203a03f44a%40googlegroups.com.

Reply via email to