Mixpanel Community Icon

Can I create a cohort by importing the UUID from a csv?

·
·

Can I create a cohort by importing the UUID from a csv?

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

    Hi Rohith J., 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
    ·
    ·

    Yes, you can create a cohort in Mixpanel by importing UUIDs (Unique User Identifiers) from a CSV file. Here's how you can do it: 1. First, prepare your CSV file with the UUIDs. Make sure to include a column for the $distinct_id (which would be your UUID in this case) as it's the most important identifier for user profiles in Mixpanel.2. Navigate to the Users page in Mixpanel.3. Click on "Add/Edit Profile" to start the import process.4. In the import workflow, you'll need to set the $distinct_id column to match your UUID column from the CSV.5. You can then add additional properties if needed.6. After importing the profiles, you can create a cohort based on these imported UUIDs.This process is outlined in the Mixpanel documentation on importing profiles via the UI.Additionally, if you're working with sensitive data like patient information in healthcare, it's a good practice to use UUIDs for anonymization. As mentioned in a Mixpanel blog post about healthcare analytics, "We anonymized using Unique User Identifiers (UUID). Unique User Identifiers or UUIDs are a system-generated set of letters and numbers that are produced and attributed to a user when a user creates an account." Mixpanel Blog: Healthcare AnalyticsRemember, when creating cohorts with imported data, the cohort will remain static and won't update automatically over time, unlike dynamically defined cohorts.

    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.

  • Avatar of Rohith J.
    Rohith J.
    ·
    ·

    The UUIDs are already present in Mixpanel