Hi Aryeh, Going with your first query, how do you get the targeted country for the campaign please? I understood that we can get the country code like FR for France if France is targeted by this campaign?
Thank a lot! Le jeudi 10 mars 2022 à 15:53:56 UTC+1, adsapi a écrit : > Hi Scratch, > > To get all your targeted and excluded geographic locations per campaign > you can 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 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. > > To interpret what a location is, you can query "SELECT > geo_target_constant.target_type, geo_target_constant.status, > geo_target_constant.resource_name, geo_target_constant.parent_geo_target, > geo_target_constant.name, geo_target_constant.id, > geo_target_constant.country_code, geo_target_constant.canonical_name FROM > geo_target_constant". If you want to know the parent location you can trace > it in the results. > > Regards, > > [image: Google Logo] > Aryeh > Google Ads API Team > > > ref:_00D1U1174p._5004Q2XmRLE:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/02a7e139-f543-4639-b5e3-eeb0f30ab4dbn%40googlegroups.com.