How can I create a chart that shows number of unique users, filtered by account (Mixpanel’s group feature) with property plan = Free, who logged in more than twice this month? or number of users who visited our website more than twice in a given duration
Hi Moon L., 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 create the chart you're describing, you can use Mixpanel's Insights report with Group Analytics and Behavioral Properties. Here's how you can set it up: 1. First, ensure you have Group Analytics set up for your account-level analysis. This is available as an add-on for Growth and Enterprise plans Group Analytics.2. In Mixpanel, go to the Insights report.3. Set up your metric: - Choose the "Log In" event (or "Website Visit" event, depending on which specific action you're tracking) - Change the measurement from "Total Events" to "Unique Users"4. Add filters: - Add a filter for the group property "plan" equals "Free" - Add a behavioral filter using the "Frequency per User" option. Set it to "Log In" (or "Website Visit") more than 2 times in the last 30 days (or your desired time frame)5. Set your date range to "This Month" or your preferred time period.6. In the "Analyze Uniques by" dropdown, select your account-level group identifier (e.g., "company_id" or whatever you've set up for Group Analytics).This setup will give you a chart showing the number of unique users, filtered by accounts with a Free plan, who have logged in (or visited the website) more than twice in the specified time period.For more detailed instructions on using Group Analytics and Behavioral Properties, you can refer to these Mixpanel documentation pages: Group Analytics Behavioral PropertiesRemember that Group Analytics is an add-on feature, so make sure your Mixpanel plan includes this capability before attempting to set up this analysis.
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.