Mixpanel's Insights report 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.
Here is the most recent update made to the Insights report:
Choose to explore either Events & Cohorts or Profiles. Events & Cohorts allows you to examine user behaviors, while Profiles allows you access profile data and visualize your users with filters and breakdowns based on their profile properties. When exploring Profiles you are always analyzing all user profiles.
Explore Events & Cohorts
Explore your events and cohorts by selecting the event(s) you would like to analyze, a data function to calculate by, and adding filters or breakdowns.
Click Create Custom Event from the bottom of the events drop-down to create a custom event. Learn more about building custom events here.
Analyze session metrics by selecting "Session Start" or "Session End" from the events list. Learn more about using Sessions in Insights here.
Add more events or cohorts to your query by clicking the Add button.
Filter this event by clicking the inline action menu and selecting Add filter from the drop-down. Choose an event property, user profile property, group profile property, or cohort to filter the event by.
You can select whether you would like your query to match any or all of the filters by clicking on and/or beside the filters.
To duplicate any events or properties in your query, select the inline action menu and choose Duplicate. Delete any events or properties by clicking the trash icon.
Data Function Calculation
Select the Data Function you want to use to calculate results by clicking on Total and selecting an option from the drop-down. You can calculate based on events, users, event property value, event property value per user, and sessions.
The following functions have additional aggregation options which you will be prompted to select:
- Total per user
- Aggregate Properties
- Distinct count
- Percentiles (P25,P75,P90,P99)
- Count Users
- Daily Active Users (DAU)
- Weekly Active Users (WAU)
- Monthly Active Users (MAU)
- Event property value per user
- Distinct value count
These functions provide additional aggregation functions because they are “per user” calculations. “Per user” calculations first calculate the value per user, which is an unhelpful query in its raw form, but becomes useful when you perform an aggregation on that calculation.
Selecting any of these functions gives you the option to choose different ways to aggregate this data. The default aggregation is Average, which you can click on to select a different option.
If the data function you select calculates based on property (“Event Property Values” or “Event Property Values Per User”), you will be prompted to select an event property.
Explore User Profiles
Select the Data Function you want to use to calculate results by clicking on Total and selecting an option from the drop-down. You can calculate based on users or profile property value.
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.
Click the 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.
For example, you can calculate the ratio of DAU to MAU using a formula. Build an Insights report with event A as "App Session" and select MAU. Select "App Session" with DAU for event B. Apply the formula B/A to show the ratio of DAU to MAU in the report.
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.
Date and Time Selector
Click the Last 30 Days button below the query builder and click Select a date range at the bottom of the list.
To view a range in hours, select a 1 day range and then zoom in on a line in the chart to get the values by hour. To zoom in, click on the graph and drag to highlight a specific window of time. Click Reset zoom to return to the previous view.
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 the Last 30 Days button below the query builder and click Select a date range at the bottom of the list. Choose Between from the drop-down and check the box beside Rolling range.
Filter & Breakdown Results
To filter the results of your Insights query click the Filter button and select an event property, user profile property, group profile property, or cohort to filter the event or profile by.
While there is no and/or option for global filters, this Community post details some options to achieve the same results.
To breakdown your results click the Breakdown button and select an event property, user profile property, group profile property, or cohort to filter the event by.
You can breakdown your results by the "Date" event property.
You can breakdown by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week.
If you are analyzing any custom events, you can breakdown by the property "Event Name".
The events drop-down only shows events that were ingested within the last 30 days. To select events that have not been ingested in the last 30 days, type the name of the event in the Filter or Breakdown search bar. You must know the exact name of the event you want to select because event names are case sensitive.
To create a temporary cohort for the current report select Create cohort under the cohort filter or breakdown. A window will pop up where you can specify the restrictions of your cohort. Learn more about building a cohort here.
When breaking down/segmenting by a numeric property, Mixpanel decides what intervals the values get grouped into, while you always had the option to customize these ranges/buckets with Custom Properties, it required a bit of effort to setup, so we've added support to define intervals without any formulas:
You can now click a segment (bar or line) in an Insights report to see the list of users that underlie that data point. This helps see a representative sample of users from any analysis, so you can drill into anomalies or simply get to know your users. You can also save this user list as a cohort to either export or use for message targeting.
Please note: "View users" are currently unsupported on visualizations other than bar and line.