I would like to query for a report avoiding rows with an empty field, for
example right now I'm using this query:
SELECT Id, CampaignName, AdGroupName, DestinationUrl FROM
KEYWORDS_PERFORMANCE_REPORT DURING TODAY
This gets me back all the rows, I would like to avoid rows with an empty
DestinationUrl parameter. I tried this queries:
SELECT Id, CampaignName, AdGroupName, DestinationUrl FROM
KEYWORDS_PERFORMANCE_REPORT WHERE DestinationUrl != '' DURING TODAY
SELECT Id, CampaignName, AdGroupName, DestinationUrl FROM
KEYWORDS_PERFORMANCE_REPORT WHERE DestinationUrl != 'null' DURING TODAY
SELECT Id, CampaignName, AdGroupName, DestinationUrl FROM
KEYWORDS_PERFORMANCE_REPORT WHERE DestinationUrl != 'Null' DURING TODAY
SELECT Id, CampaignName, AdGroupName, DestinationUrl FROM
KEYWORDS_PERFORMANCE_REPORT WHERE DestinationUrl != null DURING TODAY
Other operations work fine, the only thing I can't do is filter by empty
value.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords 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
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
