Calculating Average Events Per Week Per User for Specific Events
how can i check the averga number of events per week per user of a specific event?
how can i check the averga number of events per week per user of a specific event?
Hi Gabriel W., 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 check the average number of events per week per user for a specific event in Mixpanel, you should use the "Frequency per User" measurement in the Insights report. Here’s how you can do it:
1. Go to Insights Report: Open the Insights report in Mixpanel. 2. Select Your Event: Choose the specific event you want to analyze. 3. Choose Measurement: Click on the measurement dropdown (usually defaults to "Total Events" or "Unique Users") and select Frequency per User. 4. Set Aggregation: After selecting "Frequency per User," choose Average as the aggregation option. This will calculate the average number of times each user performed the event. 5. Set Time Interval: Set the time interval to week. This ensures the calculation is done per week.
This setup will show you the average number of times per week each user performed the selected event. You can also view the distribution, median, percentiles, minimum, and maximum if you want more detail on user behavior.
For more details, see the documentation on Frequency per User and Aggregate Property per User.
If you want to do this programmatically, you can use the Query API to get similar data, but the UI method above is the most straightforward for this 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.
kapa.ai what if I want to see the average per week over a longer period of time, say in the past 3 months what is the average amount of times a user does this per week
Let me check the knowledge base for you again. One moment! 📚
To see the average number of times a user does a specific event per week over a longer period (e.g., the past 3 months), you should:
1. Open the Insights report in Mixpanel. 2. Select your event. 3. Set the date range to the past 3 months. 4. Set the interval to "week" so the data is grouped by week. 5. Choose the "Frequency per User" measurement. 6. Select "Average" as the aggregation.
This will show, for each week in the past 3 months, the average number of times a user performed the event. If you want a single average value for the entire 3-month period (i.e., the average per user per week, averaged across all weeks in the period), you can visually average the weekly values or export the data for further calculation.
Mixpanel’s Insights report is designed to let you analyze this kind of trend over time, and the "Frequency per User" measurement with weekly granularity is the recommended approach for this use case Docs / Reports / Insights: Measurements.
If you need a single summary value (not a trend), you may need to export the weekly averages and compute the overall average externally, as Mixpanel will display the average per user for each week, not a single average across all weeks in the UI. The documentation does not mention a built-in function to directly calculate the overall weekly average for a multi-week period in one step Docs / Reports / Insights: Measurements.
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.
kapa.ai and if I wanted to filter the view to see data only from users who did 2 or more of the events per week? Is it Filter - Frequency per user - select event - per interval - "greater than:2" ?
Let me check the knowledge base for you again. One moment! 📚
Yes, your approach is correct according to Mixpanel's documentation on computed and behavioral properties. To filter your view to only include users who did 2 or more of the events per week, you should:
1. In the Insights report, add a Filter. 2. Select Frequency per User as the computed property. 3. Choose your specific event. 4. Set the interval to per week. 5. Set the filter condition to greater than or equal to 2.
This will filter your analysis to only include users who performed the event at least 2 times per week in the selected time period. You can then analyze metrics (such as average, distribution, etc.) for just this group of users.
This process is described in the documentation for computed properties and frequency per user filters Computed Properties.
"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." — Computed Properties
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.
kapa.ai i can set the interval as "per interval" "between steps" or "after step 1" If i chose "per interval" does it respect the week interval from the graph's veiw "per week"?
Let me check the knowledge base for you again. One moment! 📚
Yes, if you choose "per interval" for the computed property (such as Frequency per User), it will respect the interval set in your chart—so if your graph is set to "per week," the computed property will calculate frequency per user for each week.
As stated in the documentation:
In insights, the time in which this computation is done is on a per-interval basis. For a line chart, that will be for each individual interval plotted on the chart. For bar, table, and pie, this interval is the entire date range selected in the date picker.
So, "per interval" aligns with the interval you have set in your Insights report (e.g., week, day, month, etc.).
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.