How to Quickly Combine a List of User IDs into a Customer Cohort Without Manual Selection

Rachel S. · 2026-03-30T13:33:10.572Z

I have a list of user ids for existing customers/profiles and want a way to quickly combine them into a cohort without manually selecting each user id. How do I do this?

You can create a cohort from a list of user IDs by uploading a CSV file. Here's how:

1.
Prepare your CSV file with two columns:

One column containing the $distinct_id values (your user IDs)
One column containing a user property that flags cohort membership (e.g., inCohort = "yes")
Do not include column headers in the file — you'll define them during the upload wizard.

2.
Upload the CSV by going to the Users tab, clicking Add/Edit Profile, selecting Import from CSV, and uploading your file. [Creating a Cohort via CSV]
3.
Map the columns in the upload wizard:

Assign $distinct_id as the property name for the column with user IDs.
Assign a custom property name (e.g., inCohort) for the membership flag column.
Click Import Profiles. [Bulk Import from CSV]

4.
Define the cohort using the newly uploaded property (e.g., filter for users where inCohort == "yes"). [Creating a Cohort via CSV]

⚠️ Important notes:

If a $distinct_id in your CSV doesn't match an existing user, a new profile will be created for it.
Cohorts created this way are static — they won't update over time since the underlying user property doesn't change automatically.
The maximum CSV size is 1 million rows.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

How to Quickly Combine a List of User IDs into a Customer Cohort Without Manual Selection

1 comment

Steps to Create a Cohort via CSV

Steps to Create a Cohort via CSV