Measuring Average and Total Session Counts in Mixpanel

Hi B, 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> 👋

To measure the average session duration and total session count of all events in Mixpanel using formula metrics, you can follow these steps: 1. For average session duration: - Use the "Session Duration (seconds)" property associated with Session Start/End events. - Create a formula metric to calculate the average in minutes.2. For total session count: - Use the "Session Start" event to count the total number of sessions.Here's how to set this up in Mixpanel Insights: 1. Average Session Duration: - Add a metric for "Session Start" event - Select "Aggregate Property" as the measurement - Choose "Average" for the "Session Duration (seconds)" property - Create a formula to convert seconds to minutes: divide the result by 602. Total Session Count: - Add another metric for "Session Start" event - Select "Total" as the measurementYou can create a formula combining these metrics to display both average session duration and total session count in one report.For a detailed example of how to set up the average session duration, you can refer to this Mixpanel report: Mixpanel Insights ReportRemember that you can further customize these metrics by applying filters, breakdowns, or adjusting the time range as needed.Mixpanel Sessions Documentation provides more information on working with session data in Mixpanel reports.

ℹ️ 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! 📚

For the second metric to measure the total session count, I apologize for the confusion in my previous answer. Let me clarify: When measuring the total session count, you should select "Total Sessions" as the measurement, not just "Total". Here's the correct approach: 2. Total Session Count: - Add a metric for "Session Start" event - Select "Total Sessions" as the measurementThis approach is confirmed by the Mixpanel documentation. According to Mixpanel Insights Documentation, the "Total Sessions" measurement is described as: "Sessions with event: The number of sessions that contain [event]."So, by selecting "Total Sessions" for the "Session Start" event, you'll get the correct count of all sessions, rather than just the total number of "Session Start" events.This method ensures you're counting the actual number of sessions, which is what you're aiming for when measuring the total session count of all events in Mixpanel.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.