Geographic view query returns data for multiple geo levels alongside Regions despite filtering for Regions
Komaldeep Singh
Hello Team,
I am trying to get campaign stats segmented by location. When running the following query to retrieve geographic data from the geographic_view:
SELECT
metrics.impressions,
geographic_view.country_criterion_id,
segments.geo_target_region
FROM
geographic_view
I anticipated receiving data solely for regions (segments.geo_target_region). However, the result set also includes other geographic levels such as State, Province, Territory, Neighborhood, Prefecture, District, City regions, etc. This behavior is somewhat confusing and not aligned with the query's intention.
For example, the query returned '20521' as the region id, but this ID maps to a province rather than a region (Link for Geo Targets). Similarly, '20035' and '20129' were returned, which correspond to a State and Canton respectively, rather than a region.
While these are just a few instances, a significant portion of the rows in my report map to geographic levels other than Region.
I anticipate that when filtering by segments.geo_target_region, the query should exclusively return data for regions and not include any other geographic levels.
Could you please confirm whether this behavior is intended, or if it is indeed a bug?
If it is expected, I would appreciate clarification on what geographic levels we can expect when fetching a report for Region and city scope.
Your assistance in clarifying this matter would be greatly appreciated.
Thank you.
