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:
-
Make sure that your Report definition contains the following relevant segments fields from Google:
-
You have the following options:
-
If you choose to enable metadata tables, make sure that
geo_target
andcampaign_criterion_history
metadata tables are selected in your schema tab. -
If you choose to download the list of geo targets from Google:
- Download the list of geo targets from Google
- Create the list as a table in your Google Ads destination schema.
- In your Fivetran dashboard, click Uploads and then click + Schema.
- Enter your existing destination’s Schema Name.
- Enter the Table name,
- Click Create Table.
-
-
Perform a
left join
operation in your destination to link them with the following fields:<google-ads-schema>.<geo-performance-report-table>.<geo_target_county> = <google-ads-schema>.<geotargets-table>.<id>
NOTE: Report segments contain
resource_name
ofgeo_target
, which has thegeoTargetConstant/
prefix.
Causelink
Google’s API doesn’t provide the location name as an available field for the Geographic View.