Campaign metrics != campaign with asset metrics are not the same (Pmax)

[Siebert Looije]

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

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Kindly note that asset reporting doesn't include auto-generated assets, which could contain additional metrics. As a result, you shouldn't expect the sum of all asset spend to be consistent with your overall campaign spend.

If you still feel this is a discrepancy, to do further checks, please provide us the following details:

• Provide the complete request and response with request-id and request header generated on your end
• Screenshots from the Ads UI without cropping
• Sample comparison of the Ads UI and Google Ads API report data where we can see the said discrepancies

Kindly note that you have to enable logging if you are using a client library. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag. 

You can send the details via the Reply privately to the author option or a direct private reply to this email.  

This message is in relation to case "ref:!00D1U01174p.!5004Q02vFANe:ref" (ADR-00264042)

Thanks,
 

Google Ads API Team

[Siebert Looije]

Dear Google,

Thanks for the quick response! So I expect that the numbers can be less as there are no auto-generated assets included however what I observe is that the asset reporting is showing 10x more than the campaign reporting which seems strange to me.

Request 1 (campaign level metrics), this is matching the UI, so no question on this:

request id: heA6ScWjdaYsmBqb89zKfw

cost_micros: 51473190

Request 2:Campaign level with asset metrics

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

request id: HGidwqjxKszb7nrORQmrlw

cost_micros summed: 383681900 How can it be that request 2 the cost micros is soo much more than request 1?

If you need more information, please let me know.

Kind regards,

Siebert Looije  

Op dinsdag 20 augustus 2024 om 22:02:10 UTC+2 schreef Google Ads API Forum Advisor:

[Google Ads API Forum Advisor]

Hi Siebert,

We are aware of an issue where adding the 'segments.asset_interaction_target.asset' field results in higher cost micros values compared to when this segment is not included. I would like to inform you that our team is currently working on this issue. One of our teammates will get back to you once we have an update on this. Meanwhile your patience is appreciated.

[Siebert Looije]

any update on this?

Op woensdag 21 augustus 2024 om 12:30:40 UTC+2 schreef Google Ads API Forum Advisor:

[Google Ads API Forum Advisor]

Hi,

We do not have updates on the issue, will let you know once we get an update.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vFANe:ref" (ADR-00264042)

Thanks,
 

Google Ads API Team

Feedback
How was our support today?