metrics.impressions difference between campaign and detail_placement_view

[En Chiang Lee]

Hi,

While trying to get the metrics for a campaign at the placement level, we noticed a discrepancy between the number of impressions returned from the campaign table and the detail_placement_view table.

For example, for the same campaign:

SELECT campaign.id, metrics.impressions
                          FROM campaign
                         WHERE campaign.id=xxx7653xxxx
                         ORDER BY campaign.id

gives us 125,315

while:

SELECT  campaign.id, metrics.impressions
                           FROM detail_placement_view
                           WHERE campaign.id=xxx7653xxxx
                            ORDER BY campaign.id

gives us 91,358 when summed up.

Has anyone else seen this problem? The number from the campaign table matches the number seen in the UI. Is there a way to get the detail_placement_view number to match that?

Thanks,

En Chiang

[Google Ads API Forum Advisor]

Hi En Chiang,

Thank you for reaching out to Google Ads API support with your query. The detail_placement_view correlates to placements screen in UI as described here. Note that all impressions may not show through placements so you can check on the totals in the UI how many impressions show in placements. If there is a discrepancy between the UI and the API, could you privately send us a full screen screenshot of the UI showing a report screen combined with a complete report definition taken within the same timeframe? 

A method to record a full report definition is to turn on logging. The request and response appears similar to the JSON Mappings in our REST documentation with additional information such as  request ID . Our client libraries have loggers with logging instructions, to see these instructions you can click on the client library you use in the sidebar of our client library guide and click on "Logging”. Setting the log level to 'DEBUG' would create the desired logs.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2W5duv:ref