How can we calculate repeat users data on Mixpanel?
Hi Mansi g., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To calculate repeat users data in Mixpanel, you have several options depending on what specific aspect of repeat usage you want to analyze:
Using Retention Reports
Retention reports are ideal for measuring how many users come back to your product over time: 1. Create a new Retention report by going to Reports > Retention 2. Define your retention behavior by selecting the initial event (what users first did) and the return event (what they came back to do) 3. Choose your measurement (retention rate or unique users) 4. Select your time interval (days, weeks, or months)You can use either N-day retention (specific day returns) or unbounded retention (any time after) depending on your needs. This helps you understand how many users are coming back to your product after their first use.Retention: Measure engagement over time
Using Frequency Analysis
For understanding how frequently users return: 1. Go to Reports > Retention 2. Select the "Frequency" option under the retention toggle 3. Choose between "Cumulative Frequency" (users who did the event in at least X unique intervals) or "Non-cumulative Frequency" (users who did the event in exactly X unique intervals)This shows you engagement patterns like how many users performed actions on multiple unique days within a week or month.Frequency View
Measuring Repeat Purchase Rate
If you're specifically looking at e-commerce or transaction data: 1. Use Insights reports to track repeat purchase events 2. Create a formula to calculate the percentage of repeat customers compared to total customersSome Mixpanel customers have achieved 30-40% repeat purchase rates by implementing effective strategies and tracking them in Mixpanel.How this startup used Mixpanel to extend its runway
Using Formulas for Custom Calculations
For more advanced repeat user metrics: 1. Go to Insights report 2. Click the "Metrics" button and select "Formula" 3. Use the variables assigned to your events to create custom calculationsThis allows you to create custom repeat user metrics tailored to your specific business needs.FormulasFor the most accurate analysis, define what "active" means for your product first - focus on meaningful actions that represent users getting value from your product rather than just logging in.
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.