Mapp: Export Audiences (SFTP)
The SFTP Export allows you to export your Lytics audiences to an SFTP server in a CSV format, which can then be consumed by Mapp and used to create lists.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: File based transfer.
- Frequency: Batch daily at a specified time, or once only.
- Resulting data: User fields are written to a file. New users are added to subsequent file uploads, and no users are removed.
This integration utilizes the SSH File Transfer Protocol to send user data. The file name needs to be formatted as follows: export-lytics-{audience name}-{timestamp}.csv
. This will be transferred to the SFTP server and the file needs to contain headers in a format readable by Mapp. Once the export is started the job will:
- Scan the audience for all currently existing members.
- Write the users and any mapped fields to a CSV file.
- Upload the CSV file to the user-specified SFTP server.
- If Keep Updated is selected in the configuration process, steps 1-3 will occur daily at the defined time.
Fields
By default, Lytics exports the following fields to Mapp.
Lytics User Field | Description | Mapp Field | Type |
---|---|---|---|
email/ID | Email Address or other identifier | string | |
Audiences | Audiences the user is a member of | user.CustomAttribute.SegmentMembership | comma separated list |
Configuration
Follow these steps to set up and configure an export of Mapp in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select Mapp.
- Select the Mapp SFTP Export job type.
- Select the authorization you would like to use.
- From the Audience input, select the Lytics audience that contains the users to export.
- From the Fields Mapping, select the Lytics fields you want to map to Mapp fields.
- (Optional) Toggle Show Advanced Options to expand the following options.
- Select the Keep Updated checkbox to continuously run this export.
- From the Time of Day input, select the time of day to run the export. Note this is only available if Keep Updated is selected.
- From the Timezone input, select the timezone for time of day.
- Click Start Export.