How can I get the set of users who have at least 1 event triggered on every day (for the last 7 days)
Hi Sarath K., 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 get the set of users who have triggered at least 1 event on every day for the last 7 days in Mixpanel, you should use the Cohort Builder with event frequency criteria: 1. Open the Cohort Builder: Go to the Users section and select "Create Cohort" or use the cohort builder directly from the query builder in any report.2. Set the Condition: Define the cohort as: - "Users who did [any event] on at least 7 unique days in the last 7 days." This ensures you only include users who were active (triggered at least one event) on every day in the last 7 days.3. Save and Use the Cohort: Once defined, save the cohort. You can now use this cohort in other reports or export the user list.Note: The cohort builder allows you to specify event frequency over a time window, such as "did event on at least X unique days in the last Y days" Creating Cohorts.If you want to do this via a report: - In an Insights or Retention report, you can filter or break down by this cohort to analyze their behavior further.Summary of Steps: - Use the cohort builder. - Set the frequency: "at least 7 unique days in last 7 days." - Save and analyze or export the cohort.This approach is supported by Mixpanel’s cohort and frequency features Creating Cohorts Frequency View.
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.