what can be a report that shows me annual user retention?

Hi Juan I., 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> 👋

To show annual user retention in Mixpanel, you can use the Retention Report and configure the time unit to months, as the platform typically buckets retention by day, week, or month [Retention: Measure engagement over time; Query API - Retention].

While there is no native "annual" toggle in the standard unit selector, you can achieve this analysis through the following steps:

** Define Behavior: Set the first event (e.g., "Sign Up") and the returning event (e.g., "Any Event" or a specific value-driving action) [Retention: Measure engagement over time]. ** Set Unit to "Month": Select "Month" as the interval unit. To see retention after a full year, you would look at the Month 12 bucket in the resulting table or chart [Query API - Retention]. ** *Date Range: Extend your date range to include at least the last 13–24 months to ensure you have enough historical data to see users who joined a year ago and returned 12 months later.

** Retention Curve: This will show you a "Month 12" data point, representing the percentage of users who returned in the 12th month after their initial action [Retention: Measure engagement over time]. ** Line Chart: If you want to see how your "Year 1 Retention" is trending over time, switch to the Line visualization and select the Month 12 bucket. This will plot a trend line showing if the percentage of users staying for at least a year is increasing or decreasing [Retention: Measure engagement over time].

If you want to know the percentage of users who returned at month 12 or any time after, you can enable Unbounded Retention. This is useful for products with infrequent usage where a user might not return exactly in the 12th month but remains a customer [A primer on retention analytics for product leaders].

For subscription-based businesses, you may also want to track Net Revenue Retention (NRR) or Annual Recurring Revenue (ARR) in an Insights Report to see the financial side of annual retention [Revenue analytics explained].

ℹ️ 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 find the number of recurrent users in a certain year based on a cohort, you should use the Insights Report. In Mixpanel, you can treat a cohort as a metric to track its size and membership over time.

Here is how to set up that report:

First, ensure your "recurrent user" cohort is defined in the Cohorts builder. You can define this based on users who performed a specific sequence of events or share certain properties [Cohorts: Group users by demographic and behavior].

** Select the Cohort: In the Insights report, go to the "Events and Cohorts" menu and select your specific cohort. This will define a metric based on the size of that cohort [Using Cohorts in Analysis]. ** Set the Date Range: Use the date picker to select the specific year you are interested in (e.g., "Jan 1, 2023 - Dec 31, 2023"). ** Choose Visualization: ** Metric Chart: Select the "Total" or "Metric" view to see the unique number of users who were part of that cohort at any point during that year [Insights: Visualize trends and compositions within your data]. ** *Line Chart: This will show you how the size of the recurrent user cohort trended month-to-month or day-to-day throughout that year [Using Cohorts in Analysis].

If you specifically want to see users who return repeatedly (recurring behavior) rather than just belonging to a static cohort, you can use the Retention Report with the "Recurring" (compounded) retention type. ** In the Query API, this is known as retention_type=compounded. ** This measures how many users who did an event in one interval (e.g., a month in 2023) came back to do it again in a subsequent interval [Query Retention Report].

If "recurrent" means users who use the product with a specific frequency (e.g., at least 5 times a year), use the Frequency tab within the Retention report. ** Set the unit to Month. ** Select Cumulative Frequency to see users who were active in "at least X" unique intervals during your selected time period [Frequency View].

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