The issue of inconsistent metrics.click data in geographic_view

[toby xiong]

My GAQL query is as follows:

SELECT customer.id, customer.descriptive_name, campaign.id, campaign.name, ad_group.id, ad_group.name,
geographic_view.country_criterion_id,segments.geo_target_region, segments.date, metrics.clicks,
metrics.conversions_value, metrics.conversions, metrics.cost_micros, metrics.video_views, metrics.impressions
FROM geographic_view WHERE segments.date during LAST_30_DAYS

However, when I sum the clicks in the result, it is smaller than the actual data. I know the reason is because I included segments.geo_target_region, which causes the results to be automatically filtered. When I remove this field, the data matches correctly. What I want to know is how I can include all the data. I have tried using WHERE segments.geo_target_region IS NULL, but the result returned is empty.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

In order to assist you further, could you please share the uncropped UI screenshot by highlighting the fields that you are trying to retrieve from the geographic_view report via the Google Ads API?

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-02-26 10:50:49Z GMT] This message is in relation to case "ref:!00D1U01174p.!5004Q02vH3zQ:ref" (ADR-00289860)