Documentation / Product / Integrations / LiveRamp

LiveRamp: SFTP CSV Export (EU)

Exporting user profiles and audience membership to LiveRamp allows you to 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 an audience column which will contain the Lytics audience name or slug the user is part of and can be configured.

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. Select the authorization you created.
  5. From the Audiences input, select the audience(s) that contains the users to export.
  6. 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.
  7. Use the Field Mapping input to map Lytics fields to Liveramp fields. Select Lytics data fields from the left drop-down list and Liveramp fields from the right drop-down list.
  8. In the Header For Lytics Audiences textbox, enter the column name for the field that will be populated with Lytics audience slug. By default, the column name is set to lytics_audiences.
  9. Check the Send Audience Name checkbox to send the Lytics audience name instead of Lytics audience slug. Lytics audience slug is the readable form of Lytics Audience. For example: if Engaging Customer for ABC Product is the Lytics audience name then, its slug could be engaging_customer_for_abc_product. You can also edit Lytics audience to set the slug you want.
  10. Check the Continuous Export checkbox to export the audience repeatedly.
  11. In the Custom Delimiter textbox, enter the delimiter for the file to be exported.
  12. In the Filename textbox, provide the desired filename for the CSV file to be exported.
  13. From the Timestamp Format drop-down, select the desired timestamp format that would be appended in the provided filename above.
  14. From the File Export Frequency input, select how often a continuous export should create a new file.
  15. 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.
  16. From the Timezone input, select the timezone for time of day.liveramp-eu-export
  17. Click the Start Export button to begin the workflow.