Insights allows you to analyze your user data through segmentation, charts, graphs, and formulas. By default, Insights will show you the top events logged in Mixpanel in the last 96 hours. You can choose to focus on a specific event, specific properties associated with that event, compare multiple events, or change the date range.
There are functionality differences between Insights and the Segmentation report that allow for more robust querying with Insights. Insights removes limitations around data exploration by allowing you to keep choices (i.e. choosing to use breakdown or compare) independent of one another.
Creating Insights Reports
Select the event you want to get insight into from the drop-down list. You can choose to filter that event by a particular property by clicking on the Properties button next to the event name.
Next, you can choose to breakdown this event further. Click the + button and select Breakdown, then select an event or people property, such as City. This will add up the value of this property for all of the times this event happened in this time range.
You can also compare multiple events. Select Compare from this drop-down, which is described in detail below.
Click the + Filter button and select a property or a cohort to add more filters to the report.
It is also possible to add a filter to the report by clicking on the x beside any property in the chart below.
For more information on the difference between Breakdown and Filters, click here.
Select between eight different ways to calculate user numbers by clicking on Show Total above the event and selecting from the drop-down list.
- Total: The total number of users meeting your criteria.
- Unique: The number of unique users meeting your criteria.
- Average: The average number of users meeting your criteria.
- Median: The middle number of users meeting your criteria.
- Min: The minimum number of users meeting your criteria.
- Max: The maximum number of users meeting your criteria.
- P90: The 90th percentile of users meeting your criteria.
- P99: The 99th percentile of users meeting your criteria.
To compare the data from this event to other events select Compare from the drop-down and select an event you wish to compare to. Click the + button to select multiple comparison events.
The results of each of these events will be compared side by side in the graph below as a bar, line, or table graph. To learn more about these different visualization tools, click here.
Comparisons can be analyzed further by using Formulas, as described below.
Formulas can be used to make calculations within Insights. Calculate the difference between two compared events by using subtraction, add two events together, or apply operators to a single event (event A/100 or event A*2).
The following operators are supported:
- + : Add
- - : Subtract
- * : Multiply
- / : Divide
- () : Enclose parts of formulas within parentheses.
Note: You can group and filter formulas like any event in Insights.
Click the Add Formula button. Each event in the filters above will now show a letter next to it which indicates its variable name. These letters can now be applied as variables in a formula. For example, if you wanted to know how many more people played a game than made an in-app purchase, create a formula that calculates event B - event C:
Enter a name for the formula (this is optional, but can help for clarity to other users), and click Apply Formula to see the results.
The bar or table graphs are the easiest way to see the precise answer to your formula because you can see the resulting number on the line, while the line graph will show how that number changed over the selected date range. Hover over a section of the line to see the number result for that time period.
You can add multiple formulas to compare the numbers from each by clicking Add Formula. The results will be displayed side by side, as seen below:
When you name an Insights report, it will automatically be added to your saved reports when you select Save next to the name.
You can access your saved reports by selecting the Saved Reports icon.
From there, you have the option to view any of the saved reports of your team members or a list of your own saved reports.
Plan Type Limits
- Free: Up to 5 saved reports
- Startup: Unlimited saved reports
- Enterprise: Unlimited saved reports
See our Pricing Page for more details.
If you have saved an Insights report and would like to create a new one, select the Reset icon.