Metrics for Users Spending 1 Minute on Consecutive Days
i want to see metric of Users who have spent at least 1 minute on 2 consecutive days before the date
i want to see metric of Users who have spent at least 1 minute on 2 consecutive days before the date
Hi Abhijeet S., 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 measure "Users who have spent at least 1 minute on 2 consecutive days before the date" in Mixpanel, you would need to combine session duration, daily activity, and streak logic. Here’s how you can approach this using Mixpanel’s features: 1. Session Duration Filter: Use the "Session Duration (seconds)" property to filter sessions where users spent at least 60 seconds in a session. This property is available on session events and can be used in Insights or Flows reports to break down or filter results by session length Session Controls in Reports.2. Daily Activity: To ensure the activity happened on different days, you can use Mixpanel’s retention or frequency reports with a daily interval. The frequency report allows you to see how many unique days a user was active with a given event (e.g., "Session Start" with duration ≥ 60 seconds) Frequency View.3. Consecutive Days (Streaks): For the "consecutive days" requirement, use the "Streak mode" in the Retention report. Streak mode counts unique users who perform an action on consecutive time intervals (e.g., 2 consecutive days) Retention Criteria.How to set this up:Note: If you need to do this via the API, you would need to use the Retention endpoint with appropriate filters and streak mode, but the UI approach above is the most straightforward for this use case.References: - Session Controls in Reports - Retention Criteria: Streak mode - Frequency ViewIf you need a step-by-step guide for the Mixpanel UI or API, 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.