How can I get users who used my product for two consecutive days, like yesterday and the day before yesterday.
Hi Abhijeet S., 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 find users who used your product for two consecutive days (like yesterday and the day before yesterday), you can use Mixpanel's Retention report with Streak mode. Here's how to do it: 1. Go to the Retention report in Mixpanel 2. Select "Streak mode" as your retention criteria 3. Set up your event that indicates product usage 4. Set the appropriate time frame to capture yesterday and the day before yesterdayStreak mode is specifically designed to "count unique users doing consecutive actions across time intervals" such as users who "played a game for 5 consecutive days since sign-up" or in your case, used your product for two consecutive days.Retention Criteria explains that Streak mode is meant for tracking consecutive actions across time intervals, which is exactly what you're looking for.Alternatively, you could also: 1. Create a cohort in the Cohort Builder that defines users who used your product yesterday AND the day before yesterday 2. Use the Users page to filter for these specific users and save them as a cohortOnce you've identified these users, you can save them as a cohort for further analysis or to target them with specific messaging.
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.
And how can i get users who did any activity after 1 week , and after a month ?
And how can i get users who did any activity after 1 week , and after a month ? kapa.ai
Let me check the knowledge base for you again. One moment! 📚
To find users who did any activity after 1 week and after a month in Mixpanel, you can use the Retention report with the appropriate time intervals. Here's how to do it:
Using Retention Report
1. Go to the Retention report in Mixpanel 2. Define your retention behavior: - First event: The initial action (like "Sign Up" or any event that marks the starting point) - Return event: "Any Event" (to capture any activity) 3. Set the appropriate time intervals to see week 1 and month 1 retentionThe Retention report will show you the percentage or absolute number of users who returned to perform any activity after the specified time periods.
Two Retention Modes to Consider
Mixpanel offers two retention calculation modes that might be useful depending on your specific needs: 1. Rolling interval retention (default): Considers time intervals based on each user's first action - Week 1 retention = 7-14 days since person's first action - Month 1 retention = 30-60 days since person's first action2. Calendar interval retention: Considers time intervals based on calendar time - Week 1 retention = next calendar week since person's first action - Month 1 retention = next calendar month since person's first actionYou can switch between these modes in the advanced menu under Retention Criteria.Calendar Retention Mode provides more details on the differences between these approaches.
Measuring Active Users Directly
Alternatively, you can use Mixpanel's Insights report to measure Weekly Active Users (WAU) and Monthly Active Users (MAU): 1. Create a new Insights report 2. Select the event(s) that define your active users 3. Change the measurement from "Total Events" to "Weekly Active Users" or "Monthly Active Users"This approach will show you users who were active within the last 7 days (WAU) or 30 days (MAU) at any point in your selected time range.How to measure MAU in Mixpanel provides more details on this approach.Would you like more specific guidance on either of these methods?
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.
im not getting this point, can you help me with it 3. Set the appropriate time intervals to see week 1 and month 1 retention can you tell me where exactly i have to make changes on mixpanel
im not getting this point, can you help me with it 3. Set the appropriate time intervals to see week 1 and month 1 retention can you tell me where exactly i have to make changes on mixpanel kapa.ai
Let me check the knowledge base for you again. One moment! 📚
I'll clarify exactly where to set the time intervals in Mixpanel's Retention report to see week 1 and month 1 retention: 1. Go to Reports > Retention in your Mixpanel dashboard2. Define your retention behavior (the initial event and return event)3. For setting the appropriate time intervals: - Look for the Retention Criteria section in your query builder - By default, Mixpanel uses "On or After" retention with "Day" as the time unit - To see week 1 retention: Change the time unit from "Day" to "Week" in the dropdown menu - To see month 1 retention: Change the time unit to "Month"The time unit dropdown is typically located in the middle of your query builder, under the retention criteria section. When you select "Week" or "Month", Mixpanel will automatically adjust the intervals to show retention in those time units.Retention: Measure engagement over time provides more details on how to use the Retention report.If you want to see both week 1 and month 1 retention, you'll need to create two separate reports with different time unit settings.Does this help clarify where to make the changes?
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.