Reports

Overview

Reports are the basic unit of performing an analysis in Mixpanel. A report can be saved to a Board, and a board can contain many reports. Each report consists of one or more metric displayed using a visualization.

Mixpanel has four core reports.

This article focuses on the common concepts across the core reports.

Metrics

A metric is a some sort of measurement on a behavior. An example of a metric is "Unique Users" doing "Sign up", which is the measurement of unique users, on the behavior of "Sign up".

Behaviors

A behavior is an event or a sequence of events performed within some criteria. A behavior can be something simple like a single event, or it can be something more complex like doing a multi step funnel.

Measurements

A measurement is a selection on how to summarize behaviors. Depending on the behavior, certain measurements may be not be possible. For example, for a single event, you cannot measure the conversion rate of it. Some examples of measurements are: total events, unique users, total sessions, conversion rate, retention rate and aggregate property. The measurement is chosen at the bottom left area of the metric.

Visualizations

In the top right, you can change the type of visualization for your report. The options available will depend on the type of report that you started with. In this case, we switched to a bar view, allowing us to see the total number of "Log In" across the entire time range, allowing us a summarized view that is easily scanned.

Filters

Filters are used to narrow events or behaviors that qualify for analysis. For example, you may want to only consider "Sign Up" events that came from Android. In this case you would you be filtering the "Sign Up" event to only include the "Sign Up" events where the property "Device" is equal to "Android".

Global Filters

A global filter applies to the entire report. by properties or cohorts by clicking the Filter button. This will filter the results of the entire report to show only data with that property or cohort.

Inline Filters

An inline filter applies to one particular event in the report.

Add a filter to your query by clicking on the … icon beside an event, profile, cohort, or step.

Then, select a property from the drop down list that appears and specify which values to filter.

In Funnels, filtering a step by a particular property will limit the data you see in the funnel to events with that property value.

You can choose multiple property filters for each item in your query.

You can select whether you would like the query to match any of these filters, or all of the filters by clicking on and/or beside the filters.

First Time Ever Filter

Sometimes, you might want to filter an event to only the first time that it's performed by a user. This helps answer the following questions:

• How many users sign up or perform another key event for the first time each week?
• Which referrers do most first time users come from?
• How quickly do users make a purchase after their first time engaging with the app?
• How well do users retain after performing a key event for the first time?
• What events do users perform before and after doing their first purchase?

You can do this by adding a First Time Filter to any event in Mixpanel. This filters the event down to only the first instance of the event in a user's entire history. (not the first time they tracked the event inside the report date range)

Mixpanel computes this on-the-fly by scanning each user's history to determine if this was the first instance of the event performed by the user, based on timestamp.

Breakdowns

Breakdown groups the results of your metrics in Insights, Funnels, Flows, or Retention reports by a property or cohort, allowing you to examine which properties or cohorts have a significant impact on your query.

This feature is useful for determining if a group factor, such as browser type, is having an impact on the way users interact with your product. Breakdown will display counts, such as the number of events performed or the conversion rates with that property value.

Select the Breakdown button, and select the property or cohort you want to breakdown your results by.

For cohorts, you will be shown groups of users both in and not in the cohort in your results.

It is only possible to either group by properties or group by cohorts, but not both.

View Users

View Users is a streamlined process for exploring the users contributing to a specific metric or point on a chart. By interacting with the chart, you can view a group of users experiencing friction or dig deep into which users are driving feature adoption.

View Users can help you:

• See the users contributing to any metric and view their recent activities & properties.
• Save these users as a cohort.
• Export these users to a CSV file.

Query Builder Features

Events Menu

This is the menu that appears under "Add Metric" or "Select Step".

By default, the event menu shows all events, except for hidden events.

If you organize your events using tags in Lexicon, the tags will show up as filtering options in the event menu. When you select a tag, a list of events that share the same tag appears:

View Sample Events

You can hover over any event and in the context panel, you now have the ability to "View Sample Events", which redirects you to the Events page with the 100 most recent samples of that hovered event: You can see a few samples of an event to help you decide whether that's the right event you want for your analysis or which property you should use for filters/breakdowns.

Rename an Event within a Report

Click on the "three dots" icon beside an event and click Rename to rename it. This will only affect the current report, and will not change the event's name in other reports.

Properties Menu

This menu appears when adding a filter, an inline filter on an event or breakdown.

By default, the menu shows "all properties". This includes event properties, profile properties, group properties, lookup properties, cohorts.

You can select the following filtering options to show a subset of the properties in the menu:

• Select "event properties" to show only the Event properties.

• Select "user properties" to show only the Profile properties.

• Select "cohorts" to show only the Cohorts.

• If you set up Group Analytics, the Group keys will show up individually under their display names. You can select any Group key to show only the Group properties relevant to the selected Group key:

  

Understanding Prefixes in the Menu

The events and properties in the menu are prefixed to provide additional context about the properties' type. They will be removed when additional context is not needed.

• Event properties are not prefixed (except in User report's menu:

  

• User properties are prefixed by "User": "User" prefix is removed in User report's menu or once you filter the menu by "user properties".

  

• Cohorts are prefixed by "In Cohort": "In Cohort" prefix is removed once you filter the menu by "cohorts".

  

• Group profile properties are prefixed by the Group key display name: Group key prefix is removed once you filter the menu by a specific Group key.

  

• Lookup properties are prefixed by the mapped property. Let's say "Timezone" is mapped to a Lookup Table that contains "UTC Offset" and "UTC Offset (DST)", these lookup properties will be prefixed by "Timezone"

  

• Lookup properties can also be prefixed by both "User" and the mapped property to indicate that they are lookup properties of a user property

  

Typecasting

Mixpanel allows you to force Properties into another data type (opens in a new tab) by using the "Data Type" option in the overflow menu for property filters and breakdowns.

Typecasting is helpful when one of your properties is a number but is sent to Mixpanel as a string and you want to see histogram data for that property. Or if one of your properties is a unix timestamp and got sent as a number, and you want it to be treated as a date Property instead.

Duplicating Query Elements

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.

Undo and Redo

The undo/redo keyboard shortcuts allow for fast adjustments to your analysis. Cmd + Z to undo; Cmd + Shift + Z to redo. Change filters, date ranges, line vs bar chart, and go back in one second to compare before and after, or fix the view.

• Navigate different report versions: add a new event, filter or breakdown and undo that change with Cmd + Z . This makes iterating between different versions of your report quick and easy.
• Compare visualizations: go from a bar chart, to a line chart, to a pie chart and all the way back while only using the undo / redo keyboard shortcuts.

Date and Time Selector

Determine the time range of a query by clicking on the date range selector. The date range selector is common across all reports.

All dates and times in Mixpanel reflect the project timezone. The default on most reports is “Last 30 days” (displayed as "30D"), but there are a variety of pre-set options, as well as the option to select a custom date range.

For these date ranges, the output shows results from the last complete 30 days, plus any results from the current incomplete day.

Select a Date Range

Selecting Custom on the date range selector opens up some additional options, "Last", "Fixed" and "Since".

Last

“In the last” allows you to select a rolling time range similar to the default “last 30 days” but you have the flexibility to choose the time value and scale, either days, weeks, or months.

If you need to, you can click on the + Ending button and shift back the desired time window by a selected amount of days. So for instance in the example below, we are still looking at a 2-week window that is shifted by 7 days back. This is a rolling date range and if this report is saved as a bookmark or added to a dashboard the actual dates will continue to update to show this relative time period vs. Today.

Fixed

“Fixed” allows you to select two dates to query between or a select particular day to query by entering the same start & end date. If you save this report as a bookmark or add it to the dashboard, the date range selection will always persist.

Since

“Since” allows you to select a specific date to query for all data since that start date.

To Date

"To Date" allows you select a date rnge that will update dynamically to fit the current internval. You can choose Week to Date, Month to Date, Quarter to Date and Year to Date. When the boundary of interval is passed, the date range will automatically update to include only the current interval. For example, if "Month to Date" was selected, and the date was February 27, the date range would include Feb 1 - Feb 27. The next week, after the month boundary has passed the date range would include Mar 1 - Mar 4. To Date respects start of week and start of quarter settings under project settings.

Line Chart Time Selector

Line Chart Intervals You can also choose how Mixpanel buckets the time range in Insights, Funnel Trends and Retention Trend reports (granularity may vary). To view a range in hours, you can select Hour as the view:

Line Chart Zoom To zoom in, click on the graph and drag to highlight a specific window of time in your report. Click Reset zoom to return to the previous view.

Comparisons

Comparisons allow you to compare metrics, or broken down segments of metrics against each other. Depending on the type of comparison type, you are also able see the lift of a segment or metric against another.

Time Period Comparison

Compare to past allows for comparing a metric against itself on a different time period. You are able to compare against the previous day, week, month, quarter and year. You are also able choose a custom time comparison window.

Note that if a data point for a previous year falls on a weekend, the data point is automatically moved to the next Monday to give a clearer picture of the data change from one year to the next.

Hover over a segment to see the details on the time-period selected.

By default, Mixpanel will visualize the values for both time periods. If you wish to see the lift of the current time period against the past time period, you can select the "Percent Change over Baseline" option to see the lift of your metric over time.

Value Comparison

Compare to segment allows you to set a property value as a baseline and see how every other property compares.

Compare to overall allows you compare each segment value and see what proportion it makes of the overall value.

Downloading Reports

You can download reports in four formats:

• CSV
• PNG
• PDF
• Formatted API

To download Insights, Funnels, and Retention reports, click the "..." icon on the upper right corner of each report. Note the limitations on downloads.

Limits and Ordering

UI

In order to keep the interactive analysis experience snappy for projects of all sizes, we imposed limits on how many segments are returned back to the report (visible limit) and how many segments can be selected at a time for visualization (selection limit), as well as the number of segments selected by default (default selection).

Here's the breakdown per report + visualization type:

Hover over your table of visible segments to check if your report has reached the segmentation limit.

Report Exports

CSV - CSV export supports up to 50,000 breakdown segments. API - The Query API supports up to 10,000 breakdown segments. PNG and PDF - PNG and PDF export supports up to 30 segments in the Insights table, Insights bar, Retention table, and Retention line; and up to 12 segments for the Insights line.

Top Segments logic

The way we pick the top segments differs according to the type of query. We choose the top segments based on the value shown in the second column.

Saving to a Board

When you are satisfied with the analysis, and decide that this is something that you are likely to revisit, Mixpanel recommends that you save the report to a Board. You can do this by pressing "Save" in the top right and selecting the Board you would like to save to, or creating a new Board. Sharing and permissions are set at the Board level. Learn more about Sharing and Permissions.