I want to calculate ARPU. I have a few revenue sources independent of each other, and I want to take all visitors to the page into account. What approach should I take?
Hi Robert Ĺ ., 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 ARPU (Average Revenue Per User) in Mixpanel, you should sum all revenue from your independent sources and divide by the total number of unique visitors (users) to your page within the desired time period. Since you want to include all visitors, make sure your denominator is the total number of unique users, not just paying users.The formula is: LBKSARPU = Total Revenue / Total Number of Active UsersLBKS
- Total Revenue: Add up revenue from all your independent sources.
- Total Number of Active Users: Count all unique visitors to your page in the selected time frame.This approach is standard for ARPU and is supported in Mixpanel. You can use Mixpanel’s event tracking to capture revenue events from each source and then use a report or dashboard to sum the revenue and divide by the unique user count for the period you’re analyzing. This will give you a holistic ARPU that reflects all revenue streams and all visitors, not just paying users. This method is especially useful for benchmarking and understanding overall user value, as recommended in Mixpanel’s documentation and blog posts What is ARPU? and Building Revenue Metrics.If you want to see an example in Mixpanel, you can refer to their demo project for ARPU calculation: ARPU demo example.Key points:
- Track all revenue events, regardless of source.
- Use all unique visitors as your user base.
- Calculate ARPU as total revenue divided by total unique users in the period.This approach ensures your ARPU reflects the average revenue generated per visitor, as Mixpanel recommends for digital businesses including SaaS, ecommerce, and media companies What is ARPU?.
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.