For some accounts, the query below does not return all the clicks, impressions, and cost bc segmenting by keyword does not comprehensively cover all the activity. Afaik, it cannot return null or empty string for the keyword and I can't add `where segment.keyword.ad_group_criterion is null` to get the complement. Am I missing something or do I need to get it w and wo the segment and subtract the segmented values from the composite to get the complement?
SELECT ad_group_ad.ad.id, customer.id, segments.date, segments.keyword.ad_group_criterion, metrics.cost_micros, metrics.clicks, metrics.impressions FROM ad_group_ad WHERE segments.date = '2022-01-17' AND metrics.impressions > 0 Don Mitchell principal architect automated traffic acquisition cargurus -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 on the web visit https://groups.google.com/d/msgid/adwords-api/632274c7-f9a1-43b8-a45b-4504bd2be293n%40googlegroups.com.
