For Match Partners: Uploading Consumer Opt-Out Files
The California Consumer Privacy Act (CCPA) is a data privacy law that applies to businesses which collect personal information from California residents. The law went into effect on January 1, 2020.
Under CCPA, if a business, such as a LiveRamp match partner who sends us hashed emails tied to cookie IDs, receives an opt-out from a consumer, it needs to:
Stop selling data associated with the consumer
Pass the opt-outs downstream to partners who bought this data
Match partners can send us opt-out data (hashed email addresses of opted-out consumers) in the form of batch files.
Note
This only applies to explicit consumer opt-outs, and not to “do not track” or “limit ad tracking” signals from the device or operating system.
To send consumer opt-out data to LiveRamp:
Format the file.
Test your hash function.
Name the file.
Upload the file via SFTP.
Tip
The SLAs for CCPA opt-outs are 15 days, so it’s best practice to send us these opt-out files at a minimum of twice per month.
Create a file that follows the guidelines listed below:
Deliver files in .psv (pipe separated value) format, gzipped, with unix line endings.
Include all of the columns listed in the table below.
Provide all three hash types for email addresses. Make sure all email addresses are lowercased and all whitespace is removed before hashing.
Remove any duplicate records from your file.
Column | Header Label | Definition | Example |
|---|---|---|---|
MD5 Hash | md5_hash | Email address using MD5 hashing. | a010407ea27f6a9ccc70e5d149a7818f |
SHA-1 Hash | sha1_hash | Email address using SHA-1 hashing | 3b31875f46abd81fb6c003d7a84492f6ef1b2d5e |
SHA-256 Hash | sha256_hash | Email address using SHA-256 hashing. | 7f0098da19b0f540dbcde477f969fec3e4d8b40f6d1686c6b24d4c2aaea48fea |
Opted-Out | opted-out | “1” indicates that the user has explicitly opted out. | 1 |
File Examples
Here is an example of what a populated row might look like:
3cb7232fcc48743000cb86d0d5022bd9|790d12777b2a83253a14c748a1b1cb09b3a91cca| 899d3387a5c5a7555d51d2f0a0b7b50e397fe481fd9a58fafb389b7dc94e11f6|1
Ensure all email addresses meet the requirements below before hashing:
The hash input is a valid, non-empty email address.
The email address is lowercased.
Any whitespace or extra text is removed from the beginning and end of the email address.
Caution
For privacy reasons, LiveRamp does not accept raw (plaintext) email addresses from match partners.
Hash the email address ‘Test@Foo.com’ to verify that your hash function is working properly. ‘Test@Foo.com’ should produce the following alphanumeric strings:
MD5: 3cb7232fcc48743000cb86d0d5022bd9
SHA-1: 790d12777b2a83253a14c748a1b1cb09b3a91cca
SHA-256: 899d3387a5c5a7555d51d2f0a0b7b50e397fe481fd9a58fafb389b7dc94e11f6
Name your file using the exact naming syntax below.
web_match_{TIMESTAMP}.psv.gz
Caution
Files will be rejected from our servers if a different syntax is used.
"{TIMESTAMP}" = date and time on the Internet in RFC 3339 timestamp standard.
An example file name might look like this:
web_match_2015-10-28T15:04:05.psv.gz
Renaming a File for Re-Upload
A LiveRamp account manager may ask you to re-upload a file if the first upload fails. When you re-upload a file, be sure to give it a unique name. Once we process a file successfully, we will not reprocess another one with the same name even if it is modified.
For example, if you re-upload a file called "web_match_2015-11-02T09:07:15.psv.gz", change the name to "web_match_2015-11-02T09:07:15_part02.psv.gz."
Upload your files a minimum of twice per month to comply with the requirements of the CCPA. Use your SFTP credentials and the information below to upload the file via SFTP.
Caution
The SFTP server and credentials to use for match partner mobile app files are different than the ones for the LiveRamp SFTP server you might use to upload other LiveRamp files. Make sure to use the correct SFTP information.
We recommend using the open source client “Cyberduck”.
Server: sftp.pippio.com
Port: 4222
Note
If you do not have credentials for this SFTP server, email the Match Network team at publisher-success@liveramp.com for assistance.