Mixpanel's Insights allows you to analyze your user data as a current snapshot or as a trend over time. This article explains how to build an Insights report. Learn about Insights report basics here. Learn about how to interpret an Insights report here.
Reset your query at any time by selecting the x button to the right.
Select the event you want to query from the drop-down list.
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 breakdown by cohorts.
Under Breakdown, select “Date” under events to select a date range to break down your results by.
Custom events can be broken down by "Event Name".
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. You can enter multiple properties at once, separated by commas.
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.
Integer properties are broken into buckets where the beginning of the range is inclusive and the end of the range is exclusive. For example, the image below shows that bucket 1-124 includes integers greater than or equal to 1 and less than 124.
Rolling Date Ranges
When selecting the date range for your report, it is possible to use a rolling date range. This means that the dates will adjust relative to the current day. This rolling range can be up to 90 days.
Click Select a date range and choose Between from the drop down list.
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, pie, or table graph. To learn more about these different visualization tools, click here.
Comparisons can be analyzed further by using Formulas, as described below.
Use Formulas to make calculations using simple arithmetic operators.
Mixpanel supports the following operators:
- + : Add
- - : Subtract
- * : Multiply
- / : Divide
- () : Use parentheses to influence the order of operations
Dig deeper and break down the formula by a property to see how your calculation compares across different segments. Similarly, apply a filter to a formula to narrow in on a specific segment of your data.
Adding a Formula
Click the Add Formula button. Each event in the query shows a letter next to it, which indicates its variable name. Use these letters in combination with the operators to calculate a more advanced query. For example, you can use the DAU, WAU, and MAU functions in Formulas to calculate the stickiness of your product:
Enter a name for the formula (optional), and click Apply Formula to see the formula output.
You can also use numbers as constants in a formula. Multiply a ratio by 100 to display as a percentage, for example. Divide a property value tracked in seconds by 3,600 to display the value in hours.
Save a Report
To save your report enter a name at the top of the query builder and click Save.