Insights Overview

Insights allows you to analyze your user data through segmentation, charts, graphs, and formulas. By default, Insights will show you the top events logged in Mixpanel in the last 30 days. You can choose to focus on a specific event, specific properties associated with that event, compare multiple events, or change the date range.

Insights removes limitations around data exploration by allowing you to keep choices (i.e. choosing to use breakdown or compare) independent of one another.

Creating Insights Reports

Select the event you want to get insight into from the drop-down list. You can choose to filter that event by a particular property by clicking on the Properties button next to the event name.

InsightsSegment.png

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.

InsightsBreakdown.png

Under Breakdown, select Date under events to select a date range to break down your results by.

Jul-03-2019_11-43-09.gif

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.

It is also possible to add a filter to the report by clicking on the x beside any property in the chart below.

InsightsFilterTrick1.png

InsightsFilterTrick2.png

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.

Screen_Shot_2019-07-01_at_11.58.57_AM.png

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.

InsightsRollingDateRange.gif

Functions

Click on TOTAL above the event selector to access the Functions menu. The Functions menu offers multiple ways to query your data:

  • Total: The total number of selected events performed in a given time range.
  • Unique: Count of unique users (based on the unique identifier associated with your event data) that performed the selected event.
  • Average: The average number of times that a user performed the selected event in a given time range.
  • Median: The median number of times that a user performed the selected event in a given time range.
  • Min: The lowest number of times that a user performed the selected event in a given time range.
  • Max: The highest number of times that a user performed the selected event in a given time range.
  • DAU:  Abbreviation for Daily Active Users, a key performance indicator commonly used in behavioral analytics. The number of unique users in the previous day (24-hour) period that have performed the selected event.
  • WAU: Abbreviation for Weekly Active Users. The number of unique users in the previous week (7-day) period that have performed the selected event.
  • MAU: Abbreviation for Monthly Active Users. The number of unique users in the previous month (30-day) period that have performed the selected event.

Note on DAU, WAU, and MAU calculations

If you select the DAU, WAU, or MAU function for a date range that includes the current day, the query will take the end of the current day as the end of the query’s time segment (even though it’s in the future). For example, today is April 25th, and it’s 4:22 PM. If you make a query to show WAU and you select “current day” as your date range, the query will return the count of unique users between April 18 at 12:00:00 AM and April 25 at 11:59:59.

DAU, WAU, and MAU functions are currently in BETA for all users and are subject to change.

If you choose to query a numeric property, you can access several functions to calculate different insights. Click on Show Total and select a function from the drop-down list:

  • Total: The sum of the numeric property value.
  • Average: The average of the numeric property values.
  • Median: Median value of the selected numeric property.
  • Min: The lowest numeric property value.
  • Max: The highest numeric property value.
  • P90: The 90th percentile of the property values.
  • P99: The 99th percentile of the property values.

Comparing Events

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.

InsightsCompare.png

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.

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:

xau-formula.gif

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 Reports

When you name an Insights report, it will automatically be added to your saved reports when you select Save next to the name.

Screen_Shot_2018-09-11_at_11.40.23_AM.png

You can access your saved reports by selecting the Saved Reports icon.

Screen_Shot_2018-09-11_at_11.41.59_AM.png

From there, you have the option to view any of the saved reports of your team members or a list of your own saved reports.

Screen_Shot_2018-09-11_at_11.44.01_AM.png

  Plan Type Limits

  • Free: Up to 5 saved reports
  • Startup: Unlimited saved reports
  • Enterprise: Unlimited saved reports

See our Pricing Page for more details.

Reset Query

If you have saved an Insights report and would like to create a new one, select the Reset icon.

Screen_Shot_2018-09-11_at_11.44.37_AM.png

Is this article helpful?
25 out of 38 found this helpful

Comments

0 comments

Please sign in to leave a comment.