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 report allows you look at your data in terms of totals, uniques, and averages: The Formulas report allows you to use either totals or uniques, while ...

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

By default, Mixpanel does not have an out-of-the-box dashboard feature for the web where you can select reports and have them appear in one central dashboard. However, there ...

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?

The Surveys tab does not have a button where survey results may be exported to CSV. Instead, use JQL to quickly pull the results of your survey by ...

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 or Properties missing from my dropdowns?

There are two reasons why you might not be seeing Events and Properties in your dropdowns that you had before: A member of your team has chosen to ...

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 (except ...

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?

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?

How you import revenue data depends on whether you are trying to import revenue as a Property of a purchase Event or import transactions for use in Mixpanel’s ...

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