Skip to main content

Hi there,

 

I would like to create and save a user segment but it is composed of 670 different users (ie. distinct user_id).

Should I enter each of the 670 user_id manually in the interface or is there is a way to do a “bulk import” or create this segment automatically (eg CSV upload) ?
 

 

Thanks !

Hey @Louisrbrt 

I’m not sure of what’s the limit in the number of values, but you can copy a list of comma-separated values to your clipboard and paste it into the search box for that property i.e User ID as demonstrated here to build your segment.

Currently a segment doesn’t support a csv upload, but you can build a behavioral cohort ( if you have access to it ) via a csv file of user ids and then use that cohort in your segmentation chart.

Hope this helps.


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

 


Reply