How can I add the country name to the "user_location_view_by_campaign_report" in the Google Ads integration?
Question Description:
The "user_location_view_by_campaign_report" table inside the Google Ads integration provides you with campaign performance data per country. You will notice that this table does not include any country names but instead provides you with a column called "country_criterion_id".
➡️ How can you add the country name to the "user_location_view_by_campaign_report"?
Answer:
Google provides this lookup table to match the respective "country_criterion_id" with the respective country name:
https://developers.google.com/adwords/api/docs/appendix/geotargeting
Download the latest CSV and import the file to Y42 by using the CSV integration. Then you just need to use a JOIN to mapp the country name to the country id. The JOIN key you need to use are:
user_location_view_by_campaign_report | geo targets table |
country_criterion_id | Parent ID |
Was this article helpful?