Send data to LiveRamp

LiveRamp allows clients to combine customer data from various online and offline sources, centering around the use of web cookies that allow websites to remember visitors.

You can associate records in Amperity to an audience in LiveRamp by sending a combination of identifier data and query data. LiveRamp uses:

  • Identifier data to match records to other identifiers in the LiveRamp Identity Graph.

  • Segment data to group records into segments based on certain attributes for downstream targeting, measurement, and personalization.

LiveRamp requires an audience ID. This may be a client customer ID from another application, it may be the LiveRamp audience ID itself (from LiveRamp data that was imported to Amperity), or it may be the Amperity ID.

This topic describes the steps that are required to send CSV, TSV, or PSV files to LiveRamp from Amperity:

  1. Get details

  2. Add destination

  3. Add data template

Get details

LiveRamp requires the following configuration details:

  1. The username.

  2. The passphrase.

  3. The remote folder to which Amperity will send data. For example: /uploads/tenant-name.

  4. The LiveRamp public key to use for GPG encryption .

  5. LiveRamp requires a header row to be present in CSV, TSV, and PSV files.

File preferences

Sending data to LiveRamp should follow recommendations for uploading data .

File limitations

Review LiveRamp file limitations .

File formats

LiveRamp supports the following file formats :

  • CSV

  • PSV

  • TSV

Important

Be sure to enable the Include header row in output files option for the Amperity destination.

GPG encryption

LiveRamp prefers GPG encryption and GZip compression.

Add destination

Configure Amperity to send data to LiveRamp using SFTP.

To add a destination

  1. From the Destinations tab, click Add Destination. This opens the Add Destination dialog box.

  2. Enter the name of the destination and a description. For example: “LiveRamp” and “This sends query results to “LiveRamp”.

  3. From the Plugin drop-down, select LiveRamp.

    This automatically selects liveramp as the Credential Type and assigns files.liveramp.com or sftp.liveramp.com as the location to which data is sent.

  4. From the Credential drop-down, select Create a new credential. This opens the Create New Credential dialog box. Enter a name for the credential (typically “LiveRamp”), and then enter the username and password required to access this SFTP location.

  5. Under Settings, enter the path to the remote folder.

  6. From the File Format drop-down, select CSV, TSV, or PSV.

  7. Add a single character to be used as an escape character in the output file. (This should match the escape character required by LiveRamp.)

    Note

    If an escape character is not specified and quote mode is set to “None” this may result in unescaped, unquoted files. When an escape character is not specified, you should select a non-“None” option from the Quote Mode setting.

  8. Specify the encoding method. “GZip”.

  9. Add the PGP public key that is used to encrypt files sent to LiveRamp.

  10. Optional. Specify the line ending type: LF or CRLF.

  11. Optional. Set the quote mode.

    Note

    If the quote mode is set to “None” and the Escape Character setting is empty this may result in unescaped, unquoted files. When quote mode is “None”, you should specify an escape character.

  12. Optional. Select Include success file upon completion to add a .DONE file to indicate when an orchestration has finished sending data.

    Tip

    If a downstream sensor is listening for files sent from Amperity, configure that sensor to listen for the presence of the .DONE file.

  13. Optional. Select Include header row in output files if headers are included in the output.

  14. Select Allow customers to use this destination.

  15. Select Allow orchestrations from users with limited PII access. (A user with limited PII access has been assigned the Restrict PII Access policy option.)

  16. Click Save.

Add data template

A data template defines how columns in Amperity data structures are sent to downstream workflows. A data template is part of the configuration for sending query and segment results from Amperity to an external location.

You have two options for setting up data templates for LiveRamp:

  1. For use with campaigns

  2. For use with orchestrations

for campaigns

You can configure Amperity to send campaign results to LiveRamp. These results are sent from the Campaigns tab. Results default to a list of email addresses, but you may configure a campaign to send additional attributes to LiveRamp.

To add a data template for campaigns

  1. From the Destinations tab, open the menu for a destination that is configured for LiveRamp, and then select Add data template.

    This opens the Add Data Template dialog box.

  2. Enter the name of the data template and a description. For example: “LiveRamp email list” and “Send email addresses to LiveRamp.”

  3. Enable the Allow customers to use this data template option, and then enable the Make available to campaigns option. This allows users to send campaign results from Amperity to LiveRamp.

  4. Verify all template settings and make any required updates.

  5. Click Save.

for orchestrations

You can configure Amperity to send query results to Liveramp. These results are sent using an orchestration and will include all columns that were specified in the query.

To add a data template for orchestrations

  1. From the Destinations tab, open the menu for a destination that is configured for LiveRamp, and then select Add data template.

    This opens the Add Data Template dialog box.

  2. Enter the name of the data template and a description. For example: “LiveRamp customer profiles” and “Send email addresses and customer profiles to LiveRamp.”

  3. Enable the Allow customers to use this data template option. This allows users to build queries, and then configure orchestrations that send results from Amperity to a configured destination.

  4. Optional. Enable the Allow orchestrations from customers with limited PII access option. This allows users who have been assigned the Restrict PII Access policy option to send results from Amperity.

  5. Verify all template settings and make any required updates.

  6. Click Save.