Integrating Offline Data into Addressability Extension
To integrate your offline data into Addressability Extension, we need to collect the PII touchpoints you have for your consumers.
If you are currently onboarding PII-based data with LiveRamp, the preferred method is for us to use your onboarding files to build offline linkages. If you choose to authorize that method, email clientmatch@liveramp.com and your Customer Success Manager to confirm your authorization.
If you do not want us to use your onboarding files, below are instructions for how to send us your consumer PII data.
Create a file containing all known PII touchpoints for the consumers in your CRM. Each record must include two or more PII touchpoints for that record to be utilized. Examples of PII touchpoints include:
Name and Postal Address (First Name, Last Name, City, State, Street Address, and ZIP Code)
Email Address
Phone Number
Format and name the file according to the instructions below.
Upload the file to LiveRamp.
Files must strictly follow the guidelines listed below:
Your file must use one of our allowed delimiters (commas, tabs, or pipes), and be one of our allowed file types (.csv, .tsv, .psv, or .txt). We cannot accept Microsoft Excel (."xls" or ."xslx") files.
The delimiter must be consistent throughout the file.
If any values contain the delimiter character (for example, a comma), ensure that those values are escaped with quotation marks.
The file must be rectangular (have the same number of columns for every row). If you do not have information for any field in a given row, leave it blank.
Identifier data elements cannot span multiple columns (except for Name & Postal Address).
Your file must contain the following columns:
CCID (Client Customer ID)
FIRSTNAME
LASTNAME
ADDRESS1
ADDRESS2
CITY
STATE
ZIP
EMAIL1
EMAIL2
EMAIL3
PHONE1
PHONE2
The first field ("Client Customer ID") is used as the audience key, allowing us to de-duplicate rows in the uploaded file (in case a file has multiple rows related to the same person). The entries in this field should be unique and persistent across all files you upload. Contact your LiveRamp representative if you are not using a Client Customer ID to identify records so that we can use a PII touchpoint as the audience key instead.
The first row of the file must be a header row. Files cannot be processed without a header row. Feel free to use the headers in the example as a template:
CCID,FIRSTNAME,LASTNAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,EMAIL1,EMAIL2,EMAIL3,PHONE1,PHONE2
File data example:
56498,Joe,Smith,123 Main Street,Apt 23,San Francisco,California,94108,joe@gmail.com,,,,
435276,Sally,Thompson,5 Park St,,Chicago,Illinois,60605,,,,,
Do not include segment data in the file.
File names must be in the following format (.csv example):
LiveRamp_<Your_Company_Name>_Addressability_Extension_<MMDDYYYY>.csv
Caution
Do not use special characters or spaces in the file name.
File name example (.csv example):
LiveRamp_BobsAuto_Addressability_Extension_08012019.csv
Upload the file using LiveRamp’s SFTP server, your SFTP server, or our Connect UI. You can also have us pull files from an AWS S3 bucket. See “Getting Your Data Into LiveRamp” for more information.
Caution
If you upload files via LiveRamp's SFTP server, the SFTP server and credentials to use for offline data files are different than the ones you might use to upload Addressability Extension mobile app files. Make sure to use the correct SFTP information.
Tip
Files uploaded to Connect cannot be larger than 500MB and file uploads to Connect cannot be automated. For these reasons, we recommend either uploading via SFTP or having us pull files from an S3 bucket.
To upload files using LiveRamp’s SFTP: Use the credentials provided for you by your technical contact once the privacy review has been completed and follow the instructions in “Upload a File via LiveRamp's SFTP”.
To upload files using your SFTP: Follow the instructions in “Upload a File via Your SFTP”.
To upload files using Connect: Log in to Connect with the credentials provided for you by your LiveRamp representative and then Upload a File via Connect.
After uploading the first file, email the Client Match team at clientmatch@liveramp.com to confirm that you have uploaded a file.
Tip
For future uploads, you do not have to email LiveRamp to confirm that you have uploaded data.