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:

  1. Emails
  2. Phone numbers
  3. 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