Hello Emiliano,
Indeed, "!= ''" does not work as expected, we'll check this behavior. In the meanwhile, you can achieve the same result for most cases with: SELECT Id, CampaignName, AdGroupName, DestinationUrl FROM KEYWORDS_PERFORMANCE_REPORT WHERE DestinationUrl STARTS_WITH_IGNORE_CASE 'http' DURING TODAY -Danial, AdWords API Team. On Friday, June 20, 2014 4:32:10 PM UTC+4, Emiliano Busiello wrote: > > 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.
