Zero Impression Data for Corrections

[Ryan Whitten]

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 

[Google Ads API Forum Advisor Prod]

Hi Ryan,

Thank you for reaching the support. As mentioned in this guide, zero impressions are always excluded when segmenting a report. If you are still getting the zero impressions data, could you please confirm if you are using the shared report query while generating the reports via API? If not, could you please share the complete report query along with the client customer id and the report files generated via API for me to take a look into this further? For your other concern, it is not possible to include zero impressions when you use segmentation in the report query. The API request call will return the impressions present in the UI for the corrected data or adjusted data, if zero, this will be excluded from the reports generated via API. Let us know if you need any further clarifications.

PS: Please use Reply privately to author option while sharing the details.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UJamO6:ref

[Ryan Whitten]

Hi there, 

Thanks for your reply. We are using that same report query I posted and occasionally get zero impression rows returned. Since we want the zeroes that part is not a big deal for us, just the inconsistency is. 

What is the best way to request this as a product feature? We would really like the ability to ask for zero impression data much like the old AdWords API. Without it, we can never have the latest corrected data unless we request one day at a time and remove the segments. Requesting one day at a time really decreases performance so we are without a great solution in the Google Ads API. 

Thanks,

Ryan 

[Google Ads API Forum Advisor Prod]

Hi Ryan,

I have raised a feature request for your concern internally within our team. We currently do not have any timeline to share on when this feature will be available via Google Ads API. Please keep an eye on our blog post for further updates and announcements.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UJamO6:ref