The Google Ads Query Language allows you to specify the date range in two ways:
custom date range
predefined date range
Custom date range
You can specify dates in ISO 8601(YYYY-MM-DD) format:
segments.date BETWEEN '2019-01-01' AND '2019-01-31'
segments.date >= '2019-01-01' AND segments.date <= '2019-01-31'
Predefined date range
The list of valid predefined date ranges is as follows:
| Date range | Reports are generated for... |
|---|---|
TODAY |
Today only. |
YESTERDAY |
Yesterday only. |
LAST_7_DAYS |
The last 7 days not including today. |
LAST_BUSINESS_WEEK |
The 5 day business week, Monday through Friday, of the previous business week. |
THIS_MONTH |
All days in the current month. |
LAST_MONTH |
All days in the previous month. |
LAST_14_DAYS |
The last 14 days not including today. |
LAST_30_DAYS |
The last 30 days not including today. |
THIS_WEEK_SUN_TODAY |
The period between the previous Sunday and the current day. |
THIS_WEEK_MON_TODAY |
The period between the previous Monday and the current day. |
LAST_WEEK_SUN_SAT |
The 7-day period starting with the previous Sunday. |
LAST_WEEK_MON_SUN |
The 7-day period starting with the previous Monday. |
Example:
segments.date DURING LAST_30_DAYS