Mixpanel Community Icon

how can I upload user properties using a csv

·
·

how can I upload user properties using a csv

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    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

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    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.