User segment from CSV

This was super helpful info. Thank you for sharing it. 

Could someone from Amplitude chime in to let us know whether there’s a limit on how many values can be pasted into this field? 

Also...here are a few tips I learned last week about pasting in values to define a segment:

1. If your source data is in a column in Excel and you need to transform it into a comma-separated list, use CONCATENATE. 
2. After pasting your values into the segment and selecting them all, hover over the input field and scan the tooltip to look for irregularities in the formatting of your values that could break the list (screenshot 1 below). Mine had some hard returns, for example, which munged all subsequent values in the list. 
3. A way to double-check that all your values were correctly added: Select All values from the segment, copy them to your clipboard, paste into Excel, and choose Use Text Import Wizard (see screenshot 2 below) to split the values back out into columns, then count the columns to ensure the count matches the original count of values from your source file. 
4. If you save your segment and edit it later...your edits will not be applied to any reports that use your saved segment. You will need to go into those reports, remove the segments, and re-add the saved segments to apply the most up-to-date segment definitions. 

Screenshot 1

Screenshot 2

You can import a user segment from a CSV by creating a cohort in Amplitude. Go to the Cohorts section, upload your CSV with user identifiers, and save it. Once imported, you can use the cohort in your analyses just like any other segment.