Calculating Day-1, Day-7, and Day-30 Retention for Events
kapa.ai How do I calculate Day-1, Day-7 and Day-30 retention for my events? Give me the exact settings and what to do?
kapa.ai How do I calculate Day-1, Day-7 and Day-30 retention for my events? Give me the exact settings and what to do?
Please stand by Rinitha R. as I search the knowledge base. I normally take about 15 seconds or so. đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To calculate Day-1, Day-7, and Day-30 retention for your events in Mixpanel, you'll need to use the Retention report. Here's how to set it up with the exact settings:
Step 1: Access the Retention Report
Navigate to "Reports" in Mixpanel, then select "Retention" from the available reports.
Step 2: Define Your Retention Behavior
1. Select your initial event (the "A event") - this is typically a key action like "Sign Up Completed" or another important event that represents the start of your user journey. 2. Select your return event (the "B event") - this could be "Any Event" if you want to measure general activity, or a specific event that represents meaningful engagement.
Step 3: Choose Your Retention Criteria
1. Under Retention Criteria, select either: - "On" time interval - to measure users who came back exactly on Day 1, Day 7, or Day 30 - "On or After" time interval (recommended default) - to measure users who came back on or after Day 1, Day 7, or Day 30
The "On or After" option is generally recommended as it gives you a better sense of how long you're holding onto your users in an absolute sense Retention Criteria.2. Set the time unit to "Day" to measure daily retention.
Step 4: Set Your Measurement
Select "Retention Rate" as your measurement to see the percentage of users retained.
Step 5: Set Your Date Range
Choose a date range that gives enough time for your Day-30 retention to be measured (at least 30 days before the current date).
Step 6: View Your Results
The retention report will display a table with rows for each cohort date and columns for each retention day. Look specifically at: - Day 1 column for your Day-1 retention - Day 7 column for your Day-7 retention - Day 30 column for your Day-30 retentionNote that boxes with an asterisk (*) indicate incomplete data because the time period is still ongoing Basic Features.
Alternative Approach: Custom Retention Brackets
If you want to see only these specific days (1, 7, 30) rather than all days in between: 1. Go to the time unit dropdown in the Retention query builder 2. Select "Custom" 3. Define your custom brackets as Day 1, Day 7, and Day 30 4. Apply these settingsThis approach is useful when you only care about specific milestone days rather than the entire retention curve Custom Retention Brackets.Remember that retention counts users, not event totals. Each user cohort bucket includes every unique user that performed your "A event" in that time window, and they can only be counted once per bucket.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
kapa.ai how can i get the reactivation rate for the users?
Let me check the knowledge base for you again. One moment! đź“š
To calculate the reactivation rate for your users in Mixpanel, you'll need to track users who left your product and then returned. Here's how you can approach this:
Using Retention Reports
You can use Mixpanel's Retention report to identify users who have reactivated: 1. Create a Retention report where: - Event A: Define an event that indicates active usage - Event B: The same event or another meaningful engagement event - Set a longer time frame that would allow you to see users who disappeared and came backThe Retention report will show you users who performed the initial action and then returned after a period of inactivity. This helps you visualize reactivation patterns over time Retention: Measure engagement over time.
Using Cohorts
Another approach is to create cohorts of dormant users who have reactivated: 1. Create a cohort of users who were inactive for a specific period (e.g., didn't perform any events for 30+ days) 2. Then filter for users from this cohort who later performed key actions
Calculating Reactivation Rate
As mentioned in the Mixpanel blog, reactivation rate is an important customer retention metric that tracks "how often customers are returning" to your product after being inactive: > "Similar to reconnecting with that $20 bill you left in your pocket after doing laundry, it's always a joy when customers return to your product or service. Typically, reactivating an account requires some kind of form submission, so you can use product analytics to track how often customers are returning." Top 6 customer retention metricsTo calculate the actual rate: - Divide the number of reactivated users by the total number of dormant users in a given time period - You can track this as a percentage: (Reactivated Users Ă· Total Dormant Users) Ă— 100
Tracking Dormant to Active Users
Mixpanel's RAE framework specifically mentions tracking the "Percentage of Dormant to Active Users - resurrecting users who have gone dormant" as a key metric for retaining your product's reach The RAE Framework.By monitoring this metric regularly, you can evaluate the effectiveness of your re-engagement campaigns and identify what drives users to return to your product.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.