Country/City Field errors in GEO_PERFORMANCE_REPORT

[Shiva Kumar Eravelly]

Hi Team,

I am executing the below AWQL for GEO_PERFORMANCE_REPORT, The data looks good for all fields but for CityCriteriaId and CountryCriteriaId the data is showing up in numbers rather than their specific Country/City which should be strings. Can you please provide me your feedback here

report_query = (adwords.ReportQueryBuilder()
.Select('CampaignId', 'CampaignName', 'CampaignStatus', 'CityCriteriaId',
'CountryCriteriaId', 'Clicks', 'ConversionRate', 'Conversions', 'ConversionValue', 'Cost', 'CostPerAllConversion', 'CostPerConversion',
'CrossDeviceConversions', 'Ctr', 'CustomerDescriptiveName', 'Date', 'DayOfWeek')
.From('GEO_PERFORMANCE_REPORT')
.During('YESTERDAY')
.Build())  

[Google Ads API Forum Advisor]

Hello Shiva,

Thank you for reaching out to us.

Upon checking on the GEO_PERFORMANCE_REPORT's documentation, both CityCriteriaId and CountryCriteriaId returns the ID of the Location associated with the impression and not the actual Country/City strings. From that guide also, you can look up the corresponding name and other information using LocationCriterionService.

As an aside, please note that the AdWords API is deprecated and will be sunset on April 27, 2022. We strongly recommend that you migrate to the Google Ads API as soon as possible.

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2PJ4uA:ref