Hi Ales,
Thank you for returning back to us.
There is a value in campaign.advertising_channel_sub_type field field which
will be returned when advertising channel sub-type is not specified in a
campaign, and this value is UNSPECIFIED. With this, I would suggest filtering
the said field with UN
Hi Peter,
Do you have by any chance any update on this topic?
Best,
Ales
On Friday, 29 January 2021 at 11:54:18 UTC+1 Ales Sturala wrote:
> Hi Peter,
>
> I read the documentation already before and tested different options with
> no luck. Query grammar only gives you syntactical options but
Hi Peter,
I read the documentation already before and tested different options with
no luck. Query grammar only gives you syntactical options but not
semantical so it doesn't say which operators are valid for which fields. I
tested *IS NULL *and couple of other approaches but I had no luck gett
Hi Ales,
You can refer to our Query grammar guide to know more on what operators you can
use, depending on your reporting requirement.
Regarding your question about the advertising_channel_sub_type if the value is
not set, you can try and use the IS NULL operator. I hope this helps.
Best regar
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, camp