I'm experiencing discrepancies between two queries I use to extract statistics from my video campaigns in Google Ads. Typically, I use the first query below to obtain general statistics for my video campaigns:

SELECT      segments.date,      campaign.name,      campaign.id,      metrics.cost_micros,      metrics.video_views,      metrics.impressions,      metrics.clicks,      metrics.conversions   FROM campaign   WHERE campaign.id IN (<google_ads_campaign_id>)  AND segments.date >= '2024-02-01'  AND segments.date <= '2024-02-01'  AND campaign.status IN (ENABLED, PAUSED) 

However, I'm attempting to expand my analysis to include the segment of YouTube videos through which my ads have been displayed. To achieve this, I've created a second query that includes the detail placement view report:

SELECT      detail_placement_view.group_placement_target_url,      detail_placement_view.placement,      detail_placement_view.placement_type,      detail_placement_view.target_url,      segments.date,      campaign.name,      campaign.id,      metrics.cost_micros,      metrics.video_views,      metrics.impressions,      metrics.clicks,      metrics.conversions   FROM detail_placement_view   WHERE campaign.id IN (<google_ads_campaign_id>)  AND segments.date >= '2024-02-01'  AND segments.date <= '2024-02-01'  AND campaign.status IN (ENABLED, PAUSED) 

My issue is that I'm noticing significant discrepancies between the data obtained from these two queries, particularly in metrics such as impressions. My goal is to understand whether these discrepancies are within normal variation or if there's an underlying issue causing them.

I would appreciate any guidance or suggestions on how to address this discrepancy and ensure the accuracy of my analyses.

Tag:google-ads-api, video, youtube

Add a new comment.