Geo performance report city and names localized

[Michele Valsecchi]

Hello, I have spent the last few hours googling and lurking in this forum for an answer but I found nothing. I hope the answer is not anywhere in plain sight. In that case I apologize in advance.

I'd like to get a report with City and region names in a language different than English (Japanese in this case).

  var report = AdWordsApp.report(

    "SELECT CampaignName, AdGroupName, Device , AverageCpc, AdGroupId, Clicks, AveragePosition, CountryCriteriaId, RegionCriteriaId, CityCriteriaId " +

    "FROM   GEO_PERFORMANCE_REPORT " +

    "WHERE  Impressions > 0 AND AdGroupStatus = 'ENABLED' AND Clicks > 0 AND Device != 'UNKNOWN' " +

    "DURING "+dates[0]+","+dates[1]);

Even if in the documentation ( https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report#citycriteriaid) it clearly states that CityCriteriaId  should be an Integer I get a String containing the name of the city in English.

The same goes for RegionCriteriaId and CountryCriteriaId.

1) Is there a way to get Country/ Region/ City names in a language other than English?

2) If there isn't, how do I get the RegionCriteriaId,CityCriteriaId and CountryCriteriaId as an Integers ?

Thank you very much.

[Tyler Sidell (AdWords Scripts Team)]

Hi Michele,

To answer your questions, currently there is not a way to get the names of the countries, regions, and cities in a language other than English.  It should be returning as integer as stated in our documentation, so I will discuss this with the rest of the team and provide updates when we have more information.

Thanks,

Tyler Sidell

AdWords Scripts Team

[Michele Valsecchi]

Hi Tyler,

thank you very much for your fast reply! I'll looking forward for your update then!

Michele

[Tyler Sidell (AdWords Scripts Team)]

Hi Michele,

Thank you for your patience. In order to get the geolocations to appear as integers, you would need to set resolveGeoNames to false. The default is set to true which gives you the locations as strings. For more about this feature, you can read about it here.

Thanks,
Tyler Sidell
AdWords Scripts Team