Date Ranges

The Google Ads Query Language allows you to specify the date range in two ways.

Custom date range

Specify dates in ISO 8601(YYYY-MM-DD) format. Examples:

date BETWEEN '2017-01-01' AND '2017-01-31'

date >= '2017-01-01' AND date <= '2017-01-31'

Predefined date ranges

Use one of the predefined date ranges. Example:

date DURING LAST_30_DAYS

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.

Next steps

Send feedback about...

Google Ads API Beta
Google Ads API Beta
Need help? Visit our support page.