Fetching Campaign Target Locations

[Bimal Ram]

Hi Team,

Is it possible to get the targeting location details such as the name etc of a specific campaign rather from a single query resource such as 'campaign', rather than querying from 'campaign_criterion' and then using the geo target constants to query from 'geo_target_constant' to get the location names?

Thank you, Regards

[Google Ads API Forum Advisor]

Hi,

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

With regards to your concern, you can use the geographic_view report, and you can pull fields from the campaign reports in the "attributed resources”.To specifically answer your question, you can add campaign.name in the geographic_view report.

To get all your targeted and excluded geographic locations per campaign, you can refer to the following query:

• SELECT campaign.id, campaign_criterion.location.geo_target_constant, campaign_criterion.negative, campaign_criterion.type FROM campaign_criterion WHERE campaign_criterion.type = 'LOCATION'. The negative criterion are the excluded places.

To get metrics per targeted location per campaign, you can refer to the following query: 

• SELECT metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.impressions, campaign_criterion.location.geo_target_constant, campaign.id FROM location_view WHERE segments.date BETWEEN '20220101' AND '20220310', you can change the date between in the 'WHERE' CLAUSE.

I hope it helps. 

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

Thanks,
 

Google Ads API Team

Register for the upcoming workshop: Performance Max and the Google Ads API!