Dear Google, I am using two queries: 1. Campaign metrics PMAX: SELECT campaign.id, campaign.name, campaign.campaign_budget, campaign.status, campaign.advertising_channel_type, segments.date, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.video_views, segments.date, segments.ad_network_type, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate, metrics.video_quartile_p100_rate, metrics.active_view_measurable_impressions FROM campaign WHERE segments.date = '2024-03-24' AND campaign.advertising_channel_type = 'PERFORMANCE_MAX' AND campaign.id = '21062943085' ORDER BY campaign.id
2. Campaign metrics with asset (Pmax): SELECT campaign.name, campaign.id, segments.date, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.conversions_value, segments.asset_interaction_target.asset, segments.asset_interaction_target.interaction_on_this_asset FROM campaign WHERE segments.date = '2024-03-24' AND campaign.advertising_channel_type = "PERFORMANCE_MAX" AND campaign.id = '21062943085' AND metrics.cost_micros > 0 ORDER BY campaign.id However I see in the query 1: 51.47319 cost And I see in query 2: 383 cost. I would assume that the sum of all assets for this campaign coming from query 2 would result in the value of query 1. If I look in the ad manager than the result of query 1 is correct. How can it be that the cost of query 2 is like 6 times as much? Can you help me understand this? And if the query is not correct how can I get the asset per campaign level? Ad account id: 4232522843 Thanks Siebert Looije -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/5a801b86-0ac1-49c1-8ff8-c8b0dd8bb183n%40googlegroups.com.