Documentation / Product / Integrations / LiveRamp

LiveRamp: S3 CSV Export

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 S3 in a LiveRamp CSV format. Use S3 to stage your files before importing into LiveRamp.

Integration Details

Data is exported as a CSV with a header row. The columns are an identifier field in the first column, followed by user profile fields, followed by audience membership. Audience membership is represented by columns containing the digit 1 if the user is a member of that audience and blank if not. Headers for the audience membership columns are the audience slugs.

This integration operates by creating a CSV file in S3 to be imported by LiveRamp. Once started, the integration will:

  1. Create a multipart upload in the selected S3 bucket.
  2. Write CSV headers to the S3 file.
  3. Scan the audience and process users into CSV lines.
  4. Write CSV lines to the S3 file.
  5. Complete a multipart upload after writing all users to the file.
  6. Schedule the next run.
  7. LiveRamp imports the file for processing. See LiveRamp's documentation for details on setting up LiveRamp to import the file.

NOTE: It usually takes 1-2 days for a file to fully process into LiveRamp, another 1-2 days to distribute that audience to ad platforms, then another 1-2 days for statistics on match rates to be available in the LiveRamp UI. So, for a first time setup end-to-end, it can take about a week.

Fields

By default, Lytics will export the full user profile and audience membership to LiveRamp. Note that you can customize the Lytics source fields as part of the workflow configuration:

Lytics User FieldDescriptionLiveRamp FieldType
emailEmail Addressemailstring
N/Aaudience membershiplytics_audience_slugint

Configuration

Follow these steps to set up and configure an export of LiveRamp 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 S3 CSV Export from the list of workflows.
  4. From the Audiences input, select the audience(s) that contains the users to export.
  5. From the S3 Bucket Name input, select the bucket to save your file in. If no buckets are listed, enter the bucket name in the field below.
  6. From the S3 Bucket Name (Alt) text input, enter the S3 bucket name here if no buckets are listed above. This may occur if your access token does not have permission to list S3 buckets.
  7. From the Directory input, choose the directory to save your file in. This option can be slow on large S3 buckets.
  8. From the Identifier input, select the field that will be placed in the first column of the file. This field should be a unique identifier and be selected in the Fields to export. liveramp-s3-export-config-1

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

  10. From the Filename text input, enter the name of the file to upload. {TIMESTAMP} will be replaced by the timestamp when the export occurred, in Unix format.
  11. From the Timestamp format input, select the format for the timestamp in the filename.
  12. From the Audience Membership input, select the audiences to include in the audience membership.
  13. From the Compress input, select your compression preference for the exported file. liveramp-s3-config-2.0

  14. Select the Additional Audiences checkbox to add a column containing all the audiences a user is a member of.

  15. From the Fields to Export input, select the user fields to export.
  16. From the Custom Delimiter text input, enter a custom delimiter for your file. The default is a comma, a recommended alternate is a pipe "|". liveramp-s3-config-2.5

  17. From the Custom Join input, enter a custom join character for fields that have multiple values. The default is "&". E.g. [email protected]&[email protected].

  18. Select the Continuous Export checkbox to export the audience repeatedly.
  19. From the File Export Frequency input, select how often a continuous export should create a new file.
  20. 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.
  21. From the Timezone input, select the timezone for time of day.
  22. Click the Start Export button to begin the workflow. liveramp-s3-config-3.0