how can I upload user properties using a csv
Hi Bradley A., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To upload user properties using a CSV file in Mixpanel, you can follow these steps:1. Go to the Users page in Mixpanel.
2. Click on "Add/Edit Profile".
3. Select "Import from CSV" tab.
4. Upload your prepared CSV file.When preparing your CSV file, keep in mind:- Do not include column headers in the CSV file.
- The most important column is $distinct_id
for user profiles (or $group_id
for Group Profiles).
- The CSV file should have a maximum of 1M rows.After uploading the CSV:1. Choose the identifier column ($distinct_id
or $group_id
).
2. Select the columns you want to import and map them to Mixpanel profile properties.
3. Click "Import profiles" to proceed.It's important to note that:- If you import profiles with existing $distinct_id
values, those profiles will be updated with the additional properties.
- Uploading profiles with the same email or name but different $distinct_id
will create duplicates.
- New information for existing properties will overwrite the existing values.For more detailed information, you can refer to the User Profile: Demographic attributes for your users documentation.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.