How do I filter out keywords where FinalURL is blank/empty?

125 views
Skip to first unread message

Temla

unread,
Jun 29, 2015, 6:26:13 AM6/29/15
to adwor...@googlegroups.com
Hi, how should my predicate look like if I want to select keywords where FinalUrls is empty/blank? 

For the old Destination URL I used this

{:field => 'DestinationUrl', :operator => 'STARTS_WITH_IGNORE_CASE', :values => ['http']}

but for the new I change to this

{:field => 'FinalUrls', :operator => 'NOT_EQUALS', :values => ['']}

Is that the right way to do it?

Umesh Dengale

unread,
Jun 29, 2015, 7:28:17 PM6/29/15
to adwor...@googlegroups.com, ggu...@gmail.com
Hello,

In your first line of code use 'FinalUrls' instead of  'DestinationUrl'  (e.g.   {:field => 'FinalUrls', :operator => 'STARTS_WITH_IGNORE_CASE', :values => ['http']})

Regards,
Umesh, AdWords API Team.

Temla

unread,
Jun 30, 2015, 1:20:04 AM6/30/15
to adwor...@googlegroups.com, ggu...@gmail.com
But FinalUrls is a Set and the STARTS_WITH_IGNORE_CASE operator is used with Strings?

Michael Cloonan (AdWords API Team)

unread,
Jun 30, 2015, 12:50:32 PM6/30/15
to adwor...@googlegroups.com, ggu...@gmail.com
Hello,

Your initial approach is correct. I just tested this, and you can use EQUALS and NOT EQUALS with :values set to [''] to find ads with no final URLs or that have final URLs, respectively.

Regards,
Mike, AdWords API Team

Michael Cloonan (AdWords API Team)

unread,
Jun 30, 2015, 1:21:44 PM6/30/15
to adwor...@googlegroups.com, adwordsapiad...@google.com, ggu...@gmail.com
Hello,

I actually did a little more research, and STARTS_WITH type filters should also work for this, as long as you only have a single URL. I believe if there are multiple URLs in the list, then it will concatenate them before applying the filter, which would also work if you're just looking for the string 'http'.

Regards,
Mike, AdWords API Team
Reply all
Reply to author
Forward
0 new messages