To add a custom profile property (e.g., Internal User) to users via CSV import in Mixpanel, follow these steps:
1. Prepare Your CSV File
- Do not include column headers in your CSV file.
- The first column should contain the users’ $distinct_id values.
- The second column should contain the value for your custom property (TRUE or FALSE for Internal User).
- Example (no headers):
12345,TRUE
67890,FALSE
54321,TRUE
2. Import the CSV in Mixpanel
- Go to the Users tab in Mixpanel.
- Click Add/Edit Profile and select Import from CSV.
- Upload your CSV file.
3. Map Columns to Properties
- In the upload wizard, assign the first column as $distinct_id.
- Assign the second column as your new custom property, e.g., Internal User.
- You can define the property name during this step, even if it does not already exist in your data.
4. Complete the Import
- Review the column mappings and values.
- Click Import profiles to apply the changes.
Notes:
- If the $distinct_id matches an existing user, the profile will be updated with the new property. If not, a new profile will be created.
- If you upload new information for an existing property, it will overwrite the old value. New properties will be added to the profile.
- The maximum CSV size is 1 million rows.
This process will create the Internal User property for each user and set it to TRUE or FALSE as specified in your CSV file. There is no need for the property to pre-exist in Mixpanel; it will be created during the import if it does not already exist.
For more details, see the official documentation on Bulk Import from CSV and Importing Profiles via the UI.
