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 three dots on the top right of the report and selecting Reset from the drop-down.

InsightsBuild1.png

Choose to explore either Events & Cohorts or Profiles. Events & Cohorts allows you to examine user behaviors, while Profiles allows you to examine user demographics.

InsightsBuild2.png

Explore Events & Cohorts

Click on Your Top Events and select the event you want to query from the drop-down list.

InsightsBuild3.png

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. 

old_event1_event.gif

You can easily 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 event or Add cohort buttons.

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.

InsightsBuild4.png

Filter this event by clicking the … icon and selecting Filter from the drop-down list. Choose an event or user property, or a billing account to filter the event by. You can enter multiple properties, separated by commas.

InsightsBuild5.gif

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.

Sep-30-2019_13-42-53.gif

To duplicate or delete any events or properties in your query, select the … icon and choose Duplicate or Delete from the drop-down list.

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.

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:

InsightsBuild8.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. 

Screen_Shot_2019-11-04_at_2.29.46_PM.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.

Oct-04-2019_11-49-15.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 list and check the box beside Rolling range.

InsightsBuild9.gif

Filter & Breakdown Results

To filter the results of your Insights query click the Filter button below the query builder and select an event property, user property, billing account, or cohort.

InsightsBuild10.png

To breakdown your results click the Breakdown button and select an event property, user property, billing account, or cohort. 

InsightsBuild11.png

Custom events can be broken down by the property "Event Name".

Screen_Shot_2019-09-30_at_4.38.04_PM.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. 

gif_2.gif

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 new.

InsightsBuild12.png

Simply click Save to save a pre-existing report.

Is this article helpful?

Comments

0 comments

Article is closed for comments.