Skip to main content

Required File Format for Simple Onboard Files

Simple Onboard is a quick and easy way to upload your PII-based data for onboarding with LiveRamp. See “Onboarding Data with Simple Onboard” for more information.

To enable LiveRamp to process your data quickly, Simple Onboard has specific file formatting requirements that must be met:

Warning

Files that do not meet these requirements will be automatically rejected when uploaded. See “Troubleshooting Simple Onboard File Upload Errors” for more information.

  • Files must be 500MB or smaller

  • Files must not contain any fields other than the allowed PII identifier fields listed below, and the file must be named with the name of the segment to be created (file-wide fields only)

  • Files must be column-based and comma-delimited (.csv)

  • Files must contain a header row, with only the allowed header labels listed below

  • If files are compressed (compressing is optional), they must be compressed with gzip (.gz)

  • Files must not be encrypted, as this would not allow us to immediately ingest the file and create a new segment for distribution

  • Unless otherwise superseded by stricter requirements above, files must follow standard LiveRamp file formatting requirements, including the guidelines listed in "Naming Files for Uploading."

Once you’ve made sure that your file is formatted correctly, follow the workflow steps in “Onboarding Data with Simple Onboard”.

Allowed PII Identifier Types for Simple Onboard Files

Any combination of the following types of PII identifiers can be included in the file, up to the allowed quantity indicated:

Identifier Type

Format(s) Accepted

Allowed Quantity

Name and postal addresses (NAP)

Plaintext

1

Email addresses

Plaintext

Up to 3

MD5 hash

Up to 3

SHA-1 hash

Up to 3

SHA-256 hash

Up to 3

Phone numbers

Plaintext

Up to 3

SHA-1 hash

Up to 3

The header labels listed below are the only allowed header labels that can be included in the file, with the following guidelines:

  • Match the casing and capitalization of these header labels

  • Do not include headers for unused/empty fields

These sample files can be used as a reference:

Field Type

Allowed Headers

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