Hey folks, I would like to count unique users per day who converted through a funnel. Is this possible?
Yes, this is possible in Mixpanel, though there's an important nuance depending on how you approach it.
Option 1: Funnels Report – Line Chart (by Day)
In the Funnels report, if you use the line chart visualization with a daily time interval, Mixpanel runs a separate funnel for each day in your date range. This means a user can enter and be counted on multiple days. [Funnels FAQ]
Measurement to use: Set the measurement to Unique Users (with the Uniques counting method) and select the final step (or "All Steps") to measure conversions. [Counting Methods]
This gives you a daily view of unique users who converted, where each day's funnel is independent.
Option 2: Funnels Report – Table with Day Breakdown
Alternatively, you can use the Table visualization with a day breakdown. However, note that this runs a single funnel across the full date range and then segments results by day — so each user is only counted once overall. [Funnels FAQ]
Option 3: Insights Report with Funnel Behavior
You can also use the Insights report and add a Funnel Behavior metric. This allows you to measure funnel conversion over time with a line chart, giving you a daily breakdown of unique users who converted. [Insights Basic Features]
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
