What is the best way to calculate the number of new users on the platform in the last 12 months?
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 the number of new users on the platform in the last 12 months using Mixpanel, you can follow these steps: 1. Create a new Insights report in Mixpanel. 2. Choose the event that represents a new user signing up or creating an account. 3. Set the time range to "Last 12 months" using the date range selector. 4. Change the measurement from "Total Events" to "Unique Users".Here's a more detailed explanation: 1. Open Mixpanel and create a new Insights report. 2. In the report, select the event that represents a new user. This could be something like "Sign Up" or "Account Created". 3. Click on the date range selector and choose "Last 12 months" from the preset options. This will automatically set your query to cover the past 12 months plus the current incomplete day. 4. Under the event you've chosen, you'll see it's set to count "Total Events" by default. Change this to "Unique Users" to ensure you're counting individual new users rather than total sign-up events.This method will give you the count of unique users who performed the sign-up event for the first time in the last 12 months, effectively showing you the number of new users on the platform during that period.For a more advanced analysis, you could also use the "New Users" option in Mixpanel's Lifecycle report, which specifically focuses on new user acquisition.Sources: Docs Reports > Insights: Visualize trends and compositions within your data> Blog MAU, WAU, and DAU: Why should we care about 'active' users? > How to calculate MAU> Docs Reports Overview > Date Range>
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 understand you're looking for new users who visited your website or interacted with your app, rather than those who created an account. In this case, we can adjust our approach using Mixpanel's first-time user tracking. Here's how you can calculate this: 1. Create a new Insights report in Mixpanel. 2. Choose the "ae_first_open" event, which represents the first time a user opens the app. This event is part of Mixpanel's legacy automatically tracked events.For website visitors: You'll need to set up a custom event to track first-time website visits if you haven't already. This could be done by tracking the "First Page View" event for each unique user.To set up the report: 1. Open Mixpanel and create a new Insights report. 2. Select the "$ae_first_open" event for app users or your custom "First Page View" event for website visitors. 3. Click on the date range selector and choose "Last 12 months". 4. Change the measurement to "Unique Users".This method will give you the count of unique new users who opened your app for the first time or visited your website for the first time in the last 12 months.It's important to note that Mixpanel considers first-time users as "any user who arrives at your website or app for the first time – you have never seen this user before." This definition aligns with your requirement.Remember that this method includes anonymous visitors, so it will count users who visit your homepage without necessarily creating an account or performing any other action.Sources: Docs Tracking-methods > Sdks > Mixpanel SDKs: iOS (Swift) > Legacy Automatically Tracked Events> YouTube [Learn to Use Mixpanel]: Tracking First Time Users Docs Pricing > MTU billing > View MTU Usage>
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.