Shopping performance view discrepancy

[Kateřina Henzlová]

Hi there,

I've found some discrepancies between statistics pulled from shopping_performance_view and from the campaign resource. Could you please explain how it's possible? The difference is quite big and it happens for more campaigns and dates.

I use POST https://googleads.googleapis.com/v14/customers/<customer_id>/googleAds:search

Body of the shopping_performance_view request:

Body:

{
"pageSize": 10000,
"query": "SELECT campaign.id, metrics.cost_micros, metrics.impressions, metrics.clicks FROM shopping_performance_view WHERE segments.date = '2023-07-07' AND campaign.id = <campaign_id>"
}

Body of the campaign resource request:

{
"pageSize": 10000,
"query": "SELECT campaign.id, metrics.cost_micros, metrics.impressions, metrics.clicks FROM shopping_performance_view WHERE segments.date = '2023-07-07' AND campaign.id = <campaign_id>"
}

The results are (result from shopping_performance_view / result from campaign):

costMicros: 62790000 / 156589451

impressions: 24868 / 28713

clicks: 378 / 430

I'm gonna share the customer ID and campaign ID privately.

Thanks and have a nice day!

Katerina

[Google Ads API Forum Advisor]

Hi Kateřina,

Thank you for reaching out to the Google Ads API Forum. I hope that you are doing well today.

I understand that you are seeing discrepancy between two different resources. Note that it is not recommended to match two different resources for the data. However, for us to further check it, could you please provide us the complete request and response logs with request-id and request headers generated on your end to further investigate the issue and please provide us the full non-cropped and non-redacted screenshot of the UI report that you are trying to fetch via API?

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Reference links:

• request - https://developers.google.com/google-ads/api/docs/concepts/field-service?hl=en#request
• response - https://developers.google.com/google-ads/api/docs/concepts/field-service?hl=en#response
• request-id - https://developers.google.com/google-ads/api/docs/concepts/call-structure?hl=en#request-id 
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

 

This message is in relation to case "ref:_00D1U1174p._5004Q2n7AND:ref"

Thanks,
 

Google Ads API Team

[Kateřina Henzlová]

Hi team,

Thanks for looking into it! I've replied privately with the required information, I hope it helps to investigate this further.

Thanks and have a nice day!

Katerina