API campaigns report not matching UI and total incorrect

[Liam Connors]

When comparing data received from the API for a particular campaign we noticed it does not match the UI and is off by a few cents every month, and the total returned as Total conv. value does not actually match the total of all the rows. Can you give any guidance on why this might be the case? Thanks

[Google Ads API Forum Advisor Prod]

Hi Liam,

Thank you for reaching out.

A possible reason why you might be encountering slight discrepancies maybe due to data freshness. You may refer to this guide for further details. If you think this is not the issue, could you provide the complete report definition, clientCustomerId, and the screenshot in the UI that shows discrepancies? You may provide them using the reply privately to author option.

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UEJSqT:ref

[Google Ads API Forum Advisor Prod]

Hi Liam,

Thank you for providing the details privately. 

My apologies for the delayed response as I was discussing this with the team. The discrepancy is due to the fact that conversion values on each row are rounded to two decimal places, while the total adds up the actual values and then rounds to two decimal places. Upon checking the UI, it is also observed that it does the same.

[Liam Connors]

Thanks Dannison,

Is there a way to get the full actual values for each conversion from the API, or values with more precision?

[Google Ads API Forum Advisor Prod]

Hi Liam,

Unfortunately, this is the current behavior observed in the whole Google Ads system. There are no workaround solutions for this.

[John O'Toole]

Hi Dannison, 

I'm having a similar issue where the cost totals from the campaigns page differ by a few pennies every day compared to the same data from the Reports page. The first instance of this happened on August 15th for us, everything is a match before then. I would guess it is a rounding issue or currency issue, but it seems to be too unusual to be considered normal behavior.

Thanks,

John

[Google Ads API Forum Advisor Prod]

Hi John,

Thank you for reaching out.

Upon checking the attached screenshot, it appears that both of your reports were pulled using the Google Ads UI. That said, I would recommend that you reach out to the Google Ads Support Team instead in the Google Ads Community Forum as the product owners will be able to provide you insights on this.

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UHGyjp:ref