El lenguaje de consulta de Merchant Center te permite filtrar el conjunto de datos que se muestra.
con varios operadores diferentes. Al filtrar por valores de cadena, el
la distinción entre mayúsculas y minúsculas predeterminada de cada operador desempeña un papel importante en el correcto
filtrar tus resultados.
Operadores
Distinción de mayúsculas
= o !=
Distinción entre mayúsculas y minúsculas
(NO) EN
Distinción entre mayúsculas y minúsculas
(NO) ME GUSTA
Distinción entre mayúsculas y minúsculas
CONTIENE (...)
Distinción entre mayúsculas y minúsculas
REGEXP_MATCH
Ambos opcionales
Ejemplo
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,["Última actualización: 2024-09-20 (UTC)"],[[["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"]]
