Documentation / Product / Integrations / LiveRamp

LiveRamp: SFTP CSV Export (EU)

Exporting user profiles and audience membership to LiveRamp allows you use behavioral data, content affinities, and insights from Lytics combined with LiveRamp's identity resolution to fine-tune your targeting. Export your audience to an SFTP server in a LiveRamp CSV EU format. Use SFTP to stage your files before importing into LiveRamp.

Integration Details

This work exports the user profiles as a CSV file. The CSV file format is specific and follows the Liveramp EU CSV format. The number of User Fields that will be exported is limited. We also append the Audience column with its slugs for all the selected Audience in the configured export work. These columns will be filled with 1 if the user is a member of that audience and 0 if not.

This integration once started it will:

  1. Connect to the SFTP server.
  2. Navigate to the configured folder in the SFTP server.
  3. Create a CSV file in the SFTP server.
  4. Write CSV headers to the file.
  5. Scan the audience and process users into CSV lines.
  6. Write CSV lines to the file.
  7. Close the completed file and disconnect from the SFTP server.
  8. Schedule the next run.
  9. LiveRamp imports the file for processing. See LiveRamp's documentation for details on setting up LiveRamp to import the file.

Fields

We follow the Liveramp SFTP file format to create the SFTP file. Following table shows the fields that can be mapped and exported. By default, none of the below fields are mapped except for Customer ID which will be filled by the Unique Identifier. Note that you can customize the Lytics source fields as part of the workflow configuration.

Lytics User FieldDescriptionLiveRamp FieldType
Any (Unique ID)Field that is unique to each UserCustomerIDstring
AnyLytics FieldFIRSTNAMEstring
AnyLytics FieldLASTNAMEstring
AnyLytics FieldADDRESS1string
AnyLytics FieldADDRESS2string
AnyLytics FieldADDRESS3string
AnyLytics FieldADDRESS4string
AnyLytics FieldTOWNstring
AnyLytics FieldPOSTCODEstring
AnyLytics FieldEMAIL1string
AnyLytics FieldEMAIL2string
AnyLytics FieldEMAIL3string
AnyLytics FieldMOBILE1string
AnyLytics FieldMOBILE2string
AnyLytics FieldLANDLINE1string
AnyLytics FieldMD5EMAIL1string
AnyLytics FieldMD5EMAIL2string
AnyLytics FieldMD5EMAIL3string
AnyLytics FieldSHA1EMAIL1string
AnyLytics FieldSHA1EMAIL2string
AnyLytics FieldSHA1EMAIL3string
AnyLytics FieldSHA256EMAIL1string
AnyLytics FieldSHA256EMAIL2string
AnyLytics FieldSHA256EMAIL3string
Audience Name 1 (slug)Audience NameAudience Name 1 (slug)string
Audience Name 2 (slug)Audience NameAudience Name 2 (slug)string

Configuration

Follow these steps to set up and configure an export of LiveRamp data in EU format in the Lytics platform.

  1. Navigate to the Integrations page and select the LiveRamp tile. liveramp-tile-2

  2. Select Worklows from the menu on the left.

  3. Select SFTP CSV Export (EU Format) from the list of workflows.
  4. From the Audiences input, select the audience(s) that contains the users to export.
  5. From the Identifier input, select the field that will be placed in the first column of the file as CustomerID. This field should be a unique identifier. liveramp sftp eu

  6. Click on the Show Advanced Options tab to expand the advanced configuration.

  7. Select the Continuous Export checkbox to export the audience repeatedly.
  8. In Filename textbox, provide the desired filename for the CSV file to be exported.
  9. From the File Export Frequency input, select how often a continuous export should create a new file.
  10. From the Time of Day input, select the time of day to start the export each day. This applies to daily, weekly, and monthly frequencies only.
  11. From the Timezone input, select the timezone for time of day. liveramp sftp eu2
  12. Click the Start Export button to begin the workflow.