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 Geo Performance Report 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 Geo Performance Report definition contains the following relevant Criteria ID fields from Google:

   • CityCriteriaId
   • CountryCriteriaId
   • RegionCriteriaId

   

2. Download the list of the geo targets from Google.

3. In your Google Ads destination schema, create the list as a table. In your Fivetran dashboard, click Uploads and then click + Schema.

   NOTE: You can also use our File connectors to upload this file to your destination.

4. Enter your existing destination Schema Name.

5. Enter the Table name, then click Create Table.

   

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

   <google-ads-schema>.<geo-performance-report-table>.<country_criteria_id> = <google-ads-schema>.<geotargets-table>.<criteria_id>
   

   

Causelink

Google’s API doesn’t provide the location name as an available field for the Geo Performance Report.