Stay organized with collectionsSave and categorize content based on your preferences.
The Merchant Center Query Language lets you filter the returned data set
with a number of different operators. When filtering on string values, the
default case sensitivity of each operator plays an important part in correctly
filtering your results.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-13 UTC."],[[["\u003cp\u003eThe Merchant API is the new version of the Content API for Shopping and represents the future of the platform.\u003c/p\u003e\n"],["\u003cp\u003eDevelopers can learn more about the Merchant API and its benefits in the official announcement blog post.\u003c/p\u003e\n"],["\u003cp\u003eMerchant Center Query Language allows for data filtering with various operators, with differing case sensitivities for string values.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eREGEXP_MATCH\u003c/code\u003e operator is case-sensitive by default, but offers case-insensitivity through the \u003ccode\u003e(?i)\u003c/code\u003e flag.\u003c/p\u003e\n"]]],["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"],null,["# Case sensitivity\n\nThe Merchant Center Query Language lets you filter the returned data set\nwith a number of different operators. When filtering on string values, the\ndefault case sensitivity of each operator plays an important part in correctly\nfiltering your results.\n\n| Operators | Case Sensitivity |\n|----------------|------------------|\n| = or != | Case sensitive |\n| (NOT) IN | Case sensitive |\n| (NOT) LIKE | Case sensitive |\n| CONTAINS (...) | Case sensitive |\n| REGEXP_MATCH | Optionally Both |\n\n| **Key Point:** `REGEXP_MATCH` and `NOT REGEXP_MATCH` are case-sensitive by default, but you can include `(?i)` as described in the [RE2 syntax](https://github.com/google/re2/wiki/Syntax) to make them case-insensitive.\n\nExample\n-------\n\n SELECT\n segments.offer_id,\n metrics.clicks\n FROM MerchantPerformanceView\n WHERE segments.offer_id REGEXP_MATCH \"(?i)AmazingOffer\\d+\"\n AND segments.date BETWEEN '2021-01-01' AND '2021-01-31'"]]
