To create a chart showing the average consecutive days of active users on a particular day in Mixpanel, you should use the Retention report with the "Streak mode" retention criteria. "Streak mode" is designed to count unique users who perform consecutive actions across time intervals, such as users who are active for several consecutive days since a starting event (e.g., sign-up or first activity).
Here’s how you can approach this:
1. Go to Reports > Retention in Mixpanel.
2. Set your Retention Behavior: Choose the event that marks the start of the streak (e.g., "Sign Up Completed" or "Any Event").
3. Set the Retention Criteria to "Streak mode": This will count users who are active for consecutive days.
4. Choose the Measurement: Use "Unique Users" to see how many users have a streak of X consecutive days.
5. Visualize the Data: Use the line or retention curve visualization to see how the number of users with different streak lengths changes over time.
While this setup will show you the distribution of users by their streak length (e.g., how many users had a 2-day, 3-day, 4-day streak, etc.), Mixpanel does not natively provide a direct "average consecutive days active" metric per day. However, you can approximate the average by analyzing the streak distribution and calculating the weighted average streak length outside Mixpanel if needed.
Reference:
Streak mode is described as:
“Streak mode is mostly meant to count unique users doing consecutive actions across time intervals. For example, played a game for 5 consecutive days since sign-up…”
Docs: Retention - Retention Criteria
If you need the exact average value visualized directly in Mixpanel, the knowledge sources do not specify a built-in function for this, so you may need to export the streak data and calculate the average externally.
