Import Profiles With Explore

Mixpanel allows you to import profiles in bulk using CSV.

After import, events that users or groups trigger will be visible on his or her profile in the "Activity Feed".

To get started, click CREATE OR UPDATE PROFILE.

Screen_Shot_2019-09-27_at_2.57.04_PM.png

Prepare Your CSV for Upload

When editing the CSV that you want to upload as profiles, you should not include column headers (e.g., Email, Name, etc.). Instead, you’ll identify column headers during the CSV upload wizard in the Mixpanel UI.

Note:

If you upload a CSV with new information for existing contacts or companies, any existing information will be overwritten by new values you've imported.

Add an Identifier Column

The most important column in your spreadsheet is the $distinct_id column for user profiles or group identifier for group profiles, as these are the canonical identifiers in Mixpanel.

For more information on how $distinct_id works in Mixpanel, see:

To ensure future actions by each user is recorded on the correct people profile, make sure the value you assign for $distinct_id  or group identifier on import is the same value on which you’re identifying users when they log in.

If you do not assign an identifier column, Mixpanel will use your $email column as the $distinct_id value; if you don’t have an $email column either, then the $distinct_id value will be assigned randomly by default as described above.

Add Additional Columns for Properties

After the $distinct_id column, you can add as many columns as you want for additional profile properties.

Keep in mind that Mixpanel reserves a handful of people properties as special or reserved Properties. These properties will allow you more flexibility and functionality within the Mixpanel web application.

For example, if you are interested in using Mixpanel’s messages capabilities, you will need to include an $email property (not just email).

Other special properties include $first_name, $last_name, $username, and $phone. Ensure that if you’re adding any of these values that you enter the column headers with the dollar sign and name so that Mixpanel recognizes them as a special or reserved Property.

Note that a '+' needs to precede phone numbers. This is especially useful for international numbers.

Duplicate Profiles

If you import people profiles using $distinct_id values that already exists, those profiles will be updated with the additional people properties in your CSV.

Mixpanel imports based only on $distinct_id and will not deduplicate people profiles automatically based on other properties, like $email or $last_name.

If you upload people profiles that have the same email address or the same name as existing people profiles, you will be uploading duplicates - they will not be combined.

Ensure that the users you’re uploading don’t already have a people profile before you import, and if they do, ensure that the identifier column matches the existing profile’s identifier.

Selecting a profile will display the identifier in the URL as the query parameter, such as "?distinct_id". 

Screenshot_2018-03-22_13.19.38.png

Change Profile Type

You can upload user profiles using the $distinct_id or group profiles using the group identifier. 

To change the type of profile you are importing, select the Create Profile dropdown and select the profile type.

Screen_Shot_2019-09-26_at_3.16.26_PM.png

Ensure that your CSV has the right identifier when you import profiles. Use the $distinct_id for users, and the group identifier for groups.

Advanced People Profile Imports

The CSV import wizard treats every property value as a string. This means lists (such as Push Notification tokens) and numbers won't be properly imported.

For more advanced people profile imports, we recommend sending updates to the /engage endpoint instead of using the CSV import tool.

Is this article helpful?

Comments

0 comments

Article is closed for comments.