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.
Reset your query at any time by clicking the three dots on the top right of the report and selecting Reset query from the drop-down.
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.
Explore Events & Cohorts
Click on Your Top Events and select the event you want to query from the drop-down list.
You can view up to 1,500 events in the events drop-down list.
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 search bar. You must know the exact name of the event you want to select because event names are case sensitive.
You can create a custom event off of an event by clicking the edit pencil icon. 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.
Next, select the Data Function you want to use to calculate results by clicking on Total and selecting an option from the drop-down list.
Filter this event by clicking the … icon and selecting Add filter from the drop-down list. Choose an event or user profile property, or a billing account 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.
Breakdown this event further by clicking the … icon, selecting Add aggregation, then selecting an event property, such as “Amount”. This will add up the value of this property for all of the times this event happened in this time range. All aggregate properties are typecast to numeric properties in order to calculate the sum of that property. For example, aggregate the property “Amount” under the event “Process Payment” to analyze revenue.
To duplicate or delete any events or properties in your query, select the … icon and choose Duplicate or Delete from the drop-down list.
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 list 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, billing account, or cohort.
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, billing account, or cohort.
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.
Custom events can be broken down 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.
Save a Report
To save a new report click on the Unsaved title at the top and enter a name at the top of the query builder, then click Save.