how can i get those users who have created atleast one game, the event name for game creation is "Game created"
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 get users who have created at least one game (where the event name is "Game created"), you can use Mixpanel's cohort or Insights features: Option 1: Create a Cohort
1. Go to the Cohort Builder.
2. Set the condition: Users who did the event "Game created" at least 1 time.
3. Save the cohort. This will group all users who have triggered the "Game created" event at least once. You can use this cohort in other reports or export the user list if needed.Option 2: Use Insights Report
1. In an Insights report, select the "Game created" event.
2. Set the measurement to "Unique Users" to see the count of users who have performed this event.
3. Click on any data point or segment and select "View Users" to see the list of users who created at least one game. You can also save this list as a cohort for further analysis or export it if needed Docs: View Users.Option 3: JQL (Advanced)
If you need to use JQL, you can write a query to filter users who have performed the "Game created" event. For example: LBKSfunction main() { return Events({ event_selectors: [{event: "Game created"}] }) .groupBy(["distinct_id"], mixpanel.reducer.count()) .filter(function(user) { return user.value > = 1; }); }LBKS
This will return all users (distinct_id) who have created at least one game Docs: JQL.These methods will help you identify users who have triggered the "Game created" event at least once.
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.