How to query multiple & optional CONTAINS

[Janik]

Hi there,

I'm trying to query if an Ad (Headline/Description) contains one or more of several specific phrases.

The logic I'm trying to achieve is: WHERE FieldName CONTAINS ab or bc or cd

AWQL doesnt support OR though. So what would be a suitable workaround?

Thank you in advance!

[Tyler Sidell (AdWords Scripts Team)]

Hi Janik,

There is no OR condition in AdWords Scripts.  You could use CONTAINS_ANY instead.  That would mean that is can contain either ab or bc or cd.

Thanks,
Tyler Sidell

AdWords Scripts Team

[Janik]

Thank you for your answer.

But this is not documented anywhere... What is the syntax? 

CONTAINS_ANY ["ab","bc","cd"] ?

I'm getting a INVALID_PREDICATE_OPERATOR  error when using this with AD_PERFORMANCE_REPORT

[Tyler Sidell (AdWords Scripts Team)]

Hi Janik,

We do have documentation on CONTAINS_ANY but it can only be used for selectors and filtering StringSet variables.  Apologies but this cannot be used for report queries.  You would need to create separate queries for OR conditions.

Thanks,

Tyler Sidell

AdWords Scripts Team

[john....@riseinteractive.com]

Tyler - any change in this since 2016 or any way we can get this updated in a future release?

It would be very useful to be able to run a Contains_* search on the campaign name.

[Adrian Catambay (AdWords Scripts Team)]

Hello,

I am a colleague of Tyler and I will be responding to your inquiry in the mean time.

Currently, you can only use the CONTAINS_ALL [], CONTAINS_ANY [], and CONTAINS_NONE [] operators on fields of type StringSet as specified in this documentation. You may follow our blog for any announcements in case there will be updates in this functionality.

Thanks,

Adrian

AdWords Scripts Team