How to Find Location Names From a Google Geographic View or User Location View Report

The Google Ads API doesn’t return city, country, or region names directly in Geographic View or User Location View reports. Instead, it provides location IDs, which you must map to names using the geo_target table.

To find the location names, do the following:

1. Make sure that your report definition contains the following relevant segments and attributes fields from Google:

   • segments.geo_target_city
   • segments.geo_target_region
   • geographic_view.country_criterion_id / user_location_view.country_criterion_id

   

2. Enable the geo_target table on the Schema tab of the connection details page. Once you enable the table, we will sync Geo targets on the 1st and 15th days of the month.

   NOTE: You can manually re-sync the geo_target table on the Schema tab of the connection details page.

3. Perform a left join operation in your destination to link them with the following fields:

   <google-ads-schema>.<geo-performance-report-table>.<geo_target_city> = <google-ads-schema>.<geotargets-table>.<id>
   

   NOTE: Report segments contain resource_name of geo_target, which has the geoTargetConstant/ prefix.