Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
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'
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Falta la información que necesito","missingTheInformationINeed","thumb-down"],["Muy complicado o demasiados pasos","tooComplicatedTooManySteps","thumb-down"],["Desactualizado","outOfDate","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Problema con las muestras o los códigos","samplesCodeIssue","thumb-down"],["Otro","otherDown","thumb-down"]],["Ú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"]]
