Use ads api v3 to query the geo cost of campaign, but the returned data is incomplete

[韩斌]

I used SearchStream method , that query is "SELECT campaign.id, campaign.name, metrics.cost_micros,segments.geo_target_state FROM geographic_view where segments.date = '2020-06-29' "

and comparing the cost data on https://ads.google.com/aw/locations, it is found that only part of the country's data is returned, not all.

Why is this so?

[Google Ads API Forum Advisor Prod]

Hi,

Thanks for reaching out. In order for me to better investigate the issue, can you please provide screenshot of the UI and download report along with customer id? Please ensure you "Reply privately to author" when providing this information.

Thanks,
Nirmita Patel Google Ads Team
 

ref:_00D1U1174p._5004Q21ASdD:ref

[韩斌]

Hello,

Is there any progress？

在 2020年7月1日星期三 UTC+8上午2:36:23，adsapiforumadvisor写道：

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for providing the information. I noticed that the you are using segmenting with the geo_target_state in your request but on the UI it is the locations on the country level. This is the reason you observed the difference data in geographic_view report.

Let me know if you have any questions.

[韩斌]

Hi,

  How can I query for country-level data because there is no geo_target_country field

在 2020年7月7日星期二 UTC+8上午2:35:58，adsapiforumadvisor写道：

[Google Ads API Forum Advisor Prod]

Hi,

Thank you providing for information. You can see here geo_target_country field. Let me know if you have any question.