See us at ProductCon in SF on Oct. 8th! Check out #03_resources-and-events channel for more info.
I'm curious about the criteria for issuing new sessions in the mix panel. During the session's duration, even if the URL accessed by the user changes and the landing page accessed changes, will the session remain the same, or will it be differentiated and calculated as another session? And does it affect the calculation of the session even if it is moved through various internal links on the website after accessing the web page?
Mixpanel’s standard Insights reports do not display the standard deviation as a built-in aggregation or measurement option in the UI. The available aggregations for property values include average, median, percentiles (p25, p75, p90, p99), minimum, and maximum, but standard deviation is not listed among them Aggregate Property Additional Aggregation Option Examples.However, if you need to analyze the standard deviation, you can use JQL (JavaScript Query Language), which is Mixpanel’s advanced query tool. JQL provides a built-in reducer called mixpanel.reducer.numeric_summary()
that returns count, sum, sum of squares, average, and standard deviation for a collection of numeric values. Here’s an example from the knowledge sources: LBKSfunction main() { return Events({ from_date: "2015-10-01", to_date: "2015-10-02", event_selectors: [{event: "pageview"}], }) .reduce(mixpanel.reducer.numeric_summary('properties.load_time_ms')); }LBKS
This will return an object including the standard deviation for the specified property JQL Builtins.In summary:
- Standard deviation is not available in standard Insights UI reports.
- You can calculate standard deviation using JQL with mixpanel.reducer.numeric_summary()
.This approach allows you to better understand the spread and variability in your data when averages alone are misleading.
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! 📚
There are values that are difficult to know from the average value. The deviation between the maximum and minimum values is so severe that I think I need to check the standard deviation, but does the mix panel provide information about this standard deviation? If not, how can I overcome the above situation? kapa.ai
Mixpanel projects are fully isolated from each other—there is no sharing of users or events between projects. Each project is a separate container for analytics data, and you cannot query or analyze data (users or events) across multiple projects within Mixpanel. All data, including events and user profiles, is stored and managed at the project level, and cross-project analysis is not supported Data Model: How Mixpanel data is organized.If you need to consolidate data from multiple sources, you should send all relevant data to a single project, or consider merging projects if cross-analysis is required Managing Projects.
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! 📚
I wonder if there is no sharing of users and events between projects at all. kapa.ai
Yes, you can bring Insights reports (and other reports) from one project to another in your account by using the Move Board feature. Mixpanel allows you to duplicate a Board (which contains your Insights reports) and move it to a different project. This process preserves the reports, filters, and text annotations on the Board. However, before moving, ensure that any custom events, cohorts, or properties used in the reports are also recreated in the destination project, as these do not move automatically with the Board. You may also need to replicate any specific sharing permissions for the moved Board Move Boards: Reuse Boards across different projects Migrating Reports and Non-Data Entities.
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! 📚
Can I bring the insights items from other projects in my account? kapa.ai
I'm sorry, but according to the knowledge sources, Mixpanel does not support defining display names for the sub-items (elements or keys) within list-type properties in user-defined properties. While you can set display names for top-level event and profile properties using Lexicon, the property names (keys) inside objects or elements within lists cannot have display names assigned in the Mixpanel UI.This limitation is explicitly mentioned for both list of objects and object properties: > Property Names (ie keys) within an object are not supported in Lexicon.
— Supported Properties Data Type: List of Objects> Mainly supported in core reports (i.e. Insights, Funnels, Flows, Retention, Users / Cohorts, Events) as filters and breakdowns. Property Names (ie keys) within an object are not supported in Lexicon. — Supported Properties Data Type: OverviewFor lookup tables, the property names are derived from the CSV header and also cannot be renamed using Lexicon display names Use a Lookup Table.In summary:
You can define display names for top-level properties, but not for sub-items or keys within lists or objects in user-defined 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.
Let me check the knowledge base for you again. One moment! 📚
Is there any way to define the display name for the data sub-items that are pushed into the list type in the user-defined properties? kapa.ai
Yes, you can use the /import API on the Growth pricing plan. The /import API is available for all standard Mixpanel plans, including Growth, and is specifically designed for importing historical events older than 5 days, which the /track API does not support Mixpanel SDKs: Node.js Mixpanel SDKs: Android.Restrictions and Differences Compared to /track API:Summary: You can use the /import API on the Growth plan to backfill historical data, and the main differences are in authentication, event age, and request format. The data limits and rate limits are essentially the same as the /track API.If you need to backfill a large amount of data, consider batching and following best practices for rate limiting and error handling Quickstart: Track 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.
Let me check the knowledge base for you again. One moment! 📚
Then, can I use the import api for the growth pricing plan? And I wonder if there are any restrictions on the data that can be written compared to the track api. kapa.ai