Google Ads API Question: Inconsistent data at adgroup.ad level and adgroup level

[张涛]

When we captured the spend data of adgroup and adgroup.ad at the same time, we found that under the same adgroup, the spend data queried by adgroup and the spend data queried by adgroup.ad were inconsistent. Is this possible?
The query statements of the two are:

sql: SELECT customer.id, campaign.id, ad_group.id, ad_group_ad.ad.id, metrics.cost_micros, segments.ad_network_type, segments.ad_destination_type, segments.date FROM ad_group_ad WHERE segments.date >= '2022-12-01' AND segments.date <= '2022-12-31' AND metrics.cost_micros > 0 sql: SELECT customer.id, campaign.id, ad_group.id, geographic_view.country_criterion_id, metrics.clicks, metrics.impressions, metrics.cost_micros, metrics.interactions, segments.date, segments.ad_network_type FROM geographic_view WHERE segments.date >= '2022-12-01' AND segments.date <= '2022-12-31'

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

I can see that you are comparing the cost metrics data pulled from geographic_view report and ad_group_ad report. However, note that these 2 resources / tables are indeed different reports which means that ad_group_ad report will pull the cost metrics at ad level, whereas geographic_view report will pull the cost metrics for the geo related data.

You may note that the Google Ads API pulls the cost metrics whatever is showing on the Ads UI. and Google Ads API should pull exact and correct cost metrics shown on Ads UI. You may let us know if you are seeing any discrepancies in API vs UI results.

Feel free to reach back if  you have further questions. 

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

Thanks,
 

Google Ads API Team