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?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.