Documentation / Product / Integrations / Mapp

Mapp: SFTP Export

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 workflow will:

  1. Scan the audience for all currently existing members.
  2. Write the users and any mapped fields to a CSV file.
  3. Upload the CSV file to the user-specified SFTP server.
  4. 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 FieldDescriptionMapp FieldType
email/IDEmail Address or other identifierEmailstring
AudiencesAudiences the user is a member ofuser.CustomAttribute.SegmentMembershipcomma separated list

Configuration

Follow these steps to set up and configure an export of Mapp in the Lytics platform.

  1. Navigate to Mapp in the Integrations section of Lytics. Mapp tile
  2. Select Workflows from the menu on the left.
  3. Select the Mapp SFTP Export from the list of workflows.
  4. Select the authorization you would like to use.
  5. From the Audience input, select the Lytics audience that contains the users to export.
  6. From the Fields Mapping, select the Lytics fields you want to map to Mapp fields.
  7. (Optional) Toggle Show Advanced Options to expand the following options.
  8. Select the Keep Updated checkbox to continuously run this export.
  9. 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.
  10. From the Timezone input, select the timezone for time of day.
  11. Click the Start Export button to start the work. export setup