The new Search Ads 360 Reporting API is now available. Join the searchads-api-announcements Google group to stay up to date on upcoming enhancements and releases.
Stay organized with collections
Save and categorize content based on your preferences.
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:
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-03 UTC."],[[["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`, `\u003e=`, and `\u003c=`."],["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 uses custom or predefined date ranges. Custom ranges utilize ISO 8601 format (YYYY-MM-DD) for specific dates (e.g., `segments.date BETWEEN '2019-01-01' AND '2019-01-31'`). For segments like `week`, `month`, or `quarter`, filters must use the first day of the period. Predefined ranges, such as `TODAY`, `LAST_7_DAYS`, or `LAST_MONTH`, offer shortcuts (e.g., `segments.date DURING LAST_30_DAYS`).\n"]]
