Uploaded user ID cohort reduced by half

I imported a cohort from a CSV file with x k rows of user IDs (email addresses). Amplitude is now showing an amount of significantly less users (cut by a couple thousand) in “population over time”. Why doesn’t this compute to the original row number in the CSV file? Where is the exclusion of user IDs happening? Thanks.

Find more posts tagged with

Cohort

Import

Accepted answers

Hadish

Hey there, when you upload a cohort via CSV, Amplitude will only include users who already exist in your account. If any of the user IDs in your CSV haven't triggered events in your product/have any events within Amplitude, they will not be included in the cohort population. It will not create any new users who don't already exist in your account. Additionally, if any of the user IDs in your CSV are duplicates or have formatting issues, they may also be excluded. It's possible that these factors could explain why the population size is less than the original number of rows in your CSV. I hope this helps clarify things!

All comments

Hadish

Quick Links

Unanswered Questions

playing videos 9:16 (vertical) in an iOS guide?
Hi all, We are getting set up on Amplitude and want to be able to have demo videos automatically show up in a guide in a 9:16 ratio (vertical/portrait) and not in the crunched landscape orientation that the current frame delivers for Vimeo and YouTube. We are using the iOS SDK, which seems like it may be the limiting…
Trying to import new user attribute from CSV but it doesn't work
I have a csv with 2 columns user_id and lead_source. I went to Catalog and selected CSV under Lookup Tables. Step 1: I brought in the CSV and Step 2: I mapped the first column (user_id) to User ID (Amplitude User). It showed me a sample of my CSV and showed both columns at the bottom of Step 2. I clickd Finish. I went to…
How to filter by Event properties in Segmentation chart
I am unable to find my Event Properties in the list of “+ Filters” in Segmentation chart.
notifications.integration.saveFailure - Unable to add Facebook Cohort as a Destination
Myself and other team members have tried using the Facebook Cohorts integration however we always receive the same error ‘notifications.integration.saveFailure When looking in Meta Business Manager it says that the integration is active however when going into the Destinations tab in Amplitude, it is blank I have tried the…
User ID is converting to a big number
I am setting user property wallet address, and using the same variable to set user ID. However, while walletAddress works (0xA66...54), User ID seemingly converts the hex to a big number (1.2905460614871781E+48) which is preventing us from using filtering and views. Any ideas?