How to get full clicks and costs for a PMax campaign?

[Roy Roes]

For example:
In Google Ads for a PMax campaign on 14-06-2022 we have:
2.124 clicks and 926,71 EUR costs.

When we get the clicks and costs for the campaign with Google ADS API for that date we get:
2.037 clicks and 877,22 EUR costs.

We use the following query:
SELECT metrics.clicks, metrics.average_cpc, segments.product_item_id, campaign.id FROM  shopping_performance_view WHERE campaign.id = xxxxxxxxxx
And we do clicks * avarage_cpc to get the costs. 

How do we get the same results as in Google Ads with the Google Ads API?
Or how can we query the missing clicks/costs?

[Google Ads API Forum Advisor]

Hi Roy,

Thank you for reaching out to our API support team.

Performance Max campaigns reporting is also discussed more in this guide. Since you are using the shopping_performance_view and for our team to investigate further, could you share your complete request and response logs, and the request-id generated when you downloaded this report?

In addition, could you also share the complete screenshot of the Google Ads UI view you are comparing with the said shopping report?

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation.

You may then send all the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2cExut:ref