How to Find the City, Country, or Region Name From My Geo Performance Report

Questionlink

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?

Environmentlink

Connector: Google Ads

Answerlink

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. You have the following options:

   • If you choose to enable metadata tables, make sure that geo_target and campaign_criterion_history metadata tables are selected in your schema tab.

   • If you choose to download the list of geo targets from Google:

     1. Download the list of geo targets from Google
     2. Create the list as a table in your Google Ads destination schema.
     3. In your Fivetran dashboard, click Uploads and then click + Schema.
     4. Enter your existing destination’s Schema Name.
     5. Enter the Table name.
     6. Click Create Table.

   

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.

Causelink

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