I use simple query to extract the information about the campaign of certain account:
query = """
segments.date,
location_view.resource_name,
metrics.clicks,
metrics.impressions,
metrics.conversions,
metrics.cost_micros
FROM location_view
WHERE segments.date > '2020-07-01' AND segments.date < '2021-07-21'
ORDER BY
segments.date ASC """
However, it extracts all the campaigns but one. I tried using the geographic_view source instead, and it solved the problem of downloading, however I need information regarding the regions from the location_view source.
I am looking forward to someone's assistance
Arkadiy Voronkin