How to calculate page views per session based off my event called page viewed
You can calculate page views per session in Mixpanel's Insights report using a formula that divides your Page Viewed event count by the number of Session Start events.
Here's how to set it up:
Open an Insights report
Add your first metric: Select your Page Viewed event and set the measurement to Total Events
Add a second metric: Select the Session Start virtual event and set the measurement to Total Events
Create a formula: Divide metric A (Page Viewed) by metric B (Session Start) โ e.g., A/B
This gives you the average number of page views per session. [Sessions use cases]
Tip: If you want to exclude bounces (sessions where users only viewed one page and left quickly), you can add a filter for sessions longer than a certain duration, such as sessions with a Session Duration (Seconds) greater than 10. This tends to give a more meaningful result. [Sessions use cases]
Note: For sessions to work, Mixpanel automatically computes Session Start and Session End virtual events from your existing event data โ no additional tracking is needed. By default, a session ends after 30 minutes of inactivity. [Sessions overview]
โน๏ธย Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
