I want to measure the distribution of session per user in which they triggered an event. How can I do this?
Hi Lois, 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 measure the distribution of sessions per user in which they triggered a specific event in Mixpanel, you can use the Insights report with the following approach: 1. Select the Event: In Insights, choose the event you want to analyze (e.g., "Purchase", "Video Watched").
2. Measurement: Change the measurement to Sessions. This will count the number of sessions in which the event occurred, rather than just the total number of events or unique users.
3. Breakdown by User: To see the distribution per user, use the Frequency per User measurement. This will compute, for each user, how many sessions they triggered the event in.
4. Aggregation Options: After selecting "Frequency per User", you can choose aggregation options such as distribution, median, percentiles, minimum, and maximum. Selecting "distribution" will show you how many users had 1, 2, 3, etc., sessions with the event, giving you the distribution you’re looking for.This approach allows you to visualize, for example, how many users triggered the event in only one session, how many in two sessions, and so on, across your user base.For more details on these steps and available aggregation options, see the documentation on Insights measurements and aggregation options and additional aggregation option examples.If you want to perform more advanced or custom analysis, you can use JQL with the groupByUser()
function to group events by user and session, then count the number of sessions per user in which the event was triggered. See the JQL groupByUser documentation for examples.
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.
Let me check the knowledge base for you again. One moment! 📚
Yes, when you select "Frequency per User" as a measurement or breakdown in Mixpanel, you need to choose the specific event you want to analyze. The frequency will then represent how many times each user performed that particular event within the selected time interval or context. For example, if you want to know how many sessions per user included a "Purchase" event, you should select "Purchase" as the event for the frequency calculation.This is confirmed in the documentation:
After selecting this option, you must select an event to compute the frequency of. You can use this to segment your users by how many times they did an event, or use it to filter out users to only those who did an event a certain number of times.
See more in the Mixpanel docs.So, you should choose the event in question that you want to measure the frequency for.
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.
Let me check the knowledge base for you again. One moment! 📚
To determine events that were not immediately preceded or succeeded by another specific event in Mixpanel, you can use the Exclusion Steps feature in Funnels reports. This allows you to exclude users who performed a certain event between two funnel steps.For example, if you want to analyze users who performed Event A but did not do Event B immediately before or after, you can set up a funnel with Event A as a step and add an exclusion step for Event B between the relevant steps. Here’s how: 1. Create a Funnel with your target event as a step. 2. Add an Exclusion Step: - Expand the “Advanced” menu and click “Exclude users who did…”. - Select the event you want to exclude (e.g., Event B). - Choose whether to exclude it between all steps or between specific steps. - This will filter out users who performed the excluded event between the specified steps, allowing you to focus on those who did not have Event B immediately before or after your target event.This approach is useful for questions like: "How many users made a purchase without first browsing a product?" or **"How many users completed signup without first viewing the pricing page?"**For more details, see the documentation on Exclusion Steps in Funnels reports.If you need to analyze more complex event sequences (e.g., not just between funnel steps), the knowledge sources do not provide explicit information about other methods, such as using Flows or JQL for this exact use case. If you need more granular sequence analysis, you may need to explore Mixpanel’s Flows report, but the documentation does not confirm this specific capability.
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.