Hi all,
Recently I started to convert some report and I have the feeling I am missing something basic .... here is the issue I run into -1- the segmentation documentation it says that some segments could reduce the number of rows, but is not specific. https://developers.google.com/google-ads/api/docs/reporting/segmentation -2- I want ALL the records "with and without segments" meaning all records that have non NULL things "like segment.geo_target_metro" or do not have the geo_target_metro ( have NULL ) ) -3- to be specific , when I add segments.geo_target_metro, we only get the US and Japan, but with OUT geo_target_metro, we get many more countries -4- This is the query, and literally I need to remove all 5 segments ( including segments.device) to be able to get all the rows with all the clicks for all accounts Thoughts ????????? Thank you so much SELECT metrics.average_cpc, campaign.id, ad_group.id, *segments.geo_target_city,*metrics.clicks, metrics.cost_micros, geographic_view.country_criterion_id, *segments.device,*customer.id, metrics.impressions, *segments.geo_target_metro,segments.geo_target_most_specific_location,segments.geo_target_region*FROM geographic_view WHERE metrics.impressions > 0 AND segments.date = '2022-03-31' -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/3463d812-1fbe-46e7-8a58-64525d496529n%40googlegroups.com.