Create segments through file upload
There are two ways of uploading a file - 1. Upload a file directly, 2. Upload the file through an FTP server. The segments created through upload are static as the customers/values in a partition do not change automatically. However, you can edit a segment to update details manually, i.e., you can add new customers or update existing segment values (partition name) of customers. Your CSV file should have the header
1st column header: user_id, mobile, email or external_id
2nd column header: value
You can also track customer activities manually by making the respective segment SCD and specifying the date of the tracked values every time you update the segment.
To create a segment through file upload:
- On the EI navigation pane, click User Segments.
- Click Create Segment.
- In Segment Name, specify a name for the group.
- In Description, specify a short description of the segment.
- In Type, select SCD to keep a track of customer behavior for the current segment. Select Non-SCD to save only the current snapshot.
- In Method, choose Upload for list creation through file upload.
- Click Next to continue.
OPTION | DESCRIPTION |
---|---|
Valid from | You need to manually specify the date when the events specified in the CSV file have happened (for SCD). Hence, whenever you upload a new file, it is required to specify the date on which the values are tracked |
Upload Type - Upload | Select Upload to directly upload the CSV file and click Choose File to upload the fil Sample contents of a .csv file with customer id and loyalty value: mobile,value44700900000,High 44700915020,Low 44700911011,High |
Upload Type - FTP | Select FTP to upload through an FTP server >specify the path in the FTP server where the file is available and > click Upload Note: Enter a valid FTP path. FTP path must be relative to the configured root folder. For example, rootfolder/FTP path such as ftp://demo_apac/demo_master/demo_path/demo**points.csv. Here, demo_apac/demo_master/ is the root folder and /demo_path/ is the FTP path. To use FTP, you should have configured the FTP address and access credentials as explained below 1. Navigate to Segments > Settings. 2. Specify Server Address (FTP server URL), Username, and Password. Notes: 1. The file name should adhere to the following format: "_segment name__suffix**" For instance, take 'demo__points.csv' as an example. Here, 'demo' represents the segment name, separated by a double underscore from the 'points' suffix. 2. The FTP path must point to the correct CSV file. 3. The first row of the CSV sheet must be a column header. 4. The first column header must be a user identifier such as user id, mobile, email, and external_ID. If the identifier is mobile(mobile number), country code is mandatory (without the "+" sign). For example, 919972752991. 5. The second column header must have a partition value. For example, If the first column header is the user_id(1,2,3, and so on) then the second column header must hold the partition value( high, medium, or low). |
- Click Upload & Proceed. You will see the segment with the list of partitions as shown below
- Partitions: Partitions are different values of a segment. For example, if a segment has high loyal, low loyal, and medium loyal as segment values, then three partitions will be created (one for each value)
- Once the processing is completed, review the details and click Create
The segment will be in Inprogress status initially and once processed, the status label will disappear automatically.
- Inprogress: The segment creation is being processed
- Draft: Signifies draft state where the recent changes were not saved. If you open the segment, you will see Draft available: Save changes to see the partition values. You can save or Deactivate draft segments
Editing an existing upload-based segment
You can modify a segment to add or modify existing details. During editing the upload-based segment, the existing segment details will be completely replaced with the new details that you upload. So, make sure you create a new file accordingly.
Note
Each time you upload or import a file using the upload-based segmentation, the data from the new file replaces the existing data.
To edit a segment
- On the Segments summary page, click on the segment that you want to edit. You can filter the summary list by Type (SCD, Non-SCD, or All) and Method (Conditions, Upload, or All) and also search for a specific filter in the Search box.
- Click Edit Segment.
- Choose your preferred Upload Type and upload the new file
- Click Upload & Proceed. Wait until the file is processed successfully
- Click Update.
Updated 6 months ago