Average Daily Subscription Purchase Events by Day of the Week

I have a an event called 'Subscription purchased' which indicates when a subscription has been purchased. I want to know the average number of 'Subscription Purchased' events for each day of the week

3 comments

kapa.ai
APP
·
·
Hi Chris 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
kapa.ai
APP
·
·
To analyze the average number of 'Subscription Purchased' events for each day of the week in Mixpanel, you can use the Insights report with specific measurement settings. Here's how to approach this: You'll want to use the "Frequency per User" measurement in Insights, which allows you to calculate how many times users perform a specific event, and then aggregate that data.1. Go to the Insights report in Mixpanel 2. Select your 'Subscription Purchased' event 3. Change the measurement from the default "Unique Users" to "Frequency per User" 4. For the aggregation option, select "Average" (this is typically the default) 5. Add a breakdown by "Day of Week" to see the data split by each dayThis approach will show you the average number of subscription purchases per user for each day of the week, which helps identify which days have higher subscription activity.If you want to see the total number of subscription purchases by day of week (rather than per user), you can: 1. Select "Total Events" as your measurement 2. Break down by "Day of Week" 3. Change the visualization to show the data in a way that makes sense for your analysis (bar chart might work well here)For more advanced analysis, you can use Mixpanel's Insights report features which provide various ways to measure and visualize your event data, including aggregations and breakdowns that would be helpful for your specific question.
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.
Chris S.
·
·
how do i add a breakdown by day of week