Getting Unique Daily Users by Path in Mixpanel

Angela H. · 2025-08-18T21:29:17.163Z

Hi, I’m trying to get true daily unique users for the "Loaded a Page" event by path name. Mixpanel is double-counting users because time is embedded in the event (so it counts unique combinations of user_id + time, rather than just user_id). I also tried a cohort, but can’t filter by path. Is there a way to get unique users per day per path inside Mixpanel, or do I need to pull raw data and calculate this myself?

Getting Unique Daily Users by Path in Mixpanel | Mixpanel Community

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Hi Angela H., 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, you can get daily unique users for the "Loaded a Page" event by path name directly in Mixpanel, without needing to pull raw data.Here’s how you can do it: 1. Create an Insights Report: - Go to the Insights report. - Select the "Loaded a Page" event.2. Set the Measurement to Unique Users: - Under the event, change the measurement from "Total Events" to "Unique Users". This ensures you’re counting unique users (by user_id/distinct_id) per time interval, not unique event occurrences.3. Set the Time Interval to Day: - In the date/time selector, set the interval to "Day" to get daily counts.4. Break Down by Path Name: - Use the "Breakdown" feature to break down the event by the "path name" property (or whatever property holds your page path). This will show you, for each day, the number of unique users per path.Important Note: Mixpanel’s unique user counting for breakdowns works as follows: for each segment (in your case, each path), it counts the number of unique users who performed the event for that segment in the selected time interval. If a user visits multiple paths in a day, they will be counted once per path, but not double-counted for the same path on the same day. This matches your requirement for "true daily unique users per path" see here.If you want to ensure that users are only counted once per day per path (not per event occurrence), this approach is correct. You do not need to pull raw data for this calculation.Caveat: If you want to count each user only once per day across all paths (not per path), simply do not apply the breakdown.Reference: For more details on how unique user breakdowns work, see the documentation:
"When you apply a breakdown to a metric, by default, Mixpanel tells you how many unique users contributed to each segment... one user could have seen both a Home Page and a Shop Page, so they get counted as a user towards both segments."
Mixpanel Insights: UsersLet me know if you need step-by-step screenshots or further clarification!
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.

kapa.ai
APP
·
·
Hi Angela H., 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, you can get daily unique users for the "Loaded a Page" event by path name directly in Mixpanel, without needing to pull raw data.Here’s how you can do it: 1. Create an Insights Report: - Go to the Insights report. - Select the "Loaded a Page" event.2. Set the Measurement to Unique Users: - Under the event, change the measurement from "Total Events" to "Unique Users". This ensures you’re counting unique users (by user_id/distinct_id) per time interval, not unique event occurrences.3. Set the Time Interval to Day: - In the date/time selector, set the interval to "Day" to get daily counts.4. Break Down by Path Name: - Use the "Breakdown" feature to break down the event by the "path name" property (or whatever property holds your page path). This will show you, for each day, the number of unique users per path.Important Note: Mixpanel’s unique user counting for breakdowns works as follows: for each segment (in your case, each path), it counts the number of unique users who performed the event for that segment in the selected time interval. If a user visits multiple paths in a day, they will be counted once per path, but not double-counted for the same path on the same day. This matches your requirement for "true daily unique users per path" see here.If you want to ensure that users are only counted once per day per path (not per event occurrence), this approach is correct. You do not need to pull raw data for this calculation.Caveat: If you want to count each user only once per day across all paths (not per path), simply do not apply the breakdown.Reference: For more details on how unique user breakdowns work, see the documentation:
"When you apply a breakdown to a metric, by default, Mixpanel tells you how many unique users contributed to each segment... one user could have seen both a Home Page and a Shop Page, so they get counted as a user towards both segments."
Mixpanel Insights: UsersLet me know if you need step-by-step screenshots or further clarification!
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.