Build an Insights Report

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 inline action menu on the top right of the report and selecting Reset Query from the drop-down.

Build1.png

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. 

Build2.gif

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.

Select Events and Filters

Select an event to query from the drop-down. The default is “Your Top Events”.

Build3.png

You can view up to 1,500 events in the events drop-down. 

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. 

Build4.gif

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.

Build5.png

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.

Build6.png

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.

Build7.png

Data Function Calculation

Data Functions in Insights have been recently updated and are in a Beta state. Changes to these functions may still occur.

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.

Build8.png

The following functions have additional aggregation options which you will be prompted to select:

  • Events:
    • Total per user
  • Event property value per user:
    • Sum
    • Average
    • Distinct value count
    • Minimum 
    • Maximum

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.

Build9.png

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.

Build10.gif

Explore User Profiles

Data Functions in Insights have been recently updated and are in a Beta state. Changes to these functions may still occur.

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.

Build11.png

If the data function you select calculates based on profile property value, you will be prompted to select a user profile property.

Build12.gif

Filter these users by clicking the inline action menu and selecting Add filter from the drop-down. Choose a user profile property, group profile property, or cohort to filter the event by.

Build13.png

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.

Build14.png

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.

Build15.png

Formulas

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

Note

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:

Build16.png

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. 

Build17.png

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.

11.gif

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.

12.gif

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.

Build18.png

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.

Build19.png

You can breakdown your results by the "Date" event property.

Build20.png

You can breakdown by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week. 

Build21.png

If you are analyzing any custom events, you can breakdown by the property "Event Name".

Build22.png

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. 

Build23.gif

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.

Annotation_2019-11-26_08165312.png

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.

Screen_Shot_2020-01-10_at_2.17.01_PM.png

 

Did this answer your question?

Comments

0 comments

Article is closed for comments.