Consolidating Event Data to Count Unique Users Only | Mixpanel Community

Consolidating Event Data to Count Unique Users Only

I'm analysing the bahaviour of 3 events, and using an Insights chart I see the occurrences these 3 events have occurred separately. However, there may be overlap in the users, e.g. user 1 has done all 3 events. User 2 has done 2 events. I want to consolidate this into 1 number with all unique users, so always counting a user once, even if an event has occurred multiple times. Is that possible? If so, how?

7 comments

kapa.ai
APP
·
·
Hi Janine W., 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
kapa.ai
APP
·
·
Yes, this is possible in Mixpanel Insights. To count the total number of unique users who have performed any of the three events (counting each user only once, even if they did multiple events), you should: 1. Create a new Insights report. 2. Select all three events you want to analyze. 3. Change the measurement from the default (usually "Total Events") to "Unique Users". This setting ensures that each user is counted only once, regardless of how many times or which of the selected events they performed.Mixpanel will then show you the total number of unique users who performed any of the selected events within your chosen time range. This approach consolidates overlapping users into a single count, as you described.> "Choose the event(s) that define your active users. It should be an action where they get value from your product... Under the event you’ve chosen, you will see it’s auto-set to count “Total Events”. Change that to “Unique Users.” That’s it!" How to measure MAU in MixpanelThis method works for any combination of events and is a common way to measure active users across multiple actions.
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.
Janine W.
·
·
kapa.ai Well, I already have that. I mean that now I have 3 separate numbers, and I want to combine that as well into 1. If I have the following events:
sign_in = Pete did this
change_password = Pete did this
Then that means Pete is counted once in both the events. But I want Pete to be counted once, still.
kapa.ai
APP
·
·
Let me check the knowledge base for you again. One moment! 📚
kapa.ai
APP
·
·
Yes, you can achieve this in Mixpanel Insights by using the "Unique Users" measurement across multiple events. When you select multiple events in an Insights report and set the measurement to "Unique Users," Mixpanel will count each user only once, even if they performed more than one of the selected events. This means that if Pete did both sign_in and change_password, he will only be counted once in the combined total.Here's how to do it: 1. In your Insights report, select all the events you want to include (e.g., sign_in, change_password, etc.). 2. Change the measurement to Unique Users.Mixpanel will then display a single number representing the total number of unique users who performed any of the selected events, counting each user only once regardless of how many of those events they performed.This is confirmed in Mixpanel documentation:
"You can calculate based on events, users, event property value, event property value per user, and sessions." "Unique Users: The number of unique users who performed the selected event(s) in the time range."
Insights: Visualize trends and compositions within your dataSo, in your example, Pete will be counted only once in the combined unique user count for sign_in and change_password.
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.
event
·
·
Janine W. I would recommend using custom events to merge all 3 events as 1 single custom event. It's accessible when you click on metrics then ( + Create) icon. It allows you to add all 3 events together and you can use "unique user" or even add a "first time filter" so it counts the first time a user does either of the 3 events.
Janine W.
·
·
event Oh, fair! That's a good remark, thanks! I'll try that.
👍1