kapa.ai I have created the report that tracks the number of users who open my app for the first time (used $ae_first_open event) and the number of users who actually sign up. Results: the number of users who do first app open is lower then the number of users who actually sign up? Please, explain
Please stand by Khrystyna S. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
This situation—where the number of users who trigger the $ae_first_open
event is lower than the number of users who sign up—can occur due to several reasons related to how events are tracked and reported in Mixpanel: 1. Event Trigger Timing Differences: The $ae_first_open
event is triggered when the Mixpanel SDK loads and detects the app being opened for the first time on a device. If a user signs up before this event is triggered (for example, if the sign-up process is initiated via a webview or another method before the SDK loads), the sign-up event may be recorded without a corresponding $ae_first_open
event for that user. Additionally, if the SDK fails to initialize or is blocked (e.g., by network issues or ad blockers), the $ae_first_open
event may not be sent, but the sign-up event could still be tracked via another method or backend system. This is a common source of discrepancies between different event counts in Mixpanel reports see: Data Discrepancies.2. Client-Side vs. Server-Side Tracking: If your sign-up event is tracked server-side (e.g., via an API call) and $ae_first_open
is tracked client-side, users who block client-side tracking (due to ad blockers, privacy settings, or SDK initialization issues) may not trigger $ae_first_open
but will still be counted as sign-ups. This can lead to more sign-ups than first app opens see: Ad Blockers and Do Not Track Settings.3. Event Definition Differences: The definition of "first app open" may differ between systems or implementations. For example, $ae_first_open
is retriggered if the user reinstalls the app or clears local storage, but if a user signs up on a different device or after reinstalling, the events may not align as expected see: Legacy Automatically Tracked Events.4. Data Filtering and Timeframes: Ensure that both events are being analyzed over the same time frame, with the same filters and user identification logic. Differences in filters, time zones, or user ID management can cause discrepancies in reported numbers see: Debugging Discrepancies.Summary:
It is not uncommon to see more sign-ups than first app opens due to differences in how and when events are tracked, especially if you are mixing client-side and server-side tracking or if there are issues with SDK initialization or event delivery. To debug further, compare the user IDs for both events, check your tracking implementation, and ensure consistent event definitions and timeframes across your reports.If you need to establish a source of truth, consider implementing server-side tracking for both events, as it is generally more reliable and less prone to client-side issues see: Debugging Discrepancies.
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 know the number of registered users in my app. how do i do that?
Let me check the knowledge base for you again. One moment! 📚
To find the number of registered users in your app using Mixpanel, you should track a "Sign Up" event whenever a user completes the registration process. Then, in Mixpanel, you can create an Insights report that counts the number of unique users who have performed the "Sign Up" event.Here’s how you can do it: 1. Track the "Sign Up" Event: Make sure your app is sending a "Sign Up" event to Mixpanel when a user registers. For example, in JavaScript:
'Signup Type': 'Referral'
});
```LBKS Replace or add properties as needed for your use case [Track Events Code Example](https://docs.mixpanel.com/docs/quickstart/capture-events/track-events#code).LBKS2. **Create an Insights Report:**
- Go to the Insights report in Mixpanel.
- Select the "Sign Up" event.
- Change the measurement to "Unique Users" to count the number of distinct users who have registered [What to Track](https://docs.mixpanel.com/docs/what-to-track).LBKSThis will show you the total number of registered users based on the "Sign Up" event. If you want to see the total number of user profiles (regardless of event), you can also view the total count of user profiles from the Users page [Users: Explore your user base in Mixpanel](https://docs.mixpanel.com/docs/users).LBKS**Tip:**
If you want to track additional details (like registration source or country), include those as properties on your "Sign Up" event.LBKSIf you have not set up the "Sign Up" event yet, you’ll need to implement this tracking in your app first.
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 if i set up a profile property today does that mean that Mixpanel will capture data for this property starting from today? and i will not have historical data from two months before?
Let me check the knowledge base for you again. One moment! 📚
If you set up a new profile property today using standard user profile updates (e.g., via the SDK or API), Mixpanel will only capture and store the value of that property from today onward. The property will not have historical values for previous dates—Mixpanel will only show the latest value, and all past events will be joined with this current value, not what it was in the past see: FAQ on User Profiles.However, if you want to have historical data for a profile property (for example, to analyze how the property changed over time or to see what its value was at the time of past events), you need to import historical profile values using a Warehouse Connector and a history table. This allows Mixpanel to capture changes in each property over time, so the property value can be matched to the correct time period for analysis Importing Historical Profile Values and How do I set the initial set of profile properties for the user?.In summary: - Setting a new profile property today will only capture data from today forward. - To have historical values, you must import them via a Warehouse Connector with a history table.If you do not use a history table, you will not have access to property values from two months ago.
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 is it possible to build a report with visualisation pie and percentages?
Let me check the knowledge base for you again. One moment! 📚
Yes, it is possible to build a report in Mixpanel with a pie chart visualization and display percentages. The Insights report supports the pie chart type, which is designed to show the composition of segments as parts of a whole. When you use a breakdown (e.g., by a property like "Country" or "Signup Source"), the pie chart will display each segment as a slice, and Mixpanel will show the percentage that each segment represents of the total Docs / Reports / Insights: Basic Features.However, note that while you can use pie charts for visualizing segment percentages, certain comparison features (like time comparison or percent change over baseline) are not supported on pie charts Supported Charts.To summarize: - Pie chart visualization is available in Insights. - Percentages for each segment are shown in the pie chart. - Some advanced comparison features are not available for pie charts.You can select the pie chart type when building or editing your Insights report after applying a breakdown.
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 use event sign up with property method (values: apple, google) and build a pie chart that represent percentages of users who sign up via different methods
Let me check the knowledge base for you again. One moment! 📚
To build a pie chart in Mixpanel that shows the percentage of users who signed up via different methods (e.g., "apple" or "google" in the property method), follow these steps: 1. Track the "Sign Up" Event with the "method" Property Ensure your "Sign Up" event includes the property method with values like "apple" or "google":
method: 'apple' // or 'google'
});
```LBKS [Track Events Code Example](https://docs.mixpanel.com/docs/quickstart/capture-events/track-events#code)LBKS2. **Create an Insights Report**
- Go to the Insights report in Mixpanel.
- Select the "Sign Up" event as your metric.
- Set the measurement to "Unique Users" to count distinct sign-ups.LBKS3. **Breakdown by the "method" Property**
- Click the **Breakdown** button.
- Choose the property method to segment the data by sign-up method.LBKS4. **Change Visualization to Pie Chart**
- In the visualization options (top right), select the **Pie** chart.
- The pie chart will display each method as a slice, with the percentage of users for each method shown on the chart.LBKSThis will give you a pie chart representing the percentage of users who signed up via "apple" versus "google" [Docs / Reports / Insights: Basic Features](https://docs.mixpanel.com/docs/reports/insights#basic-features).LBKS**Note:** The pie chart will automatically show the percentage for each segment after you apply the breakdown.
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've just did it and it shows me the number of unique users per each slice, not percentage. how do i change it to percentage?
Let me check the knowledge base for you again. One moment! 📚
I'm sorry, but the knowledge sources do not explicitly mention an option to display percentages directly on the pie chart slices in Mixpanel. The documentation confirms that you can use a pie chart to visualize the breakdown of segments (such as sign-up methods) and that the chart will show the composition, but it does not specify whether you can toggle the display from counts to percentages on the chart itself. Some advanced comparison features (like percentage of overall) are not supported on pie charts either Supported Charts.You may see the percentage composition in the data table below the chart or in tooltips, but the sources do not confirm a way to show percentages as the primary label on the pie slices. If this feature is critical, you may want to check Mixpanel’s latest UI or contact their support for confirmation.
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 which visualisation supports percentage of overall?
Let me check the knowledge base for you again. One moment! 📚
The following visualizations in Mixpanel support the "percentage of overall" comparison: - Insights Line - Insights Bar - Insights Metric - Insights Stacked Line (supports percentage of overall, but not time or baseline comparisons)Other chart types, such as Pie, Stacked Bar, Funnel Steps, and Retention Curve, do not support the "percentage of overall" comparison option Supported Charts.To use this feature, open the Compare menu in your report and select "Percentage of Overall" when using a supported visualization Comparison: Time, Baseline and Overall.
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 does dashboard filter override chart filter?
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel, when you apply a filter at the Board (dashboard) level, it does not override the filters set within individual reports (charts). Instead, the Board-wide filters and date ranges update the data displayed when viewing those reports on the Board. The original filters of each report remain unchanged, and if you access a report directly (outside the Board), it will display using its own saved filters and date range. Board filters are temporary and only affect the view within the Board context unless you use Pinned Filters to make them permanent Step 5: Board-wide Date Ranges and Filters.So, Board (dashboard) filters do not override chart filters—they are applied in addition to the chart’s own filters when viewing on the Board.
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 build a chart that shows the percentage of users who sign up and view homescreen for the first time
Let me check the knowledge base for you again. One moment! 📚
To build a chart in Mixpanel that shows the percentage of users who sign up and view the homescreen for the first time, you should use a Funnels report. This allows you to measure the conversion rate from "Sign Up" to "View Homescreen (First Time)".Here’s how you can do it: 1. Create a Funnels Report: - Go to the Funnels report in Mixpanel. - Define your funnel steps: 1. Step 1: "Sign Up" event. 2. Step 2: "View Homescreen" event, filtered to only the first time the user performs this event (use the First Time filter) Analyzing First Time Users.2. Set the Measurement: - By default, the Funnels report will show the unique conversion rate, which is the percentage of users who completed both steps in order within the specified time window Funnels Quickstart.3. Visualize the Funnel: - Use the "Funnel Steps" visualization to see the conversion rate as a percentage from "Sign Up" to "View Homescreen (First Time)". - You can also use the "Line" or "Bar" visualization to see how this percentage trends over time.Summary: A Funnels report with "Sign Up" as the first step and "View Homescreen" (filtered to first time) as the second step will show you the percentage of users who sign up and then view the homescreen for the first time. The conversion rate between these steps is the percentage you’re looking for.For more details, see the documentation on Funnels and First Time Filters.
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 what's the difference between conversion rate and total conversion measurement in funnel reports?
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel funnel reports: - Conversion Rate measures the rate at which funnels are completed for the selected steps. It is calculated as the percentage of users who entered the funnel and completed all the steps within the specified time window. This measurement is available for Uniques (default), Totals, or Sessions counting methods.- Total Conversions is the total number of funnels that have reached the selected step. It counts every time a user completes the funnel, allowing for multiple conversions per user if the counting method is set to Totals. This measurement is only available with the Totals counting method.So, Conversion Rate gives you the percentage of users who converted, while Total Conversions gives you the absolute number of times the funnel was completed Counting Methods and Measurements.
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 please, build a report that shows what users do after they register and view home screen for the first time
Let me check the knowledge base for you again. One moment! 📚
To build a report in Mixpanel that shows what users do after they register and view the home screen for the first time, you should use the Flows report. This report helps you visualize the most common paths users take after a sequence of events.Here’s how you can set it up: 1. Go to the Flows Report in Mixpanel.2. Set the Steps: - Add "Sign Up" as the first event. - Add "View Home Screen" as the second event, and apply the First Time filter to ensure you’re only considering the first time users view the home screen after registering Analyzing First Time Users.3. Add Steps After: - In the Flows report, use the "+" button to add steps after "View Home Screen" to see what users do next. By default, Flows will show the top events users perform after this sequence Flows: Basic Features.4. Analyze the Results: - The Sankey diagram will display the most common actions users take after registering and viewing the home screen for the first time. You can hover over each path to see the number and percentage of users who follow each path Flows Overview.This setup will give you a clear visualization of user behavior immediately after registration and their first home screen view, helping you identify the most frequent next actions and potential drop-off points.
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 in time dto convert distribution i can see that 4000+% of users convert at a certain time. why do i have such high percentage?
Let me check the knowledge base for you again. One moment! 📚
I'm sorry, but the knowledge sources do not explicitly mention a scenario where the "Time to Convert" distribution in Mixpanel shows percentages exceeding 100% (such as 4000+%). Normally, the "Time to Convert" breakdown should display the distribution of conversion times as a percentage of total conversions, and these percentages should sum to 100% across all buckets Time to Convert Measurement.If you are seeing percentages much higher than 100%, this could indicate a reporting or configuration issue, such as overlapping buckets, misconfigured breakdowns, or a visualization bug. However, the documentation does not provide details on this specific issue.For accurate troubleshooting, I recommend reviewing your funnel setup and, if the issue persists, reaching out to Mixpanel support for further assistance.
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 have a funnel report that measures the average time to convert and the breakdown is by time to convert. i set buckets to 0-24 hours with 1 hour step. visualisation - bar chart. I get the results: time bucket 0-1 hour show 1.5 min, time bucket 1-2 hours shows 1 hour and time bucket 20-24 hours shows 1 day. once i hover over a bar that shows 20-24 hours i can see 4840% of overall. please explain what is means
Let me check the knowledge base for you again. One moment! 📚
Based on the available knowledge sources, the "Time to Convert" breakdown in Mixpanel allows you to see a distribution of how long it takes users to convert between funnel steps, with the ability to customize the bucketing (e.g., 0–1 hour, 1–2 hours, etc.). The bar chart visualization should show the average time to convert for each bucket, and when you hover over a bar, you typically see the count or percentage of conversions that fall into that bucket Time to Convert Measurement.However, the knowledge sources do not explain why you would see a value like "4840% of overall" when hovering over a time bucket. Normally, the percentage should represent the share of conversions in that bucket relative to the total, and percentages across all buckets should sum to 100%. Seeing a value much greater than 100% suggests there may be a reporting or calculation issue, but the documentation does not provide details on this scenario.In summary: The knowledge sources do not explicitly explain why you are seeing percentages over 100% (such as 4840%) in the "Time to Convert" breakdown. This is not expected behavior according to the documentation, and may indicate a bug or misconfiguration. For further clarification, you may need to contact Mixpanel support.
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 how does mixpanel calculate funnels?
Let me check the knowledge base for you again. One moment! 📚
Mixpanel calculates funnels by tracking how users perform a defined sequence of events within a specified time window. Here’s how the calculation works: 1. Funnel Definition: You define a funnel as a series of events (e.g., "Sign Up" → "View Home Screen" → "Purchase") that users must complete in order. You can specify the order (specific or any order), apply filters, and set a conversion window (the maximum time allowed between the first and last step) Funnels Overview Funnels Advanced Concepts.2. User Entry: A user enters the funnel when they perform the first event (Step 1) within the selected date range. The conversion window starts at this point Funnels Advanced Concepts.3. Conversion Calculation: - The user must complete each subsequent step in the funnel within the conversion window to be counted as converted. - Users can perform other actions between funnel steps, but only the defined steps in the correct order (unless "Any Order" is selected) count toward conversion Ordering. - If a user does not complete all steps within the window, they are counted as dropped off at the last completed step.4. Counting Methods: - Uniques: Each user is counted once, on their first entry. - Totals: Users can re-enter the funnel after exiting (by converting, timing out, or being excluded). - Sessions: Users can enter the funnel in each qualifying session Counting Methods and Measurements.5. Filters and Breakdowns: - You can apply inline (pre-query) filters to each step or global (post-query) filters to the entire funnel. - Breakdowns segment the funnel by properties (e.g., device, country), and users can appear in multiple segments if they re-enter with different property values Filters Breakdowns.6. Re-Entry and Exclusions: - With "Totals" or "Sessions," users can re-enter the funnel after exiting. - Exclusion steps can be added to remove users who perform certain actions between steps Optimized Re-entry.
In summary, Mixpanel funnels measure how users progress through a series of events, applying your chosen filters, order, and time constraints, and provide conversion rates, drop-off points, and other insights based on your configuration.
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 have a funnel sign up started and sign up completed broken down by sign up method (apple and email) and for each method i get 100%. when i build a funnel for email sign up only i add 1 more step - security code entered and the funnel shows the 10% drop. please explain why in funnel 1 i have 100
Let me check the knowledge base for you again. One moment! 📚
In your first funnel ("Sign Up Started" → "Sign Up Completed" broken down by sign up method), you see 100% conversion for both Apple and Email. This means that, for the users who started sign up via each method, all of them also completed sign up—there is no drop-off between these two steps for either method.When you build a second funnel for Email sign up only and add an additional step ("Security Code Entered"), you see a 10% drop. This indicates that not all users who started sign up and completed sign up also entered the security code—only about 90% did, so the conversion rate drops at this step.Why do you see 100% in the first funnel? - The first funnel only measures users who started and completed sign up, so it only includes users who performed both actions. If your data or event tracking is set up such that every "Sign Up Started" is always followed by a "Sign Up Completed" (for example, due to how events are tracked or filtered), you will see 100% conversion. - The breakdown by method (Apple, Email) simply segments the users, but if every user in each segment completes both steps, the conversion rate remains 100% for each.Why does the conversion drop in the second funnel? - By adding "Security Code Entered" as a step, you introduce a point where users can drop off. Not all users who start and complete sign up go on to enter the security code, so the funnel now reveals this drop-off.This behavior is consistent with how Mixpanel funnels work: each step in the funnel is an additional requirement for conversion, and drop-off is only visible when users fail to complete a step in the defined sequence Funnels Advanced Concepts.If you want to see drop-off between "Sign Up Started" and "Sign Up Completed," ensure that your event tracking accurately captures cases where users start but do not complete sign up. If your data only includes users who complete both, the funnel will always show 100% conversion between those steps.
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 but doesn't that mean that if 10% of users do not enter the code when signing up via email the drop off in the funnel 1 should be represented as well?
Let me check the knowledge base for you again. One moment! 📚
No, the drop-off at the "Security Code Entered" step will not be represented in Funnel 1 if that step is not included in the funnel definition. In Mixpanel, a funnel only measures drop-off between the specific steps you define. If your funnel is "Sign Up Started" → "Sign Up Completed," it will only show the conversion rate between those two events, regardless of what happens in between or after. Users who do not enter the security code but still complete the "Sign Up Completed" event will be counted as converted in Funnel 1.To see drop-off at the "Security Code Entered" step, you must explicitly include it as a step in your funnel. Only then will Mixpanel show the drop-off between "Sign Up Completed" and "Security Code Entered" Ordering.In summary, Mixpanel funnels only reflect drop-off at the steps you define in the funnel, not at steps that are not included.
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 is it possible to compare different funnels in a single report?
Let me check the knowledge base for you again. One moment! 📚
Yes, it is possible to compare different funnel metrics in a single report in Mixpanel. You can plot any funnel (or retention) metric in the Insights report and view them side by side with other metrics. This allows you to track and compare multiple funnel behaviors without toggling between separate reports or boards. For example, you can see how different funnels perform together and analyze their trends within a single visualization Plot Insights, funnels, and retention on the same chart.However, the knowledge sources do not mention a way to directly overlay two separate Funnels reports in a single Funnels report view. The comparison is done by adding funnel metrics to an Insights report.
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 in my insights report i calculate unique users who sign up. in the query builder there is a possibility to switch from the number of unique users to the percentage of unique users. please, explain
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel’s Insights report, when you calculate the number of unique users who sign up, you can switch the display from the absolute number of unique users to the percentage of unique users. This feature is available through the Compare → Percentage of Overall option in the report controls.When you enable "Percentage of Overall," Mixpanel shows each segment (for example, each sign-up method or country, if you’ve applied a breakdown) as a percentage of the total unique users for the selected event. This helps you understand the relative contribution of each segment to the overall total. For example, if you break down sign-ups by method (Apple, Google, Email), you’ll see what percentage of all sign-ups each method represents, rather than just the raw count.This option is available for supported visualizations such as line, bar, metric, and stacked line charts, but not for pie charts or some other chart types Comparison: Time, Baseline and Overall Supported Charts.Summary: Switching to "percentage of unique users" allows you to view each segment’s share of the total unique users for your event, making it easier to compare the relative size of each group within your data.
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 in my insights report i calculate unique users who purchase product. in the query builder right above the event selected for the analysis there is a possibility to switch from the number of unique users to the percentage of unique users. please, explain
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel’s Insights report, when you are analyzing the number of unique users who purchase a product, you can switch from viewing the absolute number of unique users to viewing the percentage of unique users. This is done using the "Percentage of Overall" comparison option in the report controls.When you enable this option, Mixpanel displays each segment (for example, if you break down by product category or purchase method) as a percentage of the total unique users who performed the purchase event. This helps you understand the relative contribution of each segment to the overall total, rather than just the raw count.This feature is available for supported visualizations such as line, bar, metric, and stacked line charts. It is not available for pie charts or some other chart types Comparison: Time, Baseline and Overall Supported Charts.In summary: Switching to "percentage of unique users" allows you to see what portion of all purchasing users each segment represents, making it easier to compare the relative size of each group within your data.
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 how to measure monthly active users?
Let me check the knowledge base for you again. One moment! 📚
To measure Monthly Active Users (MAU) in Mixpanel: 1. Define what an active user means for your product. This could be any meaningful engagement, such as "watched a video," "opened the app," or any other event that represents value for your business. The definition should be relevant to your product and can be customized in Mixpanel MAU: A definition.2. Create an Insights report: - Select the event(s) that define your active users. - Set the time range to one month or use the MAU (Monthly Active Users) function. - Change the measurement to "Unique Users" to count distinct users who performed the event within the last 30 days How to calculate MAU, Docs: Insights Users.3. Interpret the result: The resulting number is your MAU—the count of unique users who engaged with your product in a meaningful way during the selected month.Example: If you want to measure users who watched a video in the last month: - Select the "Watch Video" event. - Set the measurement to "Monthly Active Users (MAU)" or "Unique Users" with a 30-day interval.Mixpanel provides flexibility to customize which events count as "active," so you can tailor MAU to your business needs How to measure MAU in Mixpanel.You can also break down MAU by properties (e.g., country, device) for deeper analysis.
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 create a cohort of users who do at least 1 session per month?
Let me check the knowledge base for you again. One moment! 📚
To create a cohort of users who do at least 1 session per month in Mixpanel: 1. Go to the Cohort Builder: Open the Cohort Builder from the Users page or directly from the query builder in any report.2. Set the Cohort Condition: Define the condition as: - Users who did the event “Session Start” at least 1 time in the last 30 days (or per month, depending on your desired time frame). In the Cohort Builder, this would look like: - “Users who did ‘Session Start’ at least 1 time in the last 30 days.”3. Save the Cohort: Name and save your cohort. You can now use this cohort in your analysis and reports.This approach uses the “Session Start” event to identify users with at least one session in the past month, matching your requirement Creating Cohorts.If you want to automate this for every month, you can keep the rolling 30-day window in your cohort definition, so it always reflects users active in the most recent month.
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 what is App session event?
Let me check the knowledge base for you again. One moment! 📚
The App Session event ($ae_session
) is a legacy automatically tracked event in Mixpanel’s mobile SDKs (iOS and Swift). It is triggered when a user spends more than 10 seconds in the app. This event includes a property called Session Length
($ae_session_length
), which reflects the number of seconds the user spent in the session. Additionally, two user properties are tracked: Total App Sessions
($ae_total_app_sessions
) and Total App Session Length
($ae_total_app_session_length
) Legacy Automatically Tracked Events (iOS) Legacy Automatically Tracked Events (Swift).> Note: Mixpanel does not recommend enabling this legacy auto-tracking feature, as it relies on client-side state and can be unreliable. It is generally better to implement custom event tracking for more accurate analytics.
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 create a report that calculates the number of users who make any activity on the app in the last 6 months
Let me check the knowledge base for you again. One moment! 📚
To create a report in Mixpanel that calculates the number of users who make any activity on the app in the last 6 months, follow these steps: 1. Go to the Insights report in Mixpanel. 2. Select the event that represents "any activity." If you want to include all activity, you can use the "Any Event" option as your metric. 3. Set the measurement to "Unique Users" to count distinct users who performed any event. 4. Set the date range to the last 6 months.This will show you the number of unique users who performed any activity on your app in the last 6 months Docs / Reports / Insights Docs / Reports / Insights: Users.Summary of steps: - Insights report → Metric: Any Event → Measurement: Unique Users → Date range: Last 6 monthsThis approach gives you the total number of users who were active in your app during the specified period.
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 on dashboard level i have set up a filter of cohort and on the report level i have set up a filter of MAU. does that mean that my report will consider both filters?
Let me check the knowledge base for you again. One moment! 📚
Yes, your report will consider both filters: the cohort filter set at the dashboard (Board) level and the MAU filter set at the report level. When you apply a filter at the Board level, it does not override the filters set within individual reports. Instead, the Board-wide filters are applied in addition to the report’s own filters when viewing the report on the Board. This means that the data shown in your report will be filtered by both the cohort (from the Board) and the MAU criteria (from the report itself) Step 5: Board-wide Date Ranges and Filters.If you open the report outside the Board, only the report-level filter (MAU) will apply. But when viewed on the Board, both filters are in effect.
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 in my report for distinct count of session duration i want to see how many users are have 2 min session, 5 min session, 30 min session. how do i do it
Let me check the knowledge base for you again. One moment! 📚
To see how many users have sessions of specific durations (e.g., 2 min, 5 min, 30 min), you should use the Session Duration (Seconds) property in your analysis. Here’s how you can do it in Mixpanel: 1. Create an Insights Report Go to the Insights report.2. Select the "Session Start" Event Use the "Session Start" event as your metric, since session properties (like duration) are attached to this event Session Properties.3. Breakdown by Session Duration - Add a breakdown by the property Session Duration (Seconds). - Use custom buckets to group session durations into meaningful ranges (e.g., 0–2 min, 2–5 min, 5–30 min, 30+ min). You can do this by selecting the property in Breakdown, then choosing "Customize Buckets" from the overflow menu. Enter your desired bucket ranges (e.g., 120, 300, 1800 seconds for 2, 5, 30 minutes) Custom Buckets: Numeric property Use Cases.4. Set the Measurement - Change the measurement to Unique Users to see how many distinct users fall into each session duration bucket Insights: Measurements.This will show you, for each session duration bucket (e.g., 2 min, 5 min, 30 min), how many unique users had sessions of that length.Note: If you want to see the exact number of users for sessions of exactly 2, 5, or 30 minutes, create very narrow buckets (e.g., 120–121 seconds for 2 min) in the custom buckets modal.For more details, see the documentation on Custom Buckets for Numeric Properties and Session Properties.
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 in report that measures session duration in seconds - how to change measurement to minutes?
Let me check the knowledge base for you again. One moment! 📚
To change the measurement of session duration from seconds to minutes in your Mixpanel report, you can use a formula to divide the session duration by 60. For example, if you are using the “Session Duration (seconds)” property, create a formula in your Insights report that divides this value by 60 to display the duration in minutes see: Formulas in Insights.> “To change it from seconds to minutes, you can use our formula and divide it by 60.”
1. In your Insights report, add the “Session Duration (seconds)” property. 2. Click the Metrics button and select Formula. 3. Enter the formula:
```LBKS (where “A” is the variable for your session duration metric).
4. The resulting metric will now display session duration in minutes.LBKSThis will convert and display your session duration in minutes instead of seconds.
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 how mixpanel defines a session?
Let me check the knowledge base for you again. One moment! 📚
Mixpanel defines a session as a period of continuous user activity, computed automatically from the events you send to Mixpanel. Sessions are represented by two virtual events: Session Start and Session End. The way sessions are computed can be configured in three ways: 1. Timeout-Based (Default):
A session starts when a user performs any event (that is not excluded), and ends when the user is inactive for a set period of time (default: 30 minutes). The session ends at the time of the last event before the inactivity period elapses. Sessions are also reset every 24 hours at midnight according to your project timezone, so the maximum session length is 24 hours (Docs / Features / Sessions).2. Event-Based:
You define specific events that mark the start and end of a session (e.g., "Login" and "Logout"). A session begins when the start event occurs and ends when the end event occurs. Sessions are also reset at midnight (Event-Based Sessions).3. Property-Based:
You specify a property (such as session_id
). All events with the same value for this property are considered part of the same session. When the value changes, a new session starts. Sessions are also reset at midnight (Property-Based Sessions).Project Admins or Owners can choose the session computation method in Project Settings, and you can change this definition at any time—it will apply historically to your data (Docs / Features / Sessions).Summary:
A session in Mixpanel is a configurable period of user activity, defined by timeout, specific events, or a session property, and is marked by virtual "Session Start" and "Session End" events.
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 what is considered as a session end?
Let me check the knowledge base for you again. One moment! 📚
A session end in Mixpanel is determined by the session computation method you have configured: - Timeout-Based Sessions (default):
A session ends when a user is inactive for a specified period (default: 30 minutes). The session end time is the time of the last event performed before this inactivity period elapses. Additionally, all sessions are reset at midnight according to your project timezone, so the maximum session length is 24 hours (Session Computation Deep-Dive, Examples).- Event-Based Sessions:
A session ends when the user performs the event you have defined as the "Session End" event (e.g., "Logout"). Sessions are also reset at midnight, so if a session spans midnight, it will be split (Event-Based Sessions).- Property-Based Sessions:
A session ends when the value of the specified session property (e.g., session_id
) changes, or at midnight. If an event with a new or empty session property value is received, the previous session ends (Property-Based Sessions).In all methods, sessions are also reset every 24 hours at midnight, regardless of user activity.Summary:
A session end occurs when the inactivity timeout is reached, a defined "Session End" event is performed, the session property changes, or at midnight—depending on your session configuration.
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 build a report that shows most popular events performed by users who's session duration is equal to or greater than 5 min
Let me check the knowledge base for you again. One moment! 📚
To build a report in Mixpanel that shows the most popular events performed by users whose session duration is equal to or greater than 5 minutes, follow these steps: 1. Create an Insights Report
Go to the Insights report in Mixpanel.2. Select the Event(s) to Analyze
Choose "Any Event" as your metric to include all events, or select specific events you want to analyze.3. Add a Filter for Session Duration
Add a filter on the property Session Duration (Seconds) (attached to the "Session Start" event). Set the filter to Session Duration (Seconds) > = 300
(since 5 minutes = 300 seconds) (Session Properties).4. Breakdown by Event Name
Use the Breakdown feature to group results by "Event Name." This will show you which events are most frequently performed in sessions that last at least 5 minutes (Advanced: Query Builder Features).5. Set the Measurement
Use "Total Events" or "Unique Users" as your measurement, depending on whether you want to see the most popular events by count or by the number of users performing them.Summary of Steps:
- Insights report → Metric: Any Event → Filter: Session Duration (Seconds) > = 300 → Breakdown: Event Name → Measurement: Total Events or Unique UsersThis will display the most popular events performed by users in sessions lasting 5 minutes or longer, allowing you to analyze engagement in longer sessions.For more details, see Session Properties and Query Builder Features.
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 how to create a cohort of users who's session duration is equal to or greater than 5 min?
Let me check the knowledge base for you again. One moment! 📚
To create a cohort of users whose session duration is equal to or greater than 5 minutes in Mixpanel: 1. Go to the Cohort Builder: Open the Cohort Builder from the Users page or from the query builder in any report.2. Set the Cohort Condition: Define the condition as: - Users who did the event “Session Start” where the property Session Duration (Seconds) is greater than or equal to 300 (since 5 minutes = 300 seconds). In the Cohort Builder, this would look like: - “Users who did ‘Session Start’ where Session Duration (Seconds) > = 300 in the last [desired time frame]”.3. Save the Cohort: Name and save your cohort. You can now use this cohort in your analysis and reports.This approach uses the “Session Start” event and filters by the session duration property, as described in the documentation on session properties and cohort creation Session Properties 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 what should i select before property& there is one more filed that goes after the event field and i can choose either total events or some option from aggregated property
Let me check the knowledge base for you again. One moment! 📚
In the Mixpanel Cohort Builder or Insights report, when you are setting up a condition like "Users who did [Event] where [Property]...", the field before the property is the event you want to analyze (for example, "Session Start"). The field after the event is the measurement—here, you can choose options like "Total Events" or an aggregation from "Aggregate Property." - Total Events counts how many times the event was performed. - Aggregate Property lets you select a property (such as "Session Duration (Seconds)") and then choose an aggregation type (e.g., sum, average, minimum, maximum) to apply to that property for each user Insights: Measurements Behavioral Properties.For your use case (e.g., users whose session duration is ≥ 5 min), you would: 1. Select the event: Session Start 2. After the event field, choose Aggregate Property and select "Session Duration (Seconds)" with the appropriate aggregation (e.g., "Maximum" or "Average"). 3. Set the condition: "is greater than or equal to 300" (for 5 minutes).This setup allows you to filter users based on an aggregated property value related to the event you selected.
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 why i can't use session start event in retention report?
Let me check the knowledge base for you again. One moment! 📚
You cannot use the "Session Start" event in a Retention report because "Session Start" is a virtual event generated by Mixpanel at query time and does not exist as a raw event in your data store. Retention reports in Mixpanel are designed to work with actual tracked events, not virtual events like "Session Start" or "Session End." Virtual events are available for analysis in reports such as Insights, Funnels, and Flows, but not in Retention or for export via the API Why do I see Session Start and Session End events in my project?.This limitation exists because Retention reports require real, stored events to accurately measure user return behavior over time, while virtual events are computed dynamically and are not part of the underlying event data.
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 build a retention report that shows how users visit my app
Let me check the knowledge base for you again. One moment! 📚
To build a retention report that shows how users visit your app in Mixpanel, follow these steps: 1. Go to the Retention Report In Mixpanel, navigate to the Retention report section.2. Define the Retention Behavior - For the first event (A), select an event that represents a user visiting your app for the first time (e.g., "App Opened" or "Sign Up Completed"). - For the return event (B), you can select "Any Event" or a specific event that indicates a user has returned to the app.3. Choose Your Measurement By default, the Retention report will use "Retention Rate" as the measurement, showing the percentage of users who return after their first visit. You can also choose "Unique Users" to see the absolute number of returning users Docs / Reports / Retention.4. Set the Time Interval Choose the time interval (day, week, or month) to measure how often users return after their initial visit. You can also use custom retention brackets for more flexible intervals Custom Retention Brackets.5. Apply Filters or Breakdowns (Optional) You can filter the report to focus on specific user segments or break down the results by properties such as device type or country to see how different groups of users return to your app Docs / Reports / Retention.6. Visualize the Results Use the retention curve or table to see how many users return to your app over time after their initial visit. The report will show you, for each cohort of new users, what percentage (or number) return in subsequent time periods.Note: If you want to analyze retention based on sessions, you cannot use the "Session Start" event in the Retention report, as it is a virtual event and not supported in this report type FAQ: Session Start in Retention.For more details, see the Retention report documentation.
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 what is Any event in retention report? I cannot see it in the lexicon
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel, "Any Event" in the retention report is a special option that allows you to measure retention based on whether a user performed any tracked event, rather than a specific event. This is useful for understanding general user return behavior, regardless of the exact action they took.You will not see "Any Event" listed in the Lexicon because it is not an actual event that is tracked or stored in your project data. Instead, it is a virtual selection available in the report builder to represent all events collectively. The Lexicon only documents real, tracked events and properties in your project, not virtual or aggregate options like "Any Event" Docs / Data-governance / Lexicon: Overview.So, "Any Event" is a reporting convenience, not a tracked event, which is why it does not appear in the Lexicon.
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 in retention report we have on and on or after operator under retention criteria. explain the difference
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel’s retention report, the "On" and "On or After" operators under retention criteria define how user return is measured for each time interval: - "On" Retention: Calculates the percentage of users who come back and perform the return event on an exact time unit after the initial event. For example, "Day 5 retention" means the user returned exactly on the fifth day after the first event—no earlier, no later. This is useful for understanding high-level usage patterns or when your product relies on users returning in each specific time unit.- "On or After" Retention: Calculates the percentage of users who come back on a specific time unit or any time after that. For example, "Day 5 retention" includes users who returned on day 5 or any day after. This gives a better sense of how long you are holding on to your users in an absolute sense and is the default calculation in Mixpanel’s retention report. It’s especially useful when you care about users eventually returning, not necessarily in a specific time window.Summary: - "On" = user must return on the exact interval (e.g., exactly day 5). - "On or After" = user can return on the interval or any time after (e.g., day 5 or later).See Retention Criteria documentation for more details.
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 build a chart that calculates the number of times my product appeared in search
Let me check the knowledge base for you again. One moment! 📚
To build a chart in Mixpanel that calculates the number of times your product appeared in search, you need to track an event such as "Product Appeared in Search" (or a similar event name) whenever your product is shown in search results. Once this event is being tracked, follow these steps: 1. Go to the Insights report in Mixpanel. 2. Select the event that represents your product appearing in search (e.g., "Product Appeared in Search"). 3. Set the measurement to "Total Events" to count the total number of times this event occurred. 4. Adjust the date range as needed to analyze the desired time period. 5. (Optional) Add breakdowns by relevant properties (e.g., product name, search term) to see more detailed insights.This will give you a chart showing how many times your product appeared in search results over the selected period Docs / Reports / Insights.If you have not yet set up this event, you will need to implement event tracking for when your product appears in search results before you can build this report.
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 build a report that answers a question how often a product is used in comparison use event - compare products
Let me check the knowledge base for you again. One moment! 📚
To build a report in Mixpanel that answers how often a product is used in comparison, using the event "compare products", follow these steps: 1. Go to the Insights report in Mixpanel. 2. Select the "compare products" event as your metric. 3. Set the measurement to "Total Events" or "Unique Users," depending on whether you want to see the total number of times the comparison occurred or the number of unique users who performed the comparison. 4. Add a breakdown by the property that identifies the product (e.g., "Product Name" or "Product ID") to see how often each product is used in comparisons. 5. (Optional) Change the visualization to a bar chart or line chart to easily compare usage across products or over time.This setup will show you, for each product, how often it is included in the "compare products" event, allowing you to compare product usage in the context of comparisons Docs / Reports / Insights: Visualize trends and compositions within your data.If you want to see the percentage share of each product in comparisons, you can use the "Percentage of Overall" comparison option in supported visualizations like bar or line charts Comparison: Time, Baseline and Overall.
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 build a report that calculates the total number of purchases. i break down by a property Purchase list (data type: string) --> Product name. does that mean that the report shows me how many times each specific product was purchsed?
Let me check the knowledge base for you again. One moment! 📚
If you build a report that calculates the total number of purchases and break it down by the property "Purchase list" (data type: string) → Product name, the report will show you how many times each specific product was purchased, if the "Purchase list" property contains the product name as a value for each purchase event.However, according to Mixpanel documentation, for scenarios where a purchase can include multiple products, it is recommended to use a list property (not a string) to represent the list of product names or IDs. When you break down by a list property, Mixpanel evaluates each item in the list individually and counts the number of events where each product appears, giving you an accurate count of how many times each product was purchased—even if multiple products are bought in a single purchase event Docs / Data-structure / Property-reference / Supported Properties Data Type / List Property Support.If "Purchase list" is a string (not a list), and it only contains a single product name per event, then the breakdown will show the count for each product. But if the string contains multiple product names (e.g., "Product A, Product B"), the breakdown may not accurately reflect individual product purchases.Summary: - If "Purchase list" is a string with a single product per event, the breakdown shows how many times each product was purchased. - If "Purchase list" is a string with multiple products per event, the breakdown may not be accurate. - For accurate per-product purchase counts when multiple products can be bought in one event, use a list property for "Purchase list" and break down by that property Docs / Data-structure / Property-reference / Supported Properties Data Type / List Property Support.
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.