Creating an App Open Frequency Histogram in Mixpanel
kapa.ai I want to see the app open frequency histogram of those users who came between 1st May 2025 to 31st May 2025 and retained for 30 days or more. How can I create this in Mixpanel?
kapa.ai I want to see the app open frequency histogram of those users who came between 1st May 2025 to 31st May 2025 and retained for 30 days or more. How can I create this in Mixpanel?
To create an app open frequency histogram for users who first came between 1st May 2025 and 31st May 2025 and were retained for 30 days or more in Mixpanel, you can follow these steps: 1. Define the Cohort of Interest - Create a cohort of users whose first app open (or sign up) event occurred between 1st May 2025 and 31st May 2025. - You can do this by filtering users based on the date of their first "App Open" event within this range. Save this cohort for use in further analysis. - In Mixpanel, you can set up such a cohort by clicking on “users,” adding the appropriate filters, and saving the cohort for reuse in reports How to conduct cohort analysis.2. Identify Users Retained for 30 Days or More - Use the Retention report to measure which users from your cohort were retained for at least 30 days. - Set the "birth event" as "App Open" (or your relevant entry event), and the "return event" as "App Open" as well. - Set the retention window to 30 days. You may use the rolling interval retention mode to ensure you’re measuring users who returned 30 days after their first event Retention: Measure engagement over time.3. Create a Frequency Report for the Cohort - With your cohort of users who were retained for 30 days or more, go to the Frequency report (found under Reports > Retention > Frequency). - Set the event to "App Open." - Set the interval to "day" and the date range to cover the period after their first event (e.g., 30 days after their first app open). - Apply a filter to include only users in your previously defined cohort. - The Frequency report will show you a histogram of how many unique days each user opened the app within the 30-day window. You can choose between cumulative and non-cumulative frequency views depending on whether you want to see users who opened the app at least X days or exactly X days Frequency View.Summary of Steps in Mixpanel UI: - Define a cohort: First app open between 1st May 2025 and 31st May 2025. - Use Retention report to filter for users retained for 30 days or more. - Use Frequency report on "App Open" event, filtered by the cohort, to visualize the histogram.This approach leverages Mixpanel’s cohort, retention, and frequency analysis features to answer your question precisely. If you need to automate or export this data, you can also use the Query API with the appropriate parameters for cohort, date range, and frequency analysis Query Frequency Report.
If you need more granular steps or have a specific workflow in mind, please let me know!
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! 📚
To set the retention window to 30 days in Mixpanel, you would configure your Retention report so that it measures whether users return on the 30th day after their initial event. This is typically done by setting the time unit to "day" and ensuring your report includes at least 30 intervals (days). However, if your objective is to see users who are retained on or beyond 30 days (i.e., users who return on day 30 or any day after), you should use the "On or After" retention criteria. This setting counts users as retained if they return on the 30th day or any subsequent day, not just exactly on the 30th day. This is the recommended approach for most use cases where you want to know how many users ever return after a certain period, rather than only on a specific day.Here’s how you can do this: 1. In the Retention report, set your time unit to "day" and ensure your intervals cover at least 30 days. 2. Under Retention Criteria, select "On or After" for the 30th day. This will show you the percentage of users who returned on day 30 or any day after their initial event.> “On or After” Retention calculates the percentage of users who come back on a specific time unit (e.g. day, week, month) or any time unit afterward. A user can fulfill the “came back and did B criteria” on a specific time unit or any time in the future to be counted as retained in “On or After” Retention. Retention CriteriaSo, to answer your question: - Setting the retention window to 30 days and using "On or After" is the correct approach if you want to see who is retained on or beyond 30 days. - If you only use the "On" criteria for day 30, you will only see users who returned exactly on the 30th day, not those who returned later.Let me know if you need step-by-step UI instructions!
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.
In step 3, I want a bar chart with number od days on which app open on the x axis and number of users who did that on the y axis
Let me check the knowledge base for you again. One moment! 📚
To create a bar chart in Mixpanel where the x-axis is the number of days on which a user opened the app (frequency), and the y-axis is the number of users who did so, you should use the Frequency View in the Retention report: 1. Go to Reports > Retention. 2. Select the Frequency option under the retention toggle. This view is specifically designed to show how many users performed an event (like "App Open") on a certain number of unique days within a given interval. 3. Set your event to "App Open". 4. Set the interval (e.g., "day" for daily frequency). 5. Apply a filter to include only users in your cohort (those who first opened the app between 1st May 2025 and 31st May 2025 and were retained for 30 days or more). 6. Choose the bar chart visualization. The Frequency report will display a histogram: - X-axis: Number of unique days the app was opened (e.g., 1, 2, 3, ..., 30+). - Y-axis: Number of users who opened the app on that many unique days.This setup will give you exactly the histogram you described, showing user engagement frequency over the specified period. You can also choose between cumulative and non-cumulative frequency, depending on whether you want to see users who did the event at least X days or exactly X days Frequency View.If you need to further customize the chart (e.g., axis labels, color), you can use Mixpanel’s chart customization features Chart Customization.
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.