Date Ranges

AI-generated Key Takeaways

outlined_flag

• The Google Ads Query Language supports specifying date ranges using custom dates, predefined date ranges, and predefined time periods.

• Custom date ranges can be specified using ISO 8601 format, either extended ( YYYY-MM-DD ) or basic ( YYYYMMDD ).

• Predefined date ranges allow you to query data for common periods like TODAY , YESTERDAY , LAST_7_DAYS , THIS_MONTH , etc.

• Predefined time periods like segments.week , segments.month , and segments.quarter can be filtered using the = operator with the first day of the period.

The Google Ads Query Language lets you specify the date range in these ways:

• Custom date range
• Predefined date range
• Predefined time period

Custom date range

You can specify dates in ISO 8601 extended ( YYYY-MM-DD ) or basic ( YYYYMMDD ) format, for example:

  segments 
 . 
 date 
  
 BETWEEN 
  
 '2024-01-01' 
  
 AND 
  
 '2024-01-31' 
 

  segments 
 . 
 date 
  
> = 
  
 '20241001' 
  
 AND 
  
 segments 
 . 
 date 
  
< = 
  
 '20241031' 
 

Predefined date range

The list of valid predefined date ranges is as follows:

Example:

  segments 
 . 
 date 
  
 DURING 
  
  LAST_30_DAYS 
 

Predefined time period

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. If you specify a date that isn't 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 2024, use the following condition, specifying the first day of that month:

  segments 
 . 
 month 
  
 = 
  
 '2024-05-01'