Google Ads API is returning to beta status. Please read our blog post for more details.

Date Ranges

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