Date Ranges

AI-generated Key Takeaways

outlined_flag

• The Search Ads 360 Query Language allows specifying date ranges using either custom dates or predefined date ranges.

• Custom date ranges can be defined using ISO 8601 format and operators like BETWEEN, >=, and <=.

• Time period segments such as week, month, and quarter require filtering with the first day of the period using the = operator.

• Predefined date ranges offer shortcuts for common periods like TODAY, LAST_7_DAYS, LAST_MONTH, and others, simplifying query construction.

• Specifying a date that is not the first day of a period for segments like segments.month will result in a MISALIGNED_DATE_FOR_FILTER error.

The Search Ads 360 Query Language lets you 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'

Time periods

Some date fields refer to a predefined period of time, specifically:

• segments.week
• segments.month
• segments.quarter

When filtering on these segments, you can use the = operator with the date that is the first day of the time period. Starting in v9, if you specify a date that is not the first day of a period, a MISALIGNED_DATE_FOR_FILTER error is returned.

For example, to specify the month of May in the year 2021, you would use the following condition, specifying the first day of that month:

segments.month = '2021-05-01'

Predefined date range

The list of valid predefined date ranges is as follows:

Example:

segments.date DURING LAST_30_DAYS