All Amplitude IDs should be integers. Please confirm that the file only contains valid Amplitude IDs and no extra columns or characters.

jose.asilis

Hi everyone

 

I’ve tried reading:

• Error with uploading csv for cohorts - none of the upload user id matches | Community (amplitude.com)
• Errors with Amplitude ID importing cohorts | Community

 

But I don’t know what’s wrong.

I’ve extracted the list of Amplitude IDs from a Funnel, copied and pasted them on a csv, and .txt files with nothing more than the numbers (no commas, nada). Just line by line, and the platform rejects it. 

 

Any ideas why?

 

 

JennRu

Hi jose.asilis , 

Great workaround proposal, I would just recommend to use the = logic rather than set contains. If there’s a case that a user’s ID = 123 and another user’s ID = 123456, but you only want to include user 123 in your cohort, the = would be the most strict condition to yield the exact list of IDs that are in your list.

For your original CSV file attempt, 

1. Was there a row header in the CSV file? Make sure to remove any headers from the file
2. Were the Amplitude IDs shown in scientific notation in the CSV file? If yes, convert these values to a custom number with no decimals. 

   

    

   

   

   Then the CSV import should work. 

 

 

As an additional suggestion, you can build a dynamic cohort directly from a funnel analysis chart. And if you want to restrict the cohort to a specific date range, you can edit the dates in the cohort to an exact interval, rather than a rolling interval.

 

Either way, your workaround proposal works just as well (just modifying set contains to = 

But let me know if this helps if you ever retry CSV imported cohorts.