How do I create a report which calculates how many times a particular event triggered per session on average?
Hi Ankit 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 calculate how many times a particular event triggered per session on average in Mixpanel, you can use the Insights report with a formula that divides the total count of your event by the total number of sessions. Here's how to do it: 1. Go to the Insights report in Mixpanel 2. Add two metrics: - First metric: Select your specific event and set the measurement to "Total Events" - Second metric: Select "Session Start" event and set the measurement to "Total Events" 3. Create a formula that divides the first metric by the second metricThis will give you the average number of times your event occurred per session.Alternatively, you can use the "Frequency per User" measurement in Insights, which allows you to analyze how many times users performed an event, and then aggregate this data using averages or other statistical methods.For more detailed session analysis, you can also: - Break down your results by session properties like "Session Duration" or "Session Event Count" - Filter for specific session types or durations - Use the "Sessions with event" measurement to count the number of sessions that contain your specific eventMixpanel automatically computes sessions from the events you send, so you don't need special tracking work to make this analysis possible.Mixpanel Sessions Documentation provides more details on how sessions work and how you can use them in your analysis.
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.