How to Generate a Report of Inactive Users Over 3 Months

To create a report counting users who haven't used your app in the past 3 months, you can use Mixpanel's Cohort feature and then visualize it in an Insights report. Here's how you can do this:1. First, create a cohort of inactive users: - Go to the Cohort Builder in Mixpanel. - Set up a filter for users who have not performed any event in the last 3 months. - Save this cohort with a name like "Inactive Users - 3 Months".2. Then, use this cohort in an Insights report: - Go to the Insights report in Mixpanel. - Click on "+ Metrics" and choose "Cohort Size" as your metric type. - Select the "Inactive Users - 3 Months" cohort you just created. - Set the date range to cover the period you're interested in analyzing.This will give you a report showing the number of users who haven't used your app in the past 3 months over time.You can also visualize how this cohort size changes over time, as mentioned in the Cohorts documentation:"In Insights, you can define a metric based on the size of a cohort over time. This is useful to understand how key subsets of your user base (like your Power Users) are trending over time. Select a cohort from the "Events and Cohorts" menu in the Insights report; this will generate a line chart that shows the size of the cohort over time. Each point is the size of the cohort as of the end of that time interval."Remember, this approach will give you a dynamic view of inactive users, updating as time passes. If you need a static list of users inactive for exactly 3 months from a specific date, you might need to adjust your cohort definition accordingly.

ℹ️ 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 create a report showing the number of users who used your app only once in the past month, you can use Mixpanel's Insights report with specific filters. Here's how you can set this up:1. Go to the Insights report in Mixpanel.2. Set up your metric: - Click on "Select Event" and choose an event that represents app usage (e.g., "App Open" or a similar event that indicates app usage). - Change the measurement from "Unique Users" to "Frequency per User" by clicking on "Unique Users" and selecting "Frequency per User" from the dropdown. - In the aggregation options, select "Exactly" and set the value to 1.3. Set the date range to the past month.4. Your query should now show users who performed the selected event exactly once in the past month.To visualize this data, you can use different chart types. A line chart would show how the number of one-time users changes over time within the month, while a single metric chart would give you the total count for the entire month.This approach leverages the "Frequency per User" measurement, which is described in the Measurements documentation:"Frequency per User: The number of events performed per user. Example: How many videos were watched per user? Aggregation options: Average, distribution, median, percentiles, minimum, maximum"By setting the frequency to "Exactly 1", you're filtering for users who performed the event only once in the specified time period.Remember, this method counts users based on a single event. If you want to consider multiple events as "app usage", you might need to create a more complex query or use a custom event that encompasses all relevant app interactions.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.