I want to understand how frequently users visited the product detail page over a specific time period in an Insight report. Here's how I set it up, but I'm not entirely sure what it means. Can you help clarify?
I selected the detail page event as the metric and added "First Time Ever".
Then, in the breakdown, I used "Aggregate property per user – distinct count per interval" with filters < 4 and >= 4.
What exactly does this setup represent?
Hi Alex, 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
Certainly! Let’s break down what your setup in the Mixpanel Insights report means, based on the available documentation:
1. Metric: Detail Page Event with "First Time Ever"
By selecting the detail page event and applying the "First Time Ever" filter, you are instructing Mixpanel to only consider the very first time each user visits the product detail page. This means your metric is counting only those events where it was the user's first visit to the detail page, not subsequent visits. If a user visits the detail page multiple times, only their first visit is included in this metric. Note that if a user has multiple "first" events with the same timestamp (e.g., due to rapid repeated actions), all those events will be counted as "first time" for that user Analyzing First Time Users.
2. Breakdown: Aggregate Property per User – Distinct Count per Interval
You then break down the metric using "Aggregate property per user – distinct count per interval." This means, for each user, Mixpanel calculates the number of distinct values of a chosen property (often the event itself or a property like product ID) within each time interval (e.g., day, week, or month, depending on your chart settings). The "distinct count" per user is then aggregated across all users for each interval. You can further aggregate this data using options like average, distribution, median, percentiles, minimum, and maximum Aggregate Property per User.
3. Filters: < 4
and > = 4
You applied filters to segment users based on their distinct count per interval:
- < 4
: Users who visited fewer than 4 distinct product detail pages in the interval.
- > = 4
: Users who visited 4 or more distinct product detail pages in the interval.
What Does This Setup Represent?
- You are analyzing, for each time interval, the first time users visit the product detail page. - For those first-time visits, you are segmenting users based on how many distinct product detail pages they viewed in that interval (e.g., how many unique products they saw on their first visit). - The breakdown shows you, per interval, how many users fall into each segment: those who viewed fewer than 4 unique product detail pages and those who viewed 4 or more, but only considering their first-ever visit(s) to the detail page.In summary: Your report tells you, for each time interval, how many users—on their first-ever visit to any product detail page—viewed fewer than 4 versus 4 or more unique product detail pages. This helps you understand the distribution of first-time user engagement with product detail pages, segmented by the breadth of their exploration during their initial session.If you want to analyze all visits (not just first-time), you should remove the "First Time Ever" filter. If you want to see frequency over time (e.g., how often users return), consider using "Frequency per User" instead Aggregate Property per User, Analyzing First Time Users.
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.
Let me check the knowledge base for you again. One moment! 📚
Based on the knowledge sources, when you use the "First Time Ever" filter in Mixpanel, only the first instance of the event performed by a user is considered. This means that if a customer visits one product detail page on their first visit, only that first event (and any others with the exact same timestamp, in case of a tie) is included in the "first visit" analysis. Any subsequent visits to other product detail pages on later days are not counted in this analysis.So, in your example: - Day 1: User views Product A (first-ever detail page visit) → counted. - Day 2: User views Product B (second detail page visit) → not counted in the "First Time Ever" analysis.Only the first day (and the first event(s)) is considered in the "first visit" analysis. Later visits are excluded from this specific filter Analyzing First Time Users.
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.
Let me check the knowledge base for you again. One moment! 📚
You can segment users in Mixpanel based on whether they have performed an event at least once or never performed it by creating a cohort using the cohort builder. In the cohort builder, you can define conditions such as: - Users who did <event> at least once (e.g., "Users who did 'View Product Detail' at least 1 time") - Users who never did <event> (e.g., "Users who did 'View Product Detail' 0 times")This allows you to group users into those who have performed the event and those who have not. You can then use these cohorts in your analyses and reports to compare behaviors or outcomes between these groups Creating Cohorts.Additionally, you can create these cohorts directly from report visualizations by selecting a group of users (e.g., those who did or did not perform an event) and saving them as a cohort for further analysis Group users by demographic and behavior.
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 I want to segment users into two groups:
Users who have triggered a specific event for the first time ever within a given date range (like what "First Time Ever" captures).
Users who have not triggered that event for the first time ever in that range (either triggered it earlier or never at all).
How can I build these two user groups for comparison? Can this be done using cohorts or filters?
Let me check the knowledge base for you again. One moment! 📚
To segment users as described:
1. Users who triggered the event for the first time ever within a given date range
You can create a cohort using the cohort builder with a condition like: - "Users who did <event> for the first time ever between [start date] and [end date]".Mixpanel allows you to filter to only the first time an event is performed by a user, using the "First Time Ever" filter. This filter can be applied in reports and cohort definitions to capture users whose first occurrence of the event falls within your specified date range Analyzing First Time Users, Creating Cohorts.
2. Users who have not triggered that event for the first time ever in that range
This group includes: - Users who triggered the event for the first time before the date range, and - Users who have never triggered the event.To create this group, you can define a cohort with a NOT condition: - "Users who did NOT do <event> for the first time ever between [start date] and [end date]".This can be set up in the cohort builder by inverting the first cohort’s condition (using the NOT operator or by excluding the first cohort from the total user base) Creating Cohorts.
How to Use These Cohorts
- You can use these cohorts as filters or breakdowns in your reports to compare behaviors, retention, or other metrics between the two groups Using Cohorts in Analysis.Summary: Yes, this segmentation can be done using cohorts in Mixpanel. Define one cohort for users whose first-ever event falls within your date range, and another cohort for users who do not meet that criterion (either by using NOT or by excluding the first cohort from all users).If you need to create a cohort based on a list of user IDs (for example, exported from a report), you can also use the CSV import method Creating Cohorts.
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 To create a cohort of users who did not perform a specific event for the first time ever within a given date range, is it correct to use this condition? “Did not do {event name} after [specific date], for the first time ever” Would this correctly capture users who either performed the event before that date or never performed it at all?
Let me check the knowledge base for you again. One moment! 📚
Your proposed condition—“Did not do {event name} after [specific date], for the first time ever”—is logically intended to capture users who either: - Performed the event for the first time before the specified date, or - Never performed the event at all.Based on Mixpanel’s documentation, when you use the "First Time Ever" filter, Mixpanel identifies the first occurrence of the event for each user. If you then filter for users who did not do the event for the first time after a certain date, you are excluding users whose first-ever event falls after that date. This leaves you with users whose first-ever event was before that date, or who never performed the event (and thus have no first time at all).This approach aligns with how Mixpanel computes first-time events and how cohort conditions can be defined using the cohort builder Analyzing First Time Users, Creating Cohorts.In summary: Yes, using the condition “Did not do {event name} after [specific date], for the first time ever” will correctly capture users who either performed the event for the first time before that date or never performed it at all.
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 I'm using the "Compare to previous 30 days" feature in my analysis, but when I apply a cohort condition like "Did not do {event} after [specific date], for the first time ever", I notice that the comparison group doesn't show any data before that date. Is this expected behavior? Does using a cohort with a date-specific "first time ever" condition limit the ability to compare across earlier time ranges?