谷歌广告脚本AWQL "CONTAINS_ANY“运算符不起作用

Question

我正在尝试通过某些规则提取搜索查询，并且我需要获取包含给定字符串之一的查询：

    " WHERE " +       
       " Impressions > " + IMPRESSIONS_THRESHOLD +
       " AND AverageCpc > " + AVERAGE_CPC_THRESHOLD +
       " AND Query CONTAINS_ANY ['for sale in', 'buy'] " +        
   " DURING YESTERDAY ");

但我收到错误消息(尝试不同的变体)：

One of the conditions in the query is invalid. (file Code.gs, line 19)

尽管看起来我做的每件事都是根据形式语法：

String           -> StringSingleQ | StringDoubleQ
StringSingleQ    -> '(char)'
StringDoubleQ    -> "(char)"
StringList       -> [ String (, String)* ]

如果我只做一个字符串，它工作得很好：

 " WHERE " +       
       " Impressions > " + IMPRESSIONS_THRESHOLD +
       " AND AverageCpc > " + AVERAGE_CPC_THRESHOLD +
       " AND Query CONTAINS 'for sale in' " +
        
   " DURING YESTERDAY ");

Answer 1

IIRC，只有在对标签进行过滤时，CONTAINS_ANY运算符才有效。我不确定是否确实记录了这个约束，但this article似乎至少暗示了这一点。