Problem: The data appears to match overall, but the issue arises with the data type and the decimal point formatting in the reported values. Specifically, the field ‘cost_micros’ in the source system is being exported as an integer, rather than a decimal or float, which affects the accuracy of the data when transferred.
Explanation: The Google Ads API reports all costs in micros. This means that the values we are getting for fields such as Average Cost, Cost Per Conversion, Average CPC etc. will be 1,000,000 times higher than what you see in the Google Ads UI. In other words, to get to the same values in your data destination, divide the numbers by 1,000,000.