API Report Metrics Discrepancies ?

[Christian Pradilla]

Do search query perf, geo perf, and keywords perf could be differ in sum total of the metrics such as impressions,conversions,cost and etc. ? if they do, could you provide a reason why ? I'm trying to match the mentioned metrics and have tried pulling a request for each report with similar Fields like (Date,CampaignId,Cost,Impression,Conversion,Currency, and etc) and still not matching.

Best Regards,

[Google Ads API Forum Advisor Prod]

Hi Christian,

Thank you for reaching out to us. Reports such as Keywords Performance are of type single attribution, in which one of the triggering criteria is recorded for a given impression. This report by default also only includes rows for positive keywords, however, this can be toggled on and off. For Geo Performance, this report type can report different statistical totals in your report if you request both IsTargetingLocation values in your predicate and either do not limit by LocationType or request both LocationType values in your predicate. For Search Query Performance, the statistics are aggregated at the search terms level. All the reports generate data at different levels, so you may observe different results for each report. However, the data should match with the data in the UI view. Let me know if you have further questions.

Thank you,
Bryan, Google Ads API Team

ref:_00D1U1174p._5001UUzrnh:ref

[Christian Pradilla]

Thanks for the help :) 

[Christian Pradilla]

Anyway, Just wanted to know if there's a way to match all of the metrics total for these following reports (Keywords perf, Geo Performance, and Search Query Performance) and if reporting intended to create a report with different metrics total the question is why each reports has different metrics total, is that even possible ?  

[Google Ads API Forum Advisor Prod]

Hi Christian,

Thank you for the update. All the reports generate data at different levels, so you may observe different total results for each report. Please note that Geo Performance is also a multi attribution type report, so it may double count impressions and clicks, which might show differences in results. I ran a test query on Keywords Performance and Search Query Performance and some field totals matched (such as costs and clicks) but other totals differed (such as impressions). This is because of the aggregate of data at different levels in different report types. Let me know if you have further questions.

[Christian Pradilla]

The attached document may serve as reference. Data from the csv are came from the UI and manually downloaded. This shows that between account cost and account region cost has differences and also account keywords may observe differences. if you dont mind do check the account cost and cost region of

F45 - F45 - Invest Malaysia / Asia for there is huge differences

 23252.21 account cost and region cost 9357.74.

[Google Ads API Forum Advisor Prod]

Hi Christian,

Could you provide me the CID for that account so I may further troubleshoot this issue?