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! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/G7O9K000000000000000000000000000000000000000000000SH51F000s3nzhkI6S9KO3pPEwvbhqg%40sfdc.net.
