Hi,
It is disappointing because you are not answering my question. Although I think my question was clear, you are responding other questions, not mine.
I asked about how to get absolute_top_impression_percentage/top_impression_percentage data and country/region/city data on the same report.
On the AdWords API that was possible in the GEO_PERFORMANCE_REPORT. I wrote an example of select query above. But this API will be deprecated.
On the new Google Ads API that is NOT possible. Because in the user_location_view you can't get absolute_top_impression_percentage/top_impression_percentage. And in the campaign report you can't get country/region/city. There is absolutely no report in which both sets of data (absolute_top_impression_percentage/top_impression_percentage AND country/region/city) can be queried.
AdWords API, YES.
Google Ads API, NO.
Which leads to me to think that this change was done by Google ON PURPOSE to prevent users from that useful combination of data. You don't want your users to get metrics about the position of the published ads in the geographic reports. You want that data only for yourself in order to have advantage over your own users that pay your campaigns.
That's disappointing.
David