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?
Connector: Google Ads
To find the names of the city, country, or region, do the following:
Make sure that your Geo Performance Report definition contains the following relevant Criteria ID fields from Google:
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.
Enter your existing destination Schema Name.
Enter the Table name, then click Create Table.
left joinoperation 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>
Google’s API doesn’t provide the location name as an available field for the Geo Performance Report.