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. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/c8b0a7d5-e016-4718-97f5-592089f78798n%40googlegroups.com.
