Building Your First Report in Mixpanel

A report is the basic unit of performing an analysis in Mixpanel.

Mixpanel has several types of reports: Insights, Funnels, Flows, Retention and other advanced reports, each with their specialized use.

This article focuses on the flow of building a report, and learn about some of the common concepts across each report.

Building your First Report

We'll start in Insights, where we'll build an analysis to see how many log in events we get per day.

To start, navigate to the top left, and select "Insights" under "Reports".

Screen_Shot_2022-07-08_at_5.09.14_PM.png

You can also click here to reach insights directly on one of our demo projects (required being logged in).

Once the page is open, select "Add Metric" under the "Events & Cohorts" section and choose the "Log In" event.

Screen_Shot_2022-07-08_at_5.13.45_PM.png

Note that the event selection section is common across Insights, Funnels, Flows and Retention. Funnels and Retention require at least two events to be chosen, but the process of choosing events is common across all reports.

After selecting an event, you should have something similar to this

Screen_Shot_2022-07-08_at_5.18.10_PM.png

Mixpanel will default to a different visualization depending on what type of report you are building. In the case of Insights, we are now seeing a a trend of "Log In" events over the past 30 days.

Filters and Breakdowns

Oftentimes, it's not enough to just see an event. We want to investigate some property of the event so that we can dig deeper. The first common way of doing this is by doing a breakdown.

In the breakdown section, add a breakdown and select the property that you're interested in, in this case "Login Method".

Screen_Shot_2022-07-08_at_5.25.38_PM.png

Now we can see that most logins happened with "Manual Password" instead of through "Touch ID".

We can add more breakdowns, to further drill down on our data.

Screen_Shot_2022-07-11_at_3.02.05_PM.png

In this case, we've added another breakdown, by "Country", so we can see a trend of "Login" events drilled down by these 2 properties.

If we want to isolate certain segments, we can choose to filter.

This can be done by dragging one of the breakdowns to the filter section, or by simply adding a filter.

Screen_Shot_2022-07-08_at_5.30.49_PM.png

In this case, we were only interested in "Login Method" of "Manual Password", but we still wanted to drill in by "Country", so we now have a 30 day view of "Manual Password" "Log In"s, and we can see how each country performed.

Date Selection

A 30 day view is not necessarily the most meaningful, depending on the type of data and what type of trend we're looking at. This can be easily changed in the top middle, above the chart.

Screen_Shot_2022-07-08_at_5.34.10_PM.png

Simply select the date range that interests you and Mixpanel will perform the analysis over the appropriate range. There are presets that can be selected, but there is finer control under the "Custom" section. You can also choose how Mixpanel buckets the time range. In this case we're looking at the data grouped per week, over a 3 month period.

Changing Visualization

In the top right, you can change the type of visualization and analysis being performed. 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.

Screen_Shot_2022-07-11_at_3.07.02_PM.png

Saving to a Dashboard

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 dashboard. You can do this by pressing "Save" in the top right and selecting the dashboard you would like to save to, or creating a new dashboard.

Screen_Shot_2022-07-08_at_5.40.30_PM.png

Further Reading

Congratulations, you have now created and saved your first report in Mixpanel. There are still many more types of analysis that can be performed in Mixpanel, but the process of choosing events, using breakdowns to drill into your analysis, using filters to isolate a portion of your data, selecting the time range, and choosing the visualization are common flows across all Mixpanel reports.

Please reference these articles for further learning

Did this answer your question?

Comments

0 comments

Please sign in to leave a comment.