Segment Transfers allow you to export your User Segments via upload of a CSV file to your SFTP server. You can use this to collect and aggregate your User data on the platform, and export it at regular intervals for sending messages elsewhere.
Create a Segment Transfer campaign
Click on the button Create Segment transfer. You will see four steps:
Step 1 - Setup
-
Give your Segment Transfer a meaningful name. Optional you can fill in a description an add a label.
-
Choose when to dispatch Segment Transfers. You can set this to go out once, or on a regular schedule.
-
Optional to check the checkbox Controlgroup.
- Click Save changes, and click on Go to next step: Target Group.
Step 2 - Target group
- Choose a User Segment to transfer to your SFTP Server.
- Click on Save changes and on Go to next step: Target & format.
Step 3 - Target & format
- Click on Create new Transfer Format.
-
Choose your Integration for the Transfer. For more on setting up your SFTP Integration.
- Give your file(s) a unique name. If you are setting up recurring uploads, it is important to have filenames that you can identify and distinguish later. For example, if your uploads are daily, you can add the date to the filename.
-
Choose your compression format, or set the file to uncompressed.
-
Select file Properties for your CSV Upload.
- Column Names: Choose whether to include a Header row with column names at the start of the document.
- Field Delimiter: Choose the character to separate the fields, use the Comma if unsure.
- Row Delimiter: Choose how to end a row, you can use "\n\r" if unsure.
- Wrapper: Choose a character, in which each field value will be wrapped.
- Escape: This is to ensure that the wrapper character can be distinguished by the same character inside a field. Using double quotations for both, the Wrapper and the Escape character is fairly common.
- NULL values: Choose what to write when a value is NULL. If left empty, an emplty string is written by default.
-
Create the column structure of your CSV. You can go column by column, giving each column a name, and a value. The value can be a user attribute, a handlebar combining attributes, or some fixed value.
- Click on Save changes and Go to next step: Cappings.
Step 4 - Cappings
- Choose your frequency caps and exclusion Rules.
- Click on Go to Transfer Summary.
- If the Segment Transfer is in order, you can now activate it.