Users FAQ

How do I create a cohort out of a list of user emails I have?

Can I download User profiles?

User profiles can be downloaded through the Mixpanel UI or alternatively by either a JQL Query or a Python script.

The ability to download to CSV is available on paid plans - visit the pricing page for more information or to upgrade.

How do I download User Profiles in Mixpanel?

To download your user profiles from the Users page, simply click the Export icon. This will download all the profile data being displayed in the current report - to download more properties, edit your columns to select more properties. You can choose to filter the list or select individual profiles to download instead of downloading the full list. 

How do I download User Profiles with JQL?

Note that downloads using JQL are limited to 2GB, so if you run into issues downloading, try the steps below for the Python script instead, which can handle any size download.

In your Mixpanel project, click on Applications > JQL > Build your own, and remove any pre-populated code that appears.

Then, enter the following query > RUN QUERY, then Download to CSV*:

function main() {
  return People()
}

Learn more about the power of JQL.

How do I download User Profiles with a Python Script?

User profiles can be downloaded through the Mixpanel API. One way to request and execute the download is through a simple Python script. Use the Mixpanel_api repository and reference the download section to find the necessary functions. In order to obtain all of the necessary components of the script:

1. Collect your API credentials by clicking on your initials in the top right of Mixpanel and selecting Profile & Preferences under ACCOUNT SETTINGS.

Under the Projects tab you can view your API credentials for each project.

2. If you are downloading all of your users, you can ignore cohort parameters. However, if you want to download a subset of users, you'll want grab these two parameters. In order to do this:

• Go to the Users page and select the subset of users you would like to download using user properties and/or events.
• Open Developer Tools and bring focus to the console (On Chrome for Mac: command + option + "J" & on Chrome Windows: control + shift + "J").
• Refresh the page.
• From the console, select the Network tab, select XHR, find the "engage" request in the "Name" column, and then select Headers.

• Find the 'filter_by_cohort' value.
• Copy and paste the 'filter_by_cohort' value into the script to target only users in the Users page.
• Save the document.

The following code sample is from mixpanel_api import Mixpanel:

filter_by_cohort = ''
m.export_people(query_params=
{'filter_by_cohort' : filter_by_cohort})

3. Execute the script to pull these user profiles into a new JSON file. If you would like this in CSV format, you will want to add the parameter "format = 'CSV'". On a PC, simply open up the script with Python 2.7 to execute it. On a Mac, open up your Terminal and follow the steps below:

The downloaded file will now be in the same location as the python script, and will include the epoch time stamp for when the download was performed.