AWQL: Possible to use IN operator for matching strings that contains a phrase?

[Jonas Bolin]

Hello guys,

I would like to run a report where which returns all search terms and their corresponding cost where the query contains one of the following: ['football', 'soccer','rugby']

var query = "select Query, Cost from SEARCH_QUERY_PERFORMANCE_REPORT where Query IN ['football', 'soccer','rugby'] during 20171201,20171231"

Now the above query returns exact matches, but I would like it to return broad matches, where the Query CONTAINS any of the words in the list.

Is this possible in AWQL somehow?

[Dhanya Sundararaju (AdWords API Team)]

Hi Jonas,

You will be able to use CONTAINS or CONTAINS_IGNORE_CASE to return broad matches for each value. The closest you may be able to get to, is to include all possible search terms in your IN StringSet. Let me know if you have further questions.

Regards,

Dhanya, API AdWords Team