How can I export my people profiles into a CSV?

People profiles currently cannot be exported via the Mixpanel UI; however, you can easily export your people profiles either: Within Mixpanel using one simple query in JQL. In ...

How is retention calculated?

The retention calculation in Mixpanel is designed to create a normalized, actionable metric to assess user engagement over arbitrary periods of time. It is our implementation of what ...

How are funnels calculated?

Your customers must complete the steps you designate in your funnel in loose order. Loose order means that a customer can engage in other actions in between funnel ...

How does Mixpanel treat numbers?

There are lots of uses for sending numbers to Mixpanel, especially in Segmentation reports. Let's say you were instrumenting a music sharing site, and with every “song played” ...

What timezone does Mixpanel use, and how can I change it?

Mixpanel handles Event times and timezones as follows: Mixpanel records all Events assuming a UTC timezone at intake. Before writing the Event to Mixpanel data stores, Mixpanel converts ...

What is "Last Seen"?

“Last Seen” ($last_seen) is a reserved People property that records the date of the most recent update to a given People profile. This property is not automatically updated ...

Why are my events out of order in Live view or a user’s Activity Feed?

Events in Live view and in the Activity Feed may sometimes appear out of order (i.e., an event that occurs after another event is listed first); for example: ...

How can I track cohorts or custom groups of users?

Create specific groups of users, or cohorts, by making a Custom Event within Mixpanel. Custom Events allow you to define a group of users based on existing events ...

How do I track users if they are part of multiple organizations?

If your business has users who are part of multiple organizations, tracking them can be tricky, as you ideally want to include them in data about each organization, ...

Can I set up certain reports to be emailed to me on a regular basis or receive email alerts when certain events happen?

If you’re looking to access your data on-the-go when you’re not near your desktop or laptop, Mixpanel offers an iOS app as well as an Android app with ...

How are unique vs. total users calculated?

Mixpanel’s Segmentation and Insights reports allows you look at your data in terms of totals, uniques, and averages: The Formulas report allows you to use either totals or ...

How do I create a Mixpanel dashboard that shows me all of my reports side-by-side?

Mixpanel recently release Web Dashboards! For more information Web Dashboards, please see the following articles. What are Web Dashboards What do Growth, Marketing, Product, Project Dashboard and My ...

How do I measure effectiveness of my A/B tests?

There are two ways you can see detailed analytics on your A/B tests to determine their effectiveness on your users: Via the analytics button in the A/B Testing ...

How do I delete People Profiles from my project?

Some Mixpanel users find that they want to delete People Profiles if they’ve accidentally imported a batch of profiles incorrectly, they have an identity management issue that leads ...

Why is lifetime value in Revenue decreasing over time?

While it is true that lifetime value for any individual user can only go up, the lifetime value line chart in Revenue* looks at the average lifetime value ...

How can I export my survey results?

Mixpanel Mobile Surveys are deprecating in March 2017 and are no longer supported. The Surveys tab does not have a button where survey results may be exported to ...

How can I export my raw data from Mixpanel?

This article covers exporting data programmatically via Mixpanel’s API. Mixpanel API endpoints The first step to exporting your data from Mixpanel is choosing the API endpoint you need ...

How can I look at users in a Funnel who did Event A OR Event B?

Mixpanel Custom Events* allow you to combine several events into a single event so that you can create Funnels that measure the following: Step 1: Event A OR ...

Why can't I choose a certain time period to look at in Live View?

The default view in Live View will show up to the 200 latest Events sent into your Mixpanel project. When you apply an Event or Property filter, Mixpanel ...

What does $other represent when segmenting a Funnel?

When segmenting a Funnel by a Property, the top 200 property values will be shown in the table below the Funnel. All other segments will be grouped into ...

Why are some Events, Properties, or Property values missing from my dropdowns?

There are three reasons why you might not be seeing Event names, Property names, or Property values in your dropdowns that you had before: A member of your ...

Can I use Custom Events in JQL?

At this time, Custom Events cannot be used in JQL. In order to capture the data from a Custom Event in JQL, you will need to recreate those ...

How do I view numeric properties in Segmentation so that each bar is a single number not a range?

When segmenting by a numeric property, by default you will see groups or ranges of numbers in your report. Mixpanel is automatically grouping these property values together to ...

What does a First Time Retention report mean, and how does Mixpanel know that this is the first instance of the user firing the Event?

Mixpanel’s First Time Retention report allows you to select one Event as a cohortizing Event and another Event on which to calculate user retention. This report is useful ...

How do I see DAU and MAU in Mixpanel?

To track your daily active users (DAU) and/or monthly active users (MAU) with Mixpanel, the first step is defining an active user for your app or site. Define ...

How can I tell if a user was in the original or variant group of my A/B test?

In most reports, the quickest way to analyze Events and compare impacts based on which variant the user received is to use the Experiments Property. This Property is ...

What does “Anything” include in Retention reports?

In all three Retention reports (Recurring, First time, and Addiction) you have the option to select “Anything” from the Events dropdown: “Anything” includes: All of your Events, including ...

How can I get the Formulas report to display my ratio as a percent instead of a decimal?

When comparing Events in a Formulas* report, the x-axis will show decimals and not percentages. This is because not all Formulas produce percentages (depending on what Events you’re ...

Can I run multiple A/B tests at once, and can users be in multiple A/B tests?

While it is possible to run multiple A/B tests at once, a user cannot be in more than one concurrent A/B test. This is an intentional constraint put ...

Can users be included in multiple cohorts in Retention reports?

While users are counted only once within the People column of each cohort (based on distinct_id) in Retention reports, users can exist in multiple cohorts. This allows you ...

How can I add a picture to a person’s profile in Explore?

Photos in Explore are populated from a third-party API called Gravatar, which displays an avatar based on the email address of the People Profile. At this time, there ...

How do I analyze organic users vs. paid users?

Analyze your organic vs. paid users to understand their behavior in your product and the value of each. Knowing how paid users perform will guide you on which ...

How do I exclude bot activity from my data (web/JavaScript)?

By default, the following bots are filtered out by the Mixpanel JavaScript library: Yahoo! Slurp bingbot/2.0 Googlebot/2.1 Baiduspider/2.0 YandexBot/3.0 Any other bot hitting your site will affect your ...

How do I import revenue data?

If you’re on a Startup, Business, or Enterprise plan, leverage the Mixpanel Revenue report to track total revenue numbers as well as customer lifetime value and revenue per ...

How do I import users into Explore?

Mixpanel allows you to import users to add People Profiles in bulk via CSV. When imported correctly, future Events that user completes will be visible on his or ...

Can I delete annotations for US holidays or add annotations for my country's holidays?

At the this time, there's no way to remove the US Holidays from the list of annotations or choose a different country’s holidays. However, if you want to ...

How do I build segmentation expressions?

The easiest way to build Segmentation expressions is by looking at the requests within the standard Mixpanel Segmentation report. Find the on/where parameters for segmentation API requests: Open ...

Why are there fewer People Profiles in Explore than unique user counts in Segmentation?

Mixpanel’s Segmentation and Explore reports show different types of data. Segmentation displays Event data sent to Mixpanel using the mixpanel.track() operator, while the Explore report displays people data ...

How are segmented Retention reports calculated?

A powerful way to understand your Retention reports is to segment by Event Properties and People Properties to see how well you retain users with a specific Property ...

Why can't I filter the “Anything” Event in Retention?

Filtering your Retention report by Event or People Properties is only available once a particular Event has been selected. It’s not available for the "Anything" Event option as ...

What is the mp_page_view Event, and can I see the associated data?

The mp_page_view Event is a vestigial event that the Mixpanel JavaScript library used to send by default to capture all page views. However, Mixpanel disabled the automatic collection ...

How are rolling averages calculated?

Use rolling analysis to remove noise or spikes from data and smooth out trends over time. Mixpanel’s Segmentation report shows a linear analysis by default; change it to ...

Can I create optional steps in my Funnel report?

Mixpanel does not have a way to designate optional steps in the Funnel builder. However, there are two approaches that will allow you to analyze different, perhaps optional, ...

Why are iPhone applications reporting Operating System as either “iOS” or “iPhone OS?”

Mixpanel’s iOS library uses a standardized system value provided by Apple to define the Operating System property for end users. This value is determined like this: [[UIDevice currentDevice]systemName]; ...

What is happening to the Insight report?

We will be upgrading the Insight report on February 15th, 2017. Going forward, the report will be named Insights and will live above the Segmentation report in your ...

How can I see a preview of what my users on older versions of the Mixpanel SDKs will see for customized in-app notifications?

If you choose to create a backup theme to be sent to users who have not yet upgraded to the latest version of your app, you can see ...

Where can I find more information on Insights?

Insights is an upgraded version of the original Mixpanel report called Insight. It allows users to create complex queries to answer the deepest questions about their data. Insights ...

How is Insights different than Segmentation?

There are functionality differences between Insights and the Segmentation report that allow for more robust querying with Insights. Insights removes limitations around data exploration by allowing you to ...

What kind of visualization tools are available with Insights?

In addition to the stacked bar chart and stacked line chart, Insights has regular bar charts, line charts and a table view. You can switch between Absolute and ...

Can I save my Insights reports?

When you name a report, it will automatically be added to your saved reports when you select Save next to the name. You can access your saved reports ...

Can I export my Insights reports to a CSV?

If you have created an Insights report that you would like to export, you can select the download CSV button in the upper right hand corner of the ...

Who has access to Insights?

Everyone on your project has the ability to view the Insights reports. However, if permissions are enabled on your project, only the Owners, Admins, and Analysts can create ...

How many reports can I save in my Mixpanel project?

Any Insights reports you create and save will count towards the number of reports allotted based on your current engagement plan. To see which plan you are on, ...

After I have created and saved my report, how do I build a new one?

If you have saved an Insights report and would like to create a new one, select the reset query icon (small x) in the upper right hand corner ...

What is the difference between filter and groupBy in the Insights report?

Filtering by a property or properties in the Insights report allows you to select the criteria that you would like to be included in the report. Filters enable ...

What is Predict?

Predict tells you how likely your users are to convert before they do. Grades are given to users based on their previous behavior. All you need to do ...

What are Web Dashboards?

Web Dashboards provide a collective view into your most important reports on your desktop! They allow you to quickly get a sense of your product’s key metrics in ...

What do Growth, Marketing, Product, Project Dashboard, and My Dashboard mean in Dashboards?

Web Dashboards come with five default dashboards: My Dashboard: Private dashboard that is available only to you. Project Dashboard: Public dashboard that everyone in your project can view. ...

How does Signal display the results?

After the Signal report is generated, the results will immediately be displayed in a summary list-view and a detailed heat map. Summary view In the summary view, each ...

How does Mixpanel interpret the results in Signal?

“Opportunity” is Mixpanel’s proprietary calculation of how important a given correlation might be. Opportunity helps pare down results to understand causation by eliminating false positives and highlighting weak ...

What is Signal?

Signal, currently in a beta release, is a new product that helps users answer the questions “why do customers retain in my product?” and “which events are associated ...

Building a query with Signal

The Signal beta can be found under the Engagement Reports in your Mixpanel project. By default, Mixpanel will build a query to show how your top 50 (defined ...

What do “Top Events” include in Signal? Can I exclude specific events from “Top Events?”

Top Events includes the top 50 events (excluding custom events) by volume in your project. Signal can build a query using a specific event or the top 50 ...

Can I build a query in Signal with a group of events besides my “Top Events”?

Signal queries can be built using the Top Events in your project or on one event at a time. For more information on Top Events, please see What ...

What is the difference between “New Users” and “Any Users” in Signal?

“New Users” are defined as users who have completed their first event in your project in the designated time frame. “Any User” will find any user in your ...

How do I add a report to any Dashboard?

Web Dashboards can be used with Insights, Segmentation, Funnels, and Retention reports. To add a report to your Dashboard, click on the in the upper right hand corner ...

How are Retention cards in Dashboards calculated?

Depending on the date range of the saved report, Daily retention buckets default to either 1, 7, 14, and 28 days or 1, 14, 28, and 56 days. ...

How is Retention defined in Signal?

The canned Retention events in Signal (2 Week, 3 Week, 4 Week, and 2 Month) are “Anything” Retention events. Anything retention means that the user came back and ...

When should I use Signal?

Signal allows you to understand the behaviors that drive customers to convert so that you can make informed decisions on what behaviors you want to incentivize or disincentivize ...

What are the summary statistics in my Signal CSV export?

Below are explanations for the summary statistics that you will find in the CSV export of your Signal correlation. To export the results to a CSV, click the ...

Where can I get help with JQL?

Mixpanel has a JQL support Community dedicated to all things JQL and ReportKit. Our Support Team is active in the community and is dedicated in helping you get ...