Stay organized with collections
Save and categorize content based on your preferences.
AI-generated Key Takeaways
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 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 2025-08-13 UTC."],[],["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"]]
