Skip to main content

Clean Room Partner Implementation Guide

LiveRamp Clean Room can generate analytics from controlled datasets while protecting the privacy of consumers and the rights of data owners. This includes enabling partner collaboration in a secure, privacy-first manner through the management of governed join and compute across major cloud environments.

As a partner, this guide shares how to get up and running quickly with LiveRamp Clean Room, including accessing an invite-only clean room, configuring secure data connections to be used for querying in the clean room, and consuming invites generated from those queries.

LiveRamp Clean Room Overview

A clean room is a secure environment that enables data collaboration across decentralized datasets to help uncover actionable insights and outcomes.

image idm649

LiveRamp Clean Room enables the creation and ongoing support of clean room collaborations through a user-friendly interface.

Included in LiveRamp Clean Room's architecture are three core layers:

image idm654
  • The Integration Layer, where we integrate with cloud and media ecosystems to access data at its source. This layer provides foundational support for use cases ranging from reporting insights to user list creation, complex modeling, and more.

  • The Application Layer, which enables teams to automate dataset workflows and define and enforce governance rules and privacy controls for multi-party collaborations.

  • The Intelligence Layer , where analytics and insights can be templatized, visualized, and automated.

LiveRamp Clean Room's architecture lays the foundation for LiveRamp Clean Room's question framework, which drives insights consumed from clean room outputs.

mceclip0.png

Key Terminology

The following terminology will help you get up to speed on navigating the LiveRamp Clean Room UI:

  • Clean room: Secure, protected environment that allows multiple parties to bring data together for joint analysis in a privacy-compliant way.

  • Data connection: Used to access data at its source to minimize data movement.

  • Question: A business question in the form of an SQL query that can be reused for various runs or run-time parameters.

  • Question run: Question processing based on run-time parameters, such as dates and attributes.

  • Insights: Visualizations of question run results based on run-time parameters.

Roles and Responsibilities

As a partner collaborating in a clean room, there are several important steps required to properly onboard your data, often requiring members of key teams across your organization. Collaborations work best when people are aligned to roles across the clean room partner, clean room owner, and LiveRamp.

To get started, identify people in your organization that align best with the following clean room partner roles shown in the table below.

Roles

Responsibilities

Clean Room Partner

Account and Organization Admins

  • Clean room super-user administrator on behalf of partner

  • Creates users within LiveRamp Clean Room for colleagues; decides permission access tiers

  • Coordinates with IT to get the right data connections set up and configured

  • Advises the Marketing and Analytics teams on running reports within LiveRamp Clean Room

IT / Data Team

  • Supplies the credentials to the source system being integrated and provides context on the data itself, such as cloud, region, entity ID, and taxonomy.

Marketing / Marketing Analytics

  • Uses reports to enhance marketing and media performance

Account and Organization Admins

  • Supports onboarding process

  • Provides advisory support in analyzing query results

  • Consults on leveraging clean room analyses to answer key business questions

LiveRamp

Client Success Manager

  • Your LiveRamp business owner who will guide you through the LiveRamp Clean Room process and help you gain value out of the product

Technical Solutions Manager

  • Technical owner in charge of implementation, ongoing technical support and troubleshooting

Accepting a Clean Room Invitation

Facilitating clean room collaborations requires owners to invite partners to a clean room in order to combine and analyze data sources from multiple parties.

You will receive an email invite from a clean room owner. If you already have access to LiveRamp Clean Room, you can accept the invite and access your organization and clean room. If you do not have access, a LiveRamp Clean Room organization will be created for you to proceed with the configuration and accept the clean room invitation.

There may be a delay between when you receive a clean room invitation and when an organization is provisioned for you.

Enabling Users and Permissions

Once your organization has been created and you log in as the account admin, you can begin by setting up roles and adding users. Roles are the different combinations of access permissions you can create and assign individual users to. When you create users, you must assign them to a role.

Each newly created user will receive a welcome email to log in. Their access level will mirror the role you have assigned them.

Adding users to an organization does not mean these users have access to a configured clean room. Adding users to a clean room is a separate step.

When you access the clean room from your organization as the invitee, you will automatically have partner admin access to the clean room. This clean room-level role enables you to configure new roles and add users to the clean room. Before adding users to a clean room, they should first be added as users to your organization. For information, see "Managing Users" and "Managing Clean Room Permissions".

Data Preparation and Readiness

Before configuring your data sources in LiveRamp Clean Room, confirm you have the required datasets ready for use according to the collaboration use case with the clean room owner. Knowing where your datasets live, the credentials and tables required to access those datasets, and having the proper file formatting in place will make the remainder of your setup much more seamless.

Depending on where your data resides, the corresponding articles below will help you identify and prepare the necessary details.

Configuring Data Source Credentials and Data Connections in Your Organization

At the core of LiveRamp Clean Room's application layer are data connections, which are the datasets that power business queries and insights. LiveRamp Clean Room is cloud agnostic, meaning we support data stored in any cloud, including the major clouds - Snowflake, Databricks, Amazon AWS, Google Cloud Storage, and Microsoft Azure.

In this step, you will set up your credentials and data connections so LiveRamp knows what data you are making available for a clean room collaboration.

Depending on where you store your data, the data connection configuration steps will differ. Each cloud configuration has its own set of prerequisites. It is important to review and complete any prerequisites in order to successfully set up your credentials and data connections. Select which source you are using for more information:

Cloud Data Source

Configuration Guide Links

Snowflake Pattern

Identify Snowflake Account Information

Install Snowflake CLI Framework

Configure a Snowflake Pattern Data Connection

Snowflake Hybrid

Hybrid clean room using Snowflake as the data source

Configure a Snowflake Hybrid Data Connection

Databricks Pattern

Install Databricks CLI Framework

Configure a Databricks Pattern Data Connection

Amazon AWS

Customer-hosted AWS

LiveRamp-hosted AWS

Google Cloud Storage

Customer-hosted GCS

LiveRamp-hosted GCS

Microsoft Azure

Configure an Azure Data Connection

CSV Upload

Alternative to clouds; direct file upload

CSV Upload

Provision a Dataset to a Clean Room

Once you've created a clean room (or accepted an invitation to a partner clean room), any datasets from the data connections that you've configured at the organization level can be provisioned to the clean room.

During provisioning, you can configure the dataset so that only certain fields or field values are queryable. You can also create new fields by applying a transformation to an existing field or fields.

Once you've provisioned a dataset to the clean room, you can then apply the dataset to any clean room questions. This ensures security and privacy are respected within each step of the collaboration.

Procedure. To provision a dataset to a clean room:
  1. Enter the desired clean room.

  2. From the clean room navigation menu, select Datasets (if necessary).

    LCR-Clean_Room_menu-Datasets_menu_selection.png
  3. From the row for the desired dataset, click Provision.

    mceclip0.png
  4. From the Configure tab of the Provision Dataset page, slide the "Include" toggle to the left for the specific fields that you do not want to be queryable for the clean room use case (by default, all fields are queryable).

    LCR-Provision_Dataset_to_Clean_Room-Include_toggle.png
  5. To rename a field, use the Rename column to enter the new field name you want to use.

    LCR-Provision_Dataset_to_Clean_Room-rename_field.png
  6. To filter a field so that only specific values within that field are queryable, select from the list of operators (Equals, Not Equals, In, Not In) and manually input your filter values (separate multiple values with commas) corresponding to the selected field.

    LCR-Provision_Dataset_to_Clean_Room-filter_values.png
  7. To apply data transformations to a dataset, click New Field and follow the instructions in "Perform Dataset Transformations".

    LCR-Provision_Dataset_to_Clean_Room-New_Field_button.png
  8. Click Save.

The dataset appears with a green checkmark once successfully configured.

mceclip2.png

Repeat this process for each dataset you want to provision to the clean room.

After you've provisioned all the necessary datasets to the clean room, you can assign datasets to questions.

To set analysis rules for a dataset, see the instructions in "Set Dataset Analysis Rules".

If you want to allow partners in this clean room to assign any datasets on your behalf, slide the "Partners Can Assign" toggle to the right for those datasets.

Note

This gives your partners complete authority to run questions against the dataset, so you should only enable this if you are not sensitive about which queries are run against the data.

Configure Datasets for Questions

Procedure. To configure datasets for questions:
  1. From the Clean Room menu, select Questions. Click Manage Datasets next to the question. The clean room owner datasets that are enabled for that question are displayed.

    mceclip4.png
  2. Select your organization name from the list for the dataset types and click Save & Proceed.

    mceclip5.png
  3. For your dataset type, select the corresponding dataset from the list and click Save.

    mceclip8.png

    Your dataset is now enabled for clean room collaboration.

    mceclip9.png

Authoring Questions in a Clean Room

If the clean room owner has provided you with Question Builder access, you can author new queries for use in the clean room. For information, see "Question Builder".