For Offline 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 AbiliTec partner who sends us PII, 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

AbiliTec partners can send us opt-out data (the PII 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.
Name the file.
Upload the file via your existing landing zone.

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.

Format the File

Create a file that follows the guidelines listed below:

Deliver files in ..csv (comma separated value) or .tsv (tab separated value) format, gzipped, with unix line endings.
Include the appropriate columns listed in the table below.
Provide all PII data elements that are represented in the table below that you currently send to LiveRamp.
Remove any duplicate records from your file.
Send one data record for each opted-out consumer, unless you’re sending multiple instances of a particular touchpoint for the consumer. Make sure each extra touchpoint (phone, email address, etc.) for a consumer is included in a new record. See examples below.

Header Label	Definition	Example
FirstName	Consumer’s first name	John
MiddleName	Consumer’s middle name	Joe
LastName	Consumer’s last name	Smith
GenerationalSuffix	Consumer’s name suffix	Jr
StreetNumber	Consumer’s number of street address	15
PreDirectional	Consumer’s Street PreDirectional	W
StreetName	Consumer’s street name	Main
PostDirectional	Consumer’s Street PostDirectional	E
UnitDesignator	Consumer’s Unit Type (Apt, Ste, Flr)	Ste
UnitNumber	Consumer’s Unit/Room Number	1
City	Consumer’s city	San Francisco
State	Consumer’s state	California
ZipCode	Consumer’s zip code	94105
Phone	Consumer’s phone number	5555555555
Email	Consumer’s email address	pippiotest@hotmail.com
DOB	Consumer’s date of birth	19940201
SSN	Consumer’s social security number	555555555

File Examples

Here is an example of a record (row) using the column categories:

FirstName,MiddleName,LastName,Zip,Phone,Email,DOB

Here is an example of what a populated row might look like for a consumer who has multiple addresses, phone numbers, and email addresses:

John,Joseph,Smith,94105,5550102323,pippiotest@hotmail.com,19940201

John,Joseph,Smith,10101,5551213434,pippiotest@aol.com

John,Joseph,Smith,10102,5552324545,pippiotest@yahoo.com,19940201

Name the File

Name your file using the exact naming syntax below.

offline_ccpa_{TIMESTAMP}.csv.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:

offline_ccpa_2020-01-28T15:04:05.csv.gz

Renaming a File for Re-Upload

A LiveRamp account manager may ask you to re-upload a file if the first upload fails due to a large error percentage. 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 "offline_ccpa_2020-01-28T15:04:05.csv.gz", change the name to "offline_ccpa_2020-01-28T15:04:05_part02.csv.gz."

Upload the File

Use your existing landing zone to upload your CCPA opt-out files. Please reach out to your LiveRamp account manager if you have any questions about accessing your existing landing zone.

In this section: