If you had the list of final urls including the text you are looking for
(so all possible URLs in your account including "Prd") you would be able to
use CONTAINS_ANY.
Dismiss my comment if that list is not possible to get.
On Wednesday, December 29, 2021 at 6:30:37 PM UTC+1 goingdev wrote:
> Well if they downgraded and pulled that functionality from the new
> version, then I don't have a choice.
>
> But otherwise, ideally for both sides, I would only pull the keywords that
> I need for the job at hand, instead of querying and looping through some
> extra couple of thousand keywords unnecessarily.
>
> On Wednesday, December 29, 2021 at 11:56:03 AM UTC-5 Mat wrote:
>
>> You don't.
>> You'd have to do that on your end (as in iterating through the rows of
>> the response and check the values). Something like this:
>>
>> for final_url in row.ad_group_criterion.final_urls:
>> if "Prd" in final_url:
>> ...
>>
>> goingdev schrieb am Mittwoch, 29. Dezember 2021 um 17:41:43 UTC+1:
>>
>>> Correct. So the question remains:
>>>
>>> *How do I search keywords which contain a specific text in the
>>> FinalUrl? *
>>>
>>> With the old Google Adwords, the CONTAINS predicate acted like a LIKE
>>> operator, and I was able to successfully search keywords based on a
>>> substring within the FinalUrl:
>>> *new Predicate{ field = "FinalUrls", @operator =
>>> PredicateOperator.CONTAINS, values = new string[]{"/Prd/"}}*
>>>
>>> However, with the new Google Ads API, using CONTAINS ANY does not search
>>> substrings; only complete values of the FinalUrl. The following does not
>>> work:
>>> *WHERE ad_group_criterion.final_urls CONTAINS ANY ('/Prd/')*
>>> On Wednesday, December 29, 2021 at 11:11:50 AM UTC-5 Mat wrote:
>>>
>>>> Hi goingdev,
>>>>
>>>> I guess that the LIKE operator is not valid/available for the field
>>>> "ad_group_criterion.final_urls", because that field is actually a list of
>>>> strings, despite of being classed as "STRING" in the reference
>>>> <https://developers.google.com/google-ads/api/fields/v9/ad_group_criterion#ad_group_criterion.final_urls>
>>>> .
>>>>
>>>> Regards
>>>> Mat
>>>> goingdev schrieb am Dienstag, 28. Dezember 2021 um 20:58:13 UTC+1:
>>>>
>>>>> Question: How do I search keywords which contains specific text in the
>>>>> FinalUrl using GAQL?
>>>>>
>>>>> The query builder UI doesn't give an option for using LIKE. It only
>>>>> gives options for CONTAINS ALL, CONTAINS ANY and CONTAINS NONE.
>>>>>
>>>>>
>>>>> https://developers.google.com/google-ads/api/fields/v9/ad_group_criterion_query_builder
>>>>>
>>>>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/74f61250-2595-408c-814c-56dbdb682ce7n%40googlegroups.com.
