Date ranges

We would like to introduce the beta version of the Merchant API. It is the new version of the Content API for Shopping and the future.

For information about how Merchant API can improve your integration and how you can help shape the future, see Announcing the Merchant API Beta.

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:

segments.date BETWEEN '2021-01-01' AND '2021-01-31'

OR:

segments.date >= '2021-01-01' AND segments.date <= '2021-01-31'

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:

WHERE segments.date DURING LAST_30_DAYS

Check out the Merchant Center Query Language grammar for the list of available relative date ranges.