您可以使用 Merchant Center 查询语言来过滤返回的数据集
以及许多不同的运算符根据字符串值进行过滤时，
每个运算符的默认大小写区分在
过滤搜索结果。
运算符
区分大小写
= 或 !=
区分大小写
（非）IN
区分大小写
（非）赞
区分大小写
包含 (...)
区分大小写
REGEXP_MATCH
（可选）
示例
SELECT
segments.offer_id,
metrics.clicks
FROM MerchantPerformanceView
WHERE segments.offer_id REGEXP_MATCH "(?i)AmazingOffer\d+"
AND segments.date BETWEEN '2021-01-01' AND '2021-01-31'
[null,null,["最后更新时间 (UTC)：2024-09-20。"],[[["The Merchant API is the new version of the Content API for Shopping and represents the future of the platform."],["Developers can learn more about the Merchant API and its benefits in the official announcement blog post."],["Merchant Center Query Language allows for data filtering with various operators, with differing case sensitivities for string values."],["The `REGEXP_MATCH` operator is case-sensitive by default, but offers case-insensitivity through the `(?i)` flag."]]],["The Merchant API beta, a new version of the Content API for Shopping, is introduced. The Merchant Center Query Language allows data filtering using operators. The operators `=`, `!=`, `(NOT) IN`, `(NOT) LIKE`, and `CONTAINS` are case-sensitive. `REGEXP_MATCH` is case-sensitive by default, but can be made case-insensitive with `(?i)` as defined in RE2 syntax. An example is provided showing filtering for `offer_id` with a case-insensitive regular expression.\n"]]
