Formatting Identifiers

When Formatting File Data, you may include as many plaintext postal addresses per individual as you know, but if you have multiple addresses for the same person, place each on a separate row along with the same "first name" and "last name" info (but segment data values do not need to be duplicated/included on those additional rows).

Each of the elements listed below is required for name and postal address identifiers, and each element must be in a separate column:

LiveRamp accepts plaintext and SHA-1 hashed phone numbers (see "Hashing Phone Numbers" below for more information).

You may include as many phone numbers per individual as you know. Place all phone numbers for the same person in the same row, with each phone number in its own distinctly-labeled column. This minimizes file size and ensures there are not conflicting segment values tied to the same identifier.

Use one of the allowed formats listed below:

LiveRamp accepts plaintext and SHA-256, MD5, or SHA-1 hashed email addresses (see "Hashing Email Addresses" below for more information on performing hashes).

You may include as many email addresses per individual as you know. Place all email addresses for the same person in the same row, with each email address in its own distinctly-labeled column. This minimizes file size and ensures there are not conflicting segment values tied to the same identifier.

# Import hashing library
import hashlib
# The input email has capital letters and a space at the end.
input_email = "IMeyers@liveramp.com "
# The input email address is downcased and ALL whitespace (not only spaces) is removed.
hashed_email = hashlib.md5(''.join(input_email.lower().split())).hexdigest()

# Load the Digest module
require 'digest'

email_to_hash = 'liveramp@example.com'

# Get the hex-encoded hash value (a.k.a. digest value) of the email address
# after stripping leading and trailing white space and replacing all uppercase
# letters with their lowercase counterparts.
Digest::SHA1.hexdigest(email_to_hash.strip.downcase)
#=> "91ac4ee2ca1782581f12d865a6779eb179f8b22a"

import hashlib

# A phone number in the correct format
input_phone = "4159870604"

# SHA-1 hash the phone number
hashed_phone = hashlib.sha1(input_phone).hexdigest()

When formatting file data before uploading files, do not modify (e.g., by changing casing) cookie values.

LiveRamp accepts the following plaintext or SHA-1 hashed mobile device IDs (see "Hashing Mobile Device IDs" below for more information):

Plaintext mobile device IDs should be downcased and hyphenated. For example: 1f4d256c-1f08-41f6-a108-bbe511de9497.

Plaintext AAIDs ( Android device IDs) and IDFAs ( iOS device IDs) can be included together in the same file. LiveRamp can match off of both IDs at the same time as long as they are in plaintext. All IDs should be in a single mobile device ID column, regardless of whether the ID is an AAID or an IDFA.

LiveRamp accepts plaintext CTV IDs.

When formatting file data before uploading files, do not modify (e.g., by changing casing) custom ID (CID) values.

When formatting file data before uploading files, do not modify RampID values. For example, do not change the case of alphabetical characters.