Skip to main content

File Formatting Examples and Templates

See the file formatting examples below, as well as the following articles, for information on how to properly format files and the common errors to avoid.

Note

  • Want a template? You can download (and modify, if desired) the file examples below and use them as templates for your files.

  • When creating data files for EMEA countries (countries in Europe, the Middle East and Africa, such as the United Kingdom, France, or Germany), be sure to follow the instructions in "Creating Data Files for EMEA Countries" and the example shown in "Examples of EMEA Data Files" below.

Examples of Column-Based Segment Data Files

LiveRamp prefers and recommends that you provide column-based files, particularly when there is more than one identifier field (this will typically be PII-based data with a name and postal address, multiple email addresses, or some combination thereof). See "Formatting Column-Based Files" for more information.

Single Identifier File

Simple column-based file with one PII identifier (for example, name and postal). Some fields are intentionally left empty to illustrate proper no-fill of those values. No values contain punctuation so there is no need to use quotation marks.

File Example Good Column-PeE.jpg

Download the Column-Based Single Identifier example file template

Single Identifier Column-Based File Example Enclosed with Quotation Marks

Similar to the above example, but with an additional identifier (email) and a new field, "PreviousCity", that contains a comma within the values and so is enclosed with quotation marks. Note that the delimiter commas remain outside the quotation marks.

File Example Good Column Quotes-nAU.jpg

Download the Column-Based File With Quotation Marks example file template (open with a text editor to see the quotation marks)

Common Column-Based File Errors Example

This file contains a number of typical file formatting errors:

File Example Bad Columns-kEc.jpg
  1. The header row contains two columns with the same label ("Email").

  2. The first field of the postal address is simply "Name", rather than having individual fields for "FirstName" and "LastName".

  3. There is an extra comma after what should be the final field ("San Francisco, CA"), making the file non-rectangular.

  4. The email address "john.dough@email.com" incorrectly has the comma delimiter inside the quotation marks.

  5. The address "555 New Rd Apt 2" has a newline character after "Rd", which has caused this row to abruptly end partway through and pick up on the next row.

  6. "Rochester, NY" is not enclosed in quotation marks, adding an extra field of " NY" due to delimiter collision and making the file non-rectangular.

  7. The "Under25" field value is "NULL" rather than being left empty.

Download the Column-Based File Errors Example File

Examples of Key-Value Segment Data Files

Key-value files are often best suited for files with only one identifier field (this will typically be data tied to a device identifier such as cookies, or PII-based data tied only to a single email address or phone number). See "Formatting Key-Value Files" for more information.

Single Identifier Key-Value File Example

Simple key-value file with a single identifier in the first column, suitable for device-based data tied to a cookie, mobile device ID, or similar. PII-based data tied to a single email or phone number could also be formatted this way. Not all rows have values for every key, so those keys are not included in those rows.

File Example Good No Quotes Key Value-_vg.jpg

Download the Key-Value File Single Identifier Example file template

Single Identifier Key-Value File Enclosed with Quotation Marks Example

Similar to the above example, but with a new field, "PreviousCity", that contains a comma and so therefore keys and values are enclosed with quotation marks. Note that the equals signs and delimiter commas remain outside the quotation marks.

File Example Good Quotes Key Value-paA.jpg

Download the Key-Value File With Quotation Marks Example file template

Common Key-Value File Errors Example

This file contains a number of typical file formatting errors:

File Example Bad Key Value-rsY.jpg
  1. "San Francisco, CA" is not enclosed in quotation marks, so the value for "PreviousCity" will be interpreted as "San Francisco."

  2. The identifier appears to have been hashed, while the identifiers in other columns are plaintext.

  3. All the key-value pairs including the equals sign are completely enclosed by quotation marks rather than each individual key and value enquoted separately.

  4. The key "Under25" is set to equal no value and should have not been included at all.

  5. Colons rather than equals signs have been used to separate keys and values.

Download the Key-Value File Errors Example File

Note

See "Uploading Data" for an overview of the file creation and formatting process.

Examples of EMEA Data Files

For EMEA countries (countries in Europe, the Middle East and Africa, such as the United Kingdom, France, or Germany), only column-based, offline data files are allowed. For additional information, see "Creating Data Files for EMEA Countries".

Offline Data Column-Based File Example

Column-based file with all possible PII columns. Some fields are intentionally left empty to illustrate proper no fill of those values. No values contain punctuation so there is no need to use quotation marks.

C-EMEA_File_Example.png

Download the Offline Data Column-Based File Example template

Common EMEA Data File Errors Example

This file contains a number of typical file formatting errors:

C-EMEA_File_Errors.png
  1. The column that should be listed as "FIRSTNAME" is included as "NAME".

  2. There is an extra comma, which makes the file non-rectangular.

  3. The field value is entered as "NULL" rather than being left empty.

  4. The comma delimiter is inside the quotation marks, instead of outside the quotation marks.

  5. There's an extra comma after what should be the final field, making the file non-rectangular.

  6. The address and postcode are missing, so no match can be made based only on first name and last name.

  7. The column that should be listed as "TOWN" is included as "CITY".