LiveRamp Onboarding: File Format and Header Requirements

Below, we are listing rules that you must follow to ensure that the process works and best practices that optimize the outcome of your onboarding efforts. These rules are also detailed in the following LiveRamp article.

Rules

• The minimum size for your file is 100,000 records.
• If you have a larger file and you are bucketing your records into meaningful segments, each segment must contain at least 100,000 records.
• Follow the Formatting Rules - LiveRamp_Resonate_SampleSheet_03132023.csv
  • LiveRamp can only accept .CSV files
  • Avoid special characters and spaces in the file's name
  • Avoid special characters and spaces in the segments' names
    • Use dashes or underscores to replace spaces
    • e.g. LiveRamp_Resonate_NewVoters_02182016.csv
• LiveRamp Onboarding Data Requirements: At a minimum, you must have the following datasets in order to onboard via LiveRamp: 
  • Physical Address:
    • FIRSTNAME
    • LASTNAME
    • ADDRESS1
    • ADDRESS2
    • CITY
    • STATE
    • ZIP

OR

• • Email Address
• LiveRamp File Formatting Requirements: The bolded column headers below must be in the following order in your file, the non-bolded headers are optional. The bolded columns headers have to be in the file, but not all fields in the columns have to be filled out. Leave fields blank where you cannot supply information. 
  • • CCID (Client Customer ID - see below)
    • FIRSTNAME
    • LASTNAME
    • ADDRESS1 (street address line 1)
    • ADDRESS2 (street address line 2)
    • CITY
    • STATE
    • ZIP (ZIP Code)
    • EMAIL1
    • EMAIL2
    • EMAIL3
    • PHONE1
    • PHONE2
    • Segment1(ex. HighSpend)
    • Segment2 (ex. MediumSpend)
    • Segment3 (etc.)
• Limit the spreadsheet to 100 columns.
• The first field ("Client Customer ID") is an optional field you can include, which can be 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).
• If included, the entries in this field should be unique and persistent across all audiences.
• If the client doesn’t have any values to be filled in the CCID column, they can fill it with the PII column with the highest fill rate (example email). Contact your LiveRamp representative if you are not using a Client Customer ID to identify records.
• Note that the ZIP Code field can include either standard 5-digit values or 9-digit ZIP+4 values. Do not include hyphens when sending 9-digit ZIP codes.

Best Practices

• Mind the Data Quality: The better the data, the better the match rate
  • Best results: name & mailing address (both are required), and phone number
• Use Segments to bucket your customers
  • e.g. Segments for High Spenders, Medium Spenders, Low Spenders, VIP Customers
• Provide Resonate with a data dictionary that describes each attribute
  • This helps Resonate understand what you're onboarding
  • We can recommend user-friendly names and suggest changes
• Create user-friendly attribute names for your data