How do I show the daily active users as a % of our user base? Instead of a line chart showing the growth of daily active users over time, I also want to know, out of our entire customer base, what % of them is a daily active user?
Hi Janine 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 show daily active users as a percentage of your total user base in Mixpanel, you can use a Formula metric in the Insights report. Here's how to do it: 1. Create an Insights report with two metrics:
- First metric: Daily Active Users (DAU)
- Second metric: Total user profiles2. Then create a Formula to calculate the percentage: - Click the Metrics button, then select "Formula"
- Use the formula: (A/B)*100 where A represents your DAU and B represents your total user base
- This will give you the percentage of your total user base that is active dailyThis approach allows you to track what percentage of your entire customer base is engaging with your product on a daily basis, rather than just seeing the absolute number growing over time.You can save this formula for reuse if you're on an Enterprise or Growth plan, making it easy to track this KPI consistently Mixpanel Docs.This type of measurement is similar to the DAU/MAU ratio (which measures stickiness), but instead compares DAU to your total user base, giving you insight into overall engagement across your entire customer population Mixpanel Blog.If you want to see how this percentage changes over time, you can keep the visualization as a line chart to track the trend of your active user percentage.
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.
Let me check the knowledge base for you again. One moment! đź“š
You're right, and I apologize for the confusion. Total user profiles is indeed not an event-based metric, but Mixpanel does allow you to measure your total user base through Profile metrics.Here's the correct approach to calculate DAU as a percentage of your total user base: 1. Create an Insights report with a Formula metric
2. For the first metric (A), select your event and choose "Daily Active Users (DAU)" as the measurement
3. For the second metric (B), use Profile Analysis:
- Click "+ Metrics" and select "Profiles"
- For measurement, select "Total" (which counts all user profiles)
4. Create a Formula: (A/B)*100 to calculate the percentageAccording to the Mixpanel documentation, Profile metrics specifically "allow you to access profile data and visualize your users with filters and breakdowns based on their profile properties. When exploring Profiles, you are always analyzing all user profiles." Mixpanel DocsThis approach will give you the percentage of your total user base that is active on a daily basis, which is exactly what you're looking for.Would you like me to explain any other aspects of setting up this analysis in Mixpanel?
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.
