Stay organized with collections
Save and categorize content based on your preferences.
The Merchant Center Query Language lets you specify a date range using a custom
or relative date range. All requests for metrics must include a condition for
segments.date in theWHERE clause to indicate the time period from which
you want to retrieve your performance data.
Custom date range
You can specify dates in ISO 8601(YYYY-MM-DD) format:
You can define date strings with either single quotes (') or double quotes
("). However, you must be consistent; for example: "2021-01-01' is not a
valid date string.
Relative date range
In addition to custom date ranges, you can specify a relative date range such
as LAST_30_DAYS or THIS_MONTH by using DURING instead of BETWEEN and
AND:
[[["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 2024-10-16 UTC."],[[["The Merchant API is the new version of the Content API for Shopping and represents the future of the platform."],["All Merchant Center Query Language requests for metrics require a `segments.date` condition in the `WHERE` clause to specify the desired time period for performance data retrieval."],["Date ranges can be specified using custom ISO 8601 formatted dates or relative date ranges like `LAST_30_DAYS` using `DURING` in the `WHERE` clause."]]],["The beta version of the Merchant API, the new Content API for Shopping, is introduced. All requests for performance metrics require a `segments.date` condition in the `WHERE` clause. Dates can be specified in ISO 8601 format within a custom range using `BETWEEN` or `\u003e=` and `\u003c=`. Alternatively, relative date ranges like `LAST_30_DAYS` can be specified with `DURING`. For a list of available date ranges, the grammar documentation should be consulted.\n"]]