Specifying a Date Range
Stay organized with collections
Save and categorize content based on your preferences.
Relative date ranges
Report queries have a date_range field for specifying the dates for which to include
data in the report. The following values can be specified for date_range:
TODAYYESTERDAYMONTH_TO_DATEYEAR_TO_DATELAST_7_DAYSLAST_30_DAYSCUSTOM
Note that the default date range if none is specified is CUSTOM.
Custom date ranges
When date_range is set to CUSTOM or is
unspecified, you must set start_date and end_date to
the (inclusive) start and end dates of the report range.
In your API request's query parameters, the start date parameters will look like this:
startDate.year=2021&startDate.month=3&startDate.day=1
Similarly, the end date parameters will look like this:
endDate.year=2021&endDate.month=3&endDate.day=3
Next steps
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-03-17 UTC.
[null,null,["Last updated 2025-03-17 UTC."],[[["\u003cp\u003eAdSense report queries use a \u003ccode\u003edate_range\u003c/code\u003e field to specify the timeframe for included data, accepting values such as \u003ccode\u003eTODAY\u003c/code\u003e, \u003ccode\u003eYESTERDAY\u003c/code\u003e, or various relative ranges.\u003c/p\u003e\n"],["\u003cp\u003eFor custom date ranges, set \u003ccode\u003edate_range\u003c/code\u003e to \u003ccode\u003eCUSTOM\u003c/code\u003e and specify the inclusive start and end dates using \u003ccode\u003estart_date\u003c/code\u003e and \u003ccode\u003eend_date\u003c/code\u003e parameters.\u003c/p\u003e\n"],["\u003cp\u003eCustom start and end dates are defined by separate parameters for year, month, and day, formatted like \u003ccode\u003estartDate.year=2021&startDate.month=3&startDate.day=1\u003c/code\u003e.\u003c/p\u003e\n"]]],["Report queries utilize a `date_range` field to define data inclusion periods. Available options are `TODAY`, `YESTERDAY`, `MONTH_TO_DATE`, `YEAR_TO_DATE`, `LAST_7_DAYS`, `LAST_30_DAYS`, and `CUSTOM`. The default is `CUSTOM`. When `CUSTOM` is used, `start_date` and `end_date` parameters are mandatory, set via `startDate.year`, `startDate.month`, `startDate.day` and `endDate.year`, `endDate.month`, `endDate.day` in the API request query.\n"],null,["# Specifying a Date Range\n\nRelative date ranges\n--------------------\n\nReport queries have a `date_range` field for specifying the dates for which to include\ndata in the report. The following values can be specified for `date_range`:\n\n- `TODAY`\n- `YESTERDAY`\n- `MONTH_TO_DATE`\n- `YEAR_TO_DATE`\n- `LAST_7_DAYS`\n- `LAST_30_DAYS`\n- `CUSTOM`\n\nNote that the default date range if none is specified is `CUSTOM`.\n\nCustom date ranges\n------------------\n\nWhen `date_range` is set to `CUSTOM` or is\nunspecified, you must set `start_date` and `end_date` to\nthe (inclusive) start and end dates of the report range.\n\n\nIn your API request's query parameters, the start date parameters will look like this: \n\n```\nstartDate.year=2021&startDate.month=3&startDate.day=1\n```\n\nSimilarly, the end date parameters will look like this: \n\n```\nendDate.year=2021&endDate.month=3&endDate.day=3\n```\n\nNext steps\n----------\n\n- [Running Large Reports](/adsense/management/reporting/large_reports)\n- [Filling in Missing Dates](/adsense/management/reporting/missing_dates)\n- [Dates in Report Results](/adsense/management/reporting/handling_results#dates)"]]
