How to Find the City, Country, or Region Name From My Geographic View / User Location View report

Question

I can't find the names of the city, country, or region when I pull a Geographic View / User Location View through my Google Ads connector. How do I get these?

Environment

Connector: Google Ads

Answer

To find the names of the city, country, or region, 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 connector 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 connector 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.

Cause

Google's API doesn't provide the location name as an available field for the Geographic View.