Dates in Insights
Insights displays and exports all data according to the time zone of your Insights stream.
The time zone of your Insights stream was set when your Insights stream was created. The time zone of your Insights stream is not necessarily the same as the time zone of your Zuora tenant or your local time zone.
All dates and times referenced in this article are intended to be interpreted in the time zone of your Insights stream. References to 00:00 mean 00:00 in the time zone of your Insights stream.
The time zone of your Insights stream applies to all dates and times in Insights. This includes:
- Dates that you enter in the segment query builder.
- Dates and times displayed in charts and tables.
- Dates and times in exported data.
See Insights APIs for information about how the Insights APIs handle dates and times.
Dates and times in Insights are not affected by the time zone of your browser. As an individual team member, you cannot customize the time zone that Insights uses when displaying dates and times to you.
To inquire about the time zone of your Insights stream, submit a request at Zuora Global Support.
Calendar Dates in Charts and Tables
Insights reports values in charts and tables for specific dates. The following example shows a value of 345 reported for 3/14/2017:
In general, each date in Insights represents a particular time period (day, week, or month) starting at 00:00 on that date. More specifically, the meaning of each date in Insights depends on the type of value being reported:
| Type of Value | Meaning of Date | Example |
|---|---|---|
| Session count | Calendar day. The calendar day begins at 00:00. | If 5 sessions are reported for 3/14/2017 then 5 sessions occurred between 00:00 on 3/14/2017 and 00:00 on 3/15/2017. |
| Event count | Calendar day. The calendar day begins at 00:00. | If 2 Login events are reported for 3/14/2017 then 2 logins occurred between 00:00 on 3/14/2017 and 00:00 on 3/15/2017. |
| Attribute value | Calendar day. The calendar day begins at 00:00. | If an Account Balance of 600 is reported for 3/14/2017 then the last account balance before 00:00 on 3/15/2017 was 600. |
| Daily metric value | Calendar day. The calendar day begins at 00:00. | If an Engagement Score of 80 is reported for 3/14/2017 then the Engagement Score was 80 based on data for the period ending at 00:00 on 3/15/2017. |
| Weekly metric value | Calendar week. The calendar week begins at 00:00 on Monday. | If Total Sessions per Week is reported to be 48 for 3/13/2017 then 48 sessions occurred between 00:00 on Monday 3/13/2017 and 00:00 on Monday 3/20/2017. |
| Monthly metric value | Calendar month. The calendar month begins at 00:00 on the 1st of the month. | If Logins per Month is reported to be 8 for March 2017 then 8 logins occurred between 00:00 on 3/1/2017 and 00:00 on 4/1/2017. |
Date Range Filters in Event Charts and Tables
Insights enables you to filter event charts and tables according to predefined date ranges:
For example, on Wednesday 5/10, some of the available date ranges would correspond to the following periods:
| Sat 4/29 |
Sun 4/30 |
Mon 5/1 |
Tue 5/2 |
Wed 5/3 |
Thu 5/4 |
Fri 5/5 |
Sat 5/6 |
Sun 5/7 |
Mon 5/8 |
Tue 5/9 |
Wed 5/10 |
| Today | |||||||||||
| Last 2 Days | |||||||||||
| This Week | |||||||||||
| Last 7 Days | |||||||||||
| This Month | |||||||||||
More specifically, the available date ranges correspond to the following periods:
| Date Range | Beginning of Period | End of Period |
|---|---|---|
| Today | 00:00 on the current calendar day | 00:00 on the next calendar day |
| Last 2 Days | 00:00 on the previous calendar day | 00:00 on the next calendar day |
| This Week | 00:00 on Monday of the current week | 00:00 on the next calendar day |
| This Month | 00:00 on the last day of the previous calendar month | 00:00 on the next calendar day |
| Last 7 Days | 7 days prior to 00:00 on the current calendar day | 00:00 on the current calendar day |
| Last 30 Days | 30 days prior to 00:00 on the current calendar day | 00:00 on the current calendar day |
| Last 60 Days | 60 days prior to 00:00 on the current calendar day | 00:00 on the current calendar day |
| Last 90 Days | 90 days prior to 00:00 on the current calendar day | 00:00 on the current calendar day |
| Ever | The earliest date of data in your Insights stream | 00:00 on the next calendar day |
Calendar Dates in the Segment Query Builder
You can enter specific dates in segment criteria:
Each date corresponds to 00:00 on the specified calendar day. For example, the date "Tue, 14 March 2017" corresponds to 00:00 on 3/14/2017.
Relative Dates in the Segment Query Builder
You can enter relative dates in segment criteria:
You can specify relative dates in days, weeks, months, or years. Each date is relative to the date that Insights updates the segment, and corresponds to 00:00 on a particular calendar day. For example, when Insights updates the segment on 3/14/2017, the relative date "1 month ago" corresponds to 00:00 on 2/14/2017.
Date Ranges in the Segment Query Builder
You can enter date ranges in segment criteria by choosing a condition then specifying the duration of the date range:
For example, when Insights updates the segment on Wednesday 5/10, some of the possible date ranges would correspond to the following periods:
... |
Sun 4/30 |
Mon 5/1 |
Tue 5/2 |
Wed 5/3 |
Thu 5/4 |
Fri 5/5 |
Sat 5/6 |
Sun 5/7 |
Mon 5/8 |
Tue 5/9 |
Wed 5/10 |
| Before 5/3 | |||||||||||
| On or before 5/3 | |||||||||||
| After 7 days ago | |||||||||||
| On or after 7 days ago | |||||||||||
| Between 5/3 and 5/5 | |||||||||||
| Exactly 1 week ago | |||||||||||
| During this month | |||||||||||
| During last week | |||||||||||
More specifically, the available conditions correspond to the following periods:
| Condition | Beginning of Period | End of Period |
|---|---|---|
| Before | The earliest date of data in your Insights stream | 00:00 on the specified day |
| On or before | The earliest date of data in your Insights stream | 00:00 on the day after the specified day |
| After | 00:00 on the day after the specified day | When Insights updates the segment |
| On or after | 00:00 on the specified day | When Insights updates the segment |
| Between | 00:00 on the first specified day | 00:00 on the day after the second specified day |
| Exactly | 00:00 on the specified day | 00:00 on the day after the specified day |
| During this | 00:00 on the first day of the current calendar week, month, quarter, or year; relative to when Insights updates the segment | When Insights updates the segment |
| During last | 00:00 on the first day of the previous calendar week, month, quarter, or year; relative to when Insights updates the segment | 00:00 on the first day of the current calendar week, month, quarter, or year; relative to when Insights updates the segment |
| Ever | The earliest date of data in your Insights stream | When Insights updates the segment |