Big Query - Google Ads Targeted Location issue.

[Tauras Ale]

Hey, I've got an issue:

On Google Ads Web every Campaign has its Targeted Location and user can track what is Campaign Cost distribution across these Locations.

After data transfer to the Google Big Query, there is table ads_CampaignBasicStats_xxxx which contains data on date, campaign_id, spend. However it seems to be impossible to divide this spend by a Targeted Location.

I've noticed its possible to map, which locations are targeted by campaign mapping criterion_ids in LocationBasedCampaignCriterion  table, however it still does not solve getting to know what is the distribution of spend across these targeted locations.

This is only the case for the campaigns that have > 1 Targeted Locations.

Thanks for your help!

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Based on the provided information, I could see that you are using Big query tables. With this, I would recommend that you reach out to the GCP Product support team for further assistance. Please note that our team can only assist with the technical queries or concerns related to the Google Ads API.

Also, as per the Google Ads API, you can refer to the Location Targeting document for more information. You can retrieve the geo targets using the campaign_criterion report. 
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tPJA1:ref" (ADR-00232554)

Thanks,
 

Google Ads API Team