how can i create a cohort of users using a csv?
how can i create a cohort of users using a csv?
how can i create a cohort of users using a csv?
To create a cohort of users using a CSV in Mixpanel, you can follow these steps: 1. Prepare your CSV file: - Do not include column headers in the CSV. - Include a column for the user identifier (usually $distinct_id). - Add a column with a unique property to identify the cohort (e.g., "Cohort = Android Users").2. Upload the CSV: - Go to the Users page in Mixpanel. - Click on the "Import from CSV" tab. - Select your prepared CSV file to begin the upload process.3. Choose the identifier column: - Select the column that contains the $distinct_id (or another unique identifier) for each user.4. Map the cohort property: - During the CSV import process, map the column containing your cohort identifier property.5. Create the cohort: - After importing the CSV, go to the Cohorts tab. - Create a new cohort by filtering for users with the unique property you added (e.g., "Cohort = Android Users"). - Save the cohort.Note that cohorts created this way will remain static and won't update automatically over time.Source: Mixpanel Users FAQRemember to keep your CSV file under 1M rows for successful import.Source: User Profile Bulk Import from CSV
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.
this is not recognising that i have two columns. the text it identifies is: Column 1 Values 1 396E4EB0-3AE4-4A88-88C5-9EA8BB710FA1;Cohort 1. 1-6 months
Let me check the knowledge base for you again. One moment! 📚
I apologize for the confusion. It seems you're encountering an issue with the CSV import process in Mixpanel. Based on the information you've provided, it appears that Mixpanel is not correctly recognizing the columns in your CSV file. Let's troubleshoot this issue: 1. CSV Format: The CSV file should be formatted according to RFC4180 standards. Make sure your CSV is properly formatted with each column separated by commas. Lookup Tables FAQ2. Column Headers: When preparing a CSV for profile import, you should not include column headers. Mixpanel expects the first row to contain data, not headers. Bulk Import from CSV3. Delimiter Issue: It looks like your data might be using a semicolon (;) as a delimiter instead of a comma. Mixpanel expects comma-separated values. Try changing the semicolon to a comma in your CSV file.4. Data Structure: Your data should be structured like this:
```LBKS Instead of:
```LBKS 396E4EB0-3AE4-4A88-88C5-9EA8BB710FA1;Cohort 1. 1-6 months
```LBKSLBKS5. File Preview:
During the import process, Mixpanel should show you a preview of the columns. Make sure to check this preview to ensure your columns are being recognized correctly. [Choose Desired CSV Columns](https://docs.mixpanel.com/docs/data-structure/user-profiles#choose-desired-csv-columns)LBKSIf you've made these changes and are still experiencing issues, it might be helpful to review your CSV file in a text editor to ensure there are no hidden characters or formatting issues. If the problem persists, you may want to contact [Mixpanel Support](https://mixpanel.com/get-support) for further assistance.
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.