Big Discrepancies Between Campaign and Detailed Placement Reports

[Don Cosseboom]

Hi,

For example, the campaign report for account XXX-XXX-XXXX returns ~10.5M impressions, the detail_placement_view report returns ~7M impressions.

https://developers.google.com/google-ads/api/fields/v5/detail_placement_view

SELECT segments.month, 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_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, metrics.video_views, metrics.view_through_conversions FROM detail_placement_view WHERE segments.date BETWEEN '2020-10-01' AND '2020-10-29'

https://developers.google.com/google-ads/api/fields/v5/campaign

SELECT segments.date, campaign.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_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, metrics.video_views, metrics.view_through_conversions, metrics.invalid_clicks FROM campaign WHERE segments.date BETWEEN '2020-10-01' AND '2020-10-29'

Thanks,

Don

[Google Ads API Forum Advisor Prod]

Hi Don,

Do you also see discrepancies in the Campaigns and Placements tab in the UI? If so, you should reach out to the product team through this link.

Regards,
Anthony
Google Ads API Team

Anthony Google Ads API Team

 

ref:_00D1U1174p._5004Q275m57:ref

[Don Cosseboom]

Hi Anthony,

I did contact Product Support, and they shed some light on the difference between the views in the Google Ads UI, but that still doesn't address the delta in API calls.

Why is there a 3M impression delta between the two reports?   
The UI has 800k delta between the Placement and Where Ads Showed reports.

Thanks,

Don

[Google Ads API Forum Advisor Prod]

Hi Don,

Please share the full reports to me via reply privately to author so I can take a closer look.

Thanks,

Anthony
Google Ads API Team

Anthony Madrigal Google Ads API Team

ref:_00D1U1174p._5004Q275m57:ref

[Don Cosseboom]

Hi Anthony,

I cannot use the reply to author feature, I am getting the message of:

"You do not have permission to reply privately to author in this group." 

Thanks,

Don

[Google Ads API Forum Advisor Prod]

Hi Don,

You can email us at googleadsa...@google.com.

Regards,

Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q275m57:ref

[digitalvirg...@gmail.com]

Hello,

We are working at the moment on migrating Placement reports to the new version and we have exactly the same issue reported in this thread with detail_placement_view. reporting much less impressions than "Where Ads are showed" UI report.

Did you figure out the root cause of this discrepancy?

Also, the documentation really lacks explanations about which reports count what between detail_placement_view, group_placement_view, managed_placement_view and how it maps to the Google Ads UI....  Do you have a place where detailed explanations are available please?

Anthony

[Google Ads API Forum Advisor]

Hi Anthony,

The managed_placement_view reports targeted placements (managed placements), whereas the group_placement_view returns automatic placements. There is no corresponding UI view for detail_placement_view, it's only meant to parallel the old deprecated UI and the deprecated URL Performance Report.

Deprecating Url Performance Report and Automatic Placements Performance Report in the AdWords API from our blog states that for Url Performance Report, use detail_placement_view in Google Ads API and for Automatic Placements Performance Report, use group_placement_view in Google Ads API. 

Note that  there's a difference between the URL Performance Report and the detail_placement_view because Url Performance Report is a single attribution report. This means that one criterion is picked to be given credit for the click or view. In some cases, one URL may not be given credit because another criterion elsewhere was given all the credit.

The whole Google Ads API does not use single attribution because we found it can be confusing, so each view will show every single criterion that was in play at the time, which gives more of an all encompassing picture of what was being used while serving.

I brought to my team your request for clear documentation on these views and their correspondence to UI views. You may monitor our blog for an update.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q275m57:ref