Get User Emails with Most Active Days in a Given Time Period | Mixpanel Community

Get User Emails with Most Active Days in a Given Time Period

How to get a list of user emails who have the most days with at least 1 session start per day over a specified time period? If the time period is 1 month, then the days with at least 1 session can only be from 0 to 30.

2 comments

kapa.ai
APP
·
·
Hi David D., 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
kapa.ai
APP
·
·
To get a list of user emails who have the most days with at least 1 session start per day over a specified time period, you can use Mixpanel's Insights report along with the "View Users" feature. Here's how you can approach this: 1. First, set up a query in Insights to count the number of unique days with session starts for each user: - Select "Session Start" as your event - Set your desired time period (e.g., 1 month) - Use the "Unique" aggregation on the "time" property, which will count unique days - Group by "User"2. Once you have this report, you can click on the top results to view the list of users who have the most days with sessions.3. In the "View Users" panel, you should be able to see the email addresses of these users, assuming you're tracking email as a user property.To set this up, you can follow the steps outlined in the Insights documentation. The "View Users" feature allows you to see a representative sample of users from any analysis, which in this case would be the users with the most active days.It's important to note that the maximum number of days with sessions in a month would indeed be limited to the number of days in that month (28-31, depending on the month).If you need to export this list of users for further analysis or to use in other systems, you can save this user list as a cohort. The Cohorts documentation explains how to create cohorts from your analysis results.Remember that to get accurate results, you need to have properly set up session tracking in Mixpanel. The Sessions documentation provides information on how sessions are handled in Mixpanel reports.If you need more detailed information or if this approach doesn't fully address your needs, you might need to consider using Mixpanel's JQL (JSON query language) for more complex queries. However, the knowledge sources provided don't contain specific information about using JQL for this particular use case.
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.