Every query requires you to select a date range. In Cohort, the date range refers to the time period during which a user completes the first step of the cohort query, defined in Row A. All new queries default to Last 30 Days. To open the date range selector dropdown, click on “Last 7 Days.” The start date is the first day to be included in the search. The end date is the last day.
Every cohort is defined by a first event, a breakout, and a second event. To appear in the results, a user must complete the first event and also have a defined value in the breakout. Breakouts may be an Event Property, a User Property, or a User Segment; or they may be a Generation; or they may be a combination. A Generation is a time-based grouping that describes the cohort. It describes when the first event occurred. You may select Hour, Day, Week, or Month. For example, to create monthly cohorts of users using the date they signed for a newsletter, the first event would be “Newsletter Signup” and the generation would be “Monthly.” This will produce a list of all users who signed up for the newsletter, broken out by month: January Sign ups, February Sign ups, March sign ups, etc.
To select fixed start and end dates, use the date range selector on the left side of the dropdown, you may select a start date and end date from the calendar. You can also enter a specific date by clicking on the date at the top of the selector and entering a value. Use the left and right arrows to navigate the calendar. Select the “Today” checkbox to create a dynamic end date.
The right side of the dropdown lists all of the dynamic date ranges that are available. You may choose a dynamic date range, for example “Last 7 Days” or “Last Full Month.” This will automatically update the date range of your query each time you view it, counting backwards from today. If you select “Last Full Week,” then Indicative will analyze the most recent complete week, defined as Monday to Sunday. If you select “Last Full Month,” then Indicative will analyze the most recent complete month. You can quickly navigate the calendar to select full months using the links in the lower left corner of the dropdown.
To save a custom date range, for example “Last 45 Days,” simply click “Add Custom Date Range” in the lower right corner of the dropdown. Your previously used custom date ranges will be saved for future use and are viewable alongside the default dynamic date ranges.
In Cohort, the interval describes the time period during which a user completes the Target Behavior, defined in Row C. You may choose Hourly, Daily, Weekly, or Monthly intervals. Interval options are dependent on the generation and date range selected. For example, if the selected date range is “Last 7 Days,” then the available time intervals will be “Hourly” and “Daily.” “Weekly” will not be available because there is only one week in a seven day date range. If the date range is changed to “Last 90 Days,” then the intervals dropdown will update with the additional options of “Weekly” and “Monthly,”but will no longer allow “Hourly” analysis due to the inability to visualize. To calculate the total event count or user count across an entire date range, select “Full Range.” Hourly intervals are only available if a cohort is defined by an Hourly or Daily generation.
In the results section, intervals are listed as columns. Interval 1 is the same interval during which the first event was completed. Interval 2 is the next interval after, and so on. If the interval is set to “Daily” and a user completed the Target Behavior within the same day, then they will appear in Day 0.
Recurring vs First-Time
You may adjust your Cohort query to observe the frequency of recurring Target Behavior or to measure the first time that the Target Behavior occurred after completing the first event. If a query is set to Recurring, then a user will appear multiple times within a row, describing how often the user repeated the Target Behavior. If a query is set to First-Time, then a user will appear only once in a row, describing when they completed the Target Behavior.
To exemplify the difference between recurring and first-time cohort queries, consider a box subscription company that wants to measure customer behavior among their newsletter subscribers. The first event could be “Newsletter Sign Up” and the Target Behavior could be “Purchase.” User A signed up for the newsletter in January, and then completed purchases in March, April, and May. In a recurring cohort query, the user will appear in the January cohort row, and they will appear in the Month 3, Month 4, and Month 5 columns. In a first-time cohort query, the user will appear only in the Month 3 column.
Cumulative vs Non-Cumulative
All new queries default to the Non-Cumulative setting. Non-Cumulative cohort queries show the count or percentage of users in the cohort who performed the target behavior within the interval. Cumulative cohort queries show the count or percentage of users in the cohort who performed the target behavior as a running total over time. Cumulative counts are only available for queries measuring first-time behavior. For a full explanation of Cumulative and Non-Cumulative, click here.