Hello, I am trying to make a GAQL query for campaigns *of* specific advertising channel type *and excluding* all campaigns where advertising channel type is set.
While this query returns many campaigns where majority *doesn't *have advertising channel subtype set: SELECT metrics.clicks, campaign.advertising_channel_type, campaign.advertising_channel_sub_type FROM campaign Then this query *doesn't* return any campaigns at all. Expected is that it will return all those campaigns of SEARCH and SHOPPING without advertising channel subtype set: SELECT metrics.clicks, campaign.advertising_channel_type, campaign.advertising_channel_sub_type FROM campaign WHERE campaign.advertising_channel_sub_type NOT IN ( 'SEARCH_EXPRESS', 'DISPLAY_EXPRESS', 'DISPLAY_SMART_CAMPAIGN', 'SHOPPING_SMART_ADS' /* and all the other advertising sub channel types */ ) Is there a way to query for all campaigns where *advertising_channel_sub_type* is NULL/EMPTY/NOT SET? Best, Ales -- -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/cf2f9b91-6e78-4c12-9cea-b7ff9bf3b55en%40googlegroups.com.
