Mixpanel Community Icon

Calculating Average Days Until User Inactivity Based on Page Views

·
·

How can I calculate the average amount of days until the a user is no longer active (based on page view event)

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Tal, 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

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    To calculate the average number of days until a user is no longer active based on a page view event, you can use Mixpanel's Retention report. Here's how you can approach this:1. Set up a Retention report with the following configuration: - Set the first event (A) as "Page View" - Set the second event (B) as "Page View" as well2. Choose the appropriate retention criteria. In this case, you'd want to use "On or After" retention, which is the default setting. This will show you how many users came back on or after each day following their initial page view.3. Set the time interval to "Day" to track daily retention.4. Look at the retention curve to see where it flattens out. The point where the curve becomes relatively stable indicates the average time when users are no longer considered active.5. You can also use the "Frequency" view in the Retention report to see how many unique days in a month users are active. This can give you additional insights into user activity patterns.For a more precise calculation, you might need to export the data and perform some additional analysis outside of Mixpanel.It's important to note that the definition of "no longer active" can vary depending on your specific use case. You might want to consider defining a specific inactivity threshold (e.g., 30 days without a page view) to determine when a user is no longer active.For more detailed information on using the Retention report in Mixpanel, you can refer to the Mixpanel Docs on Retention.

    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.