Get Top_Impression_Percentage by Location

[Alessandro Eu]

Hi,

i've few campaigns with locations adjustments.

What i would like to achieve is extract from google ads api data which shows me Campaign Top_Impression_Percentage by location, so something like this:

Campaign A - Location 1 - 35%

Campagin A - Location 2 - 40%

Campagin A - Location 3 - 80%

Campaign B - Location 1 - 35%

Campagin B - Location 2 - 40%

...

I've tried to extract data from location_view ( https://developers.google.com/google-ads/api/fields/v6/location_view ) but it does not have Top_Impression_Percentage ( i thought i could get there through campaign, since it is an attributed resource, but it seems that i can only get fields, not metrics ).

I've tried to tackle the problem starting from Campaign ( https://developers.google.com/google-ads/api/fields/v6/campaign ) cause it has the correct metrics but it seems that i cannot segment by location ( the most similar segments is geo_target_province but if i try to use it a get an error which says ( Cannot select or filter on the following segments: 'segments.geo_target_province'(could not support requested resources: 'CAMPAIGN'), since segment is incompatible with the resource in the FROM clause or other selected segmenting resources. ).

I tried other simliar solution but i can't find a viable way...

I can't understand how to pull this simple set of data.. can someone please help figure out the right query?

Thanks to everyone in advance and happy holidays

[Google Ads API Forum Advisor Prod]

Hi Alessandro,

Thank you for reaching out. Please give it a try to query the Geo Performance Report via the AdWords API. You could include the CountryCriteriaId or other more specific location criteria fields as well as the AbsoluteTopImpressionPercentage metrics in the SELECT clause to fetch the data.

Thanks and regards,
Xiaoming, Google Ads API Team
 

Xiaoming Google Ads API Team

ref:_00D1U1174p._5004Q2AGF5i:ref