Hey, thanks for reaching out. This is exactly what I was looking for. So, what I'm doing now is collecting the metrics I need from `geographic_view`. I extract all the `geographic_view.country_criterion_id`s from your response, and use that in a follow up query to `geo_target_constant`. My followup query returns the `country_criterion_id`s mapped to their real name. Following receipt of this map, I update reports by replacing all the `country_criterion_id`s with their actual country name. This works great.
Separately, there's an issue where the results from the `geographic_view` don't match results from the Google Ads web interface. Surprisingly, I have found that several countries don't even show up in my results when queried via API, but those countries are showing up with impressions, clicks, and ad-spend when I look from the web UI. If you're able to help me with this separate issue, I've created a thread [here](https://groups.google.com/g/adwords-api/c/RsTWTRrPP5c). Kind regards, On Friday, April 28, 2023 at 12:18:57 PM UTC-7 Google Ads API Forum Advisor wrote: > Hi Chad, > > Thanks for reaching out to Google Ads API Forum. > > With regards to your concern, you may refer to our *Geo targets* > documentation. > You may see in this documentation the updated *CSV geo targets* file to > be downloaded. For the *country_code* you may refer to the > *GeoTargetConstant* documentation for more information. > > Additionally, to retrieve geo targets directly from the Google Ads API, > you may use the *geo_target_constant reporting*. To validate and build > your query you may use the *geo_target_constant query* builder. > > However, if this is not what you are looking for, then can you provide > more context about your issue / concern so that we can provide guidance > accurately or route you to the correct support team regarding your concern? > > Links included in this email: > > - *Geo targets - * > *https://developers.google.com/google-ads/api/data/geotargets* > <https://developers.google.com/google-ads/api/data/geotargets> > - *CSV geo targets - * > > *https://developers.google.com/google-ads/api/data/geotargets#download_csv_of_geo_targets* > > > <https://developers.google.com/google-ads/api/data/geotargets#download_csv_of_geo_targets> > > - *Country_code* - > > *https://developers.google.com/google-ads/api/reference/rpc/v13/GeoTargetConstant#country_code* > > > <https://developers.google.com/google-ads/api/reference/rpc/v13/GeoTargetConstant#country_code> > > - *GeoTargetConstant* - > > *https://developers.google.com/google-ads/api/reference/rpc/v13/GeoTargetConstant* > > > <https://developers.google.com/google-ads/api/reference/rpc/v13/GeoTargetConstant> > > - *geo_target_constant* *reporting* - > > *https://developers.google.com/google-ads/api/fields/v13/geo_target_constant* > > <https://developers.google.com/google-ads/api/fields/v13/geo_target_constant> > > - *geo_target_constant query - * > > *https://developers.google.com/google-ads/api/fields/v13/geo_target_constant_query_builder* > > > <https://developers.google.com/google-ads/api/fields/v13/geo_target_constant_query_builder> > > > > Regards, > [image: Google Logo] Google Ads API Team > > ref:_00D1U1174p._5004Q2l8GNg:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/d01b1eb8-d6a8-4352-bac7-2e62aa4a65b0n%40googlegroups.com.