kapa.ai Can I create a cohort by importing a csv of users?
kapa.ai Can I create a cohort by importing a csv of users?
kapa.ai Can I create a cohort by importing a csv of users?
Yes, you can create a cohort in Mixpanel by importing a CSV of users. This is particularly useful when you have a list of distinct_ids that cannot be easily grouped by existing behaviors or properties. The process involves uploading a CSV to bulk update user profiles with a new property that indicates cohort membership. You then use this property to define your cohort.Here’s how it works: 1. Prepare a CSV file with two columns: one for the distinct_id values and another for a user property (e.g., inCohort = "yes") to indicate cohort membership. Do not include column headers. 2. Go to the Users tab, click Add/Edit Profile, select Import from CSV, and upload your file. 3. Assign property names to each column during the upload process (e.g., "$distinct_id" and your cohort property). 4. Once imported, use the new user property to define your cohort.Note: Cohorts created this way are static and will not update over time, since the user property remains unchanged. If a distinct_id in your CSV does not match an existing user, a new user will be created with that distinct_id Creating a Cohort via a 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.