I have a "Monthly active users" cohort, and I would like to display the average number of monthly active users per company (which is a property of each user profile). Can you please help me understand how I can do that?
Hi Dudi E., 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 answer your question about displaying the average number of monthly active users per company using Mixpanel, we need to combine a few concepts. Let's break it down step by step: 1. First, you mentioned you have a "Monthly active users" cohort. This is a good starting point, as it represents your MAU (Monthly Active Users).2. To display the average number of MAU per company, you'll need to use the Insights report in Mixpanel and leverage some of its advanced measurement features.Here's how you can approach this: 1. Go to the Insights report in Mixpanel.2. In the query builder, select your "Monthly active users" cohort as the basis for your analysis.3. For the measurement, you'll want to use "Aggregate Property per User". This allows you to perform calculations based on user profile properties Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements > Aggregate Property per User> .4. When prompted to select a property, choose the "company" property from your user profiles.5. For the aggregation type, select "Distinct count". This will count the number of unique users per company.6. After selecting "Distinct count", you'll be prompted to choose an additional aggregation option. Here, select "Average". This will give you the average number of MAU per company.The resulting query should show you the average number of monthly active users per company.It's worth noting that Mixpanel offers various aggregation options for these types of calculations, including sum, average, distinct count, minimum, and maximum Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements > Aggregate Property per User> .If you need to further customize this analysis or create a more complex query, you might want to explore Mixpanel's custom properties feature. This allows you to create new properties on the fly for more advanced calculations Docs Features > Custom Properties: Calculate new properties on the fly > Creating a Custom Property> .Remember, the exact steps might vary slightly depending on your specific Mixpanel setup and data structure. If you encounter any issues or need more specific guidance, it might be helpful to consult Mixpanel's documentation or reach out to their support team.
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! đź“š
I apologize for the confusion in my previous response. You're correct, and thank you for pointing that out. When using a cohort metric in Mixpanel Insights, the measurement options are indeed more limited. Let me provide a more accurate answer based on the available information: When working with a cohort metric in Mixpanel Insights, you're typically limited to measuring "Unique Users" as you've observed. This is because cohorts are already defined groups of users, and Mixpanel treats them differently from event-based metrics.To achieve what you're looking for - displaying the average number of monthly active users per company - you might need to take a different approach: 1. Instead of using your "Monthly active users" cohort directly, you could create a custom event or metric that represents your monthly active users.2. Then, you can use this event or metric in Insights and apply the "Aggregate Property per User" measurement as previously suggested.3. Alternatively, you could use Mixpanel's Group Analytics feature, if it's available in your plan. Group Analytics allows you to analyze data at a group level (like companies) rather than just at the individual user level Docs Data-structure > Group Analytics: Group users together as an aggregated unit of measurement> .If these options don't work for your specific use case, you might need to consider using multiple reports or custom properties to achieve the desired result.Given the limitations you're experiencing, I recommend reaching out to Mixpanel's support team for guidance on the best way to structure this analysis within the constraints of your specific Mixpanel setup and plan. They may be able to suggest workarounds or alternative approaches that are not immediately apparent from the documentation.
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.
