LiveRamp: Export Audiences (S3)

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.

• Implementation Type: Server-side.
• Implementation Technique: File based transfer.
• Frequency: Batch with backfill, frequency can be configured.
• Resulting data: User profiles and audience membership.

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.

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 job configuration:

Follow these steps to set up and configure an export of LiveRamp in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.

1. Select LiveRamp from the list of providers.
2. Select the Export Audiences (S3) job type from the list.
3. Select the Authorization you would like to use or create a new one.
4. Enter a Label to identify this job you are creating in Lytics.
5. (Optional) Enter a Description for further context on your job.
6. From the Audiences input, select the audience(s) that contains the users to export.
7. 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.
8. 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.
9. From the Directory input, choose the directory to save your file in. This option can be slow on large S3 buckets.
10. 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.
11. Click on the Show Advanced Options tab to expand the advanced configuration.
12. 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.
13. From the Timestamp format input, select the format for the timestamp in the filename.
14. From the Audience Membership input, select the audiences to include in the audience membership.
15. From the Compress input, select your compression preference for the exported file.
16. Select the Additional Audiences checkbox to add a column containing all the audiences a user is a member of.
17. From the Fields to Export input, select the user fields to export.
18. From the Custom Delimiter text input, enter a custom delimiter for your file. The default is a comma, a recommended alternate is a pipe "|".
19. 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].
20. Select the Continuous Export checkbox to export the audience repeatedly.
21. From the File Export Frequency input, select how often a continuous export should create a new file.
22. 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.
23. From the Timezone input, select the timezone for time of day.
24. Click Start Export.