Date Ranges | Yext Hitchhikers Platform
Overview
This reference doc explains the way date ranges work in Yext Analytics. There are two main types of date ranges – standard and custom – that control what data is displayed in a report or a dashboard.
Standard Date Ranges
Yext Analytics provides a set of standard date ranges out-of-the-box. These are made up of a date range length and an interval “end rule.”
Standard Date Range Length
This is the length of the date range expressed in calendar time. Examples of this include “Last 7 Days” and “Last Month.”
This is the full list of standard date range lengths defined in Yext Analytics:
- Last 7 Days
- Last 14 Days
- Last 30 Days
- Last 90 Days
- Last 4 Weeks
- Last 8 Weeks
- Last 12 Weeks
- Last 16 Weeks
- Last Month
- Last 4 Months
- Last 12 Months
- Last 13 Months
- Last Quarter
- Last 2 Quarters
- Last 4 Quarters
- Last 8 Quarters
- All Time
Interval End Rule
Once a date range length has been defined, the next step to resolving it to an actual date interval is to pick the last date of the interval. Yext Analytics has three defined interval end rules for this:
Interval End Rule | Description |
---|---|
Current | Specifies that resolved intervals should end in the current (partial) period. |
Whole | Specifies that resolved intervals should end in the most recent whole period. |
Completed | Specifies that resolved intervals should end in the most recent whole period which does not run past the relevant completed date. |
Whole weeks always start on a Monday and end on a Sunday. Whole days end on the previous full day (e.g., for a report created today, the report would contain data through the end of yesterday).
Putting it all together, a standard date range is simply a standard date range length paired with an interval end rule.
Completed Dates
The “completed” end rule describes an interval which does not run past a “completed date.” A completed date (also known as a “watermark date”) represents a date for which Yext has received complete data for a family of metrics.
Completed dates can be found in Dashboards by hovering over the tooltip next to “Data available through MM/DD/YYYY”, and in Report Builder under the date range selection window.
There are six publisher-specific completed dates defined in Yext Analytics:
- Bing
- Google My Business
- Google Search Console
- Google Search Keywords
- Extended Listings Network
Metrics can be associated with zero or more completed dates. Any standard date range using the COMPLETED
interval end rule is resolved using the earliest completed date associated with any of the metrics in the query.
For example, if we have the following completed dates on a Listings dashboard:
- Google My Business: 07/02/2023
- Google Search Keywords: 06/30/2023
- Extended Listings Network: 07/03/2023
The data displayed on the dashboard for all metrics would be based on the earliest completed date, which is 06/30/2023.
Custom Date Ranges
Yext Analytics also provides the option to specify custom date ranges. These are simply a set of two fixed dates (e.g., Jan 1, 2023 to Jul 4, 2023), and the data displayed will reflect the data for the whole period between those dates.