LiveRamp File Format
Files uploaded to LiveRamp must be 500MB or smaller and a CSV, TSV or TXT with no spaces in the File Name. There are 3 types of PII that can be uploaded:
- Emails
- Phone numbers
- Name and Postal address
You can include one, two, or all three of these. But if you want to use Name and Postal address you must include all of the columns listed under ‘Name and postal address’ below (full name and full address).
Use the following column headers to identify the type of PII in your file:
Name and postal address:
- FIRSTNAME
- LASTNAME
- ADDRESS1
- ADDRESS2 (optional)
- CITY
- STATE
- ZIP
- ZIP4 (optional)
Plaintext email address:
- EMAIL1
- EMAIL2
- EMAIL3
MD5 hashed email address:
- MD5EMAIL1
- MD5EMAIL2
- MD5EMAIL3
SHA-1 hashed email address:
- SHA1EMAIL1
- SHA1EMAIL2
- SHA1EMAIL3
SHA-256 hashed email address:
- SHA256EMAIL1
- SHA256EMAIL2
- SHA256EMAIL3
Plaintext phone number:
- PHONE1
- PHONE2
- PHONE3
SHA-1 hashed phone number:
- SHA1PHONE1
- SHA1PHONE2
- SHA1PHONE3
Customer ID (used to de-duplicate rows):
- CCID
See a sample 100 rows of fake data here: Sample File