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?