Skip to main content

Clean Room and Question Navigation Guide

Abstract

How to navigate the Clean Room UI and manage questions, including instructions on accessing different sections, configuring settings, and using data analysis features

In the implementation phase, your LiveRamp representative will work with you to configure user accounts, clean rooms, and an initial set of questions that are linked to each clean room.

Overall Steps

This topic provides the following instructions for working with clean rooms and questions:

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.

mceclip0.png

Create a Clean Room

Once you've configured initial data connections, you're ready to create a clean room.

  1. From the LiveRamp Clean Room navigation pane, select Clean RoomsClean Rooms (or click Go to Clean Rooms from the Clean Rooms tile).

  2. Click Create New Clean Room.

    mceclip1.png
  3. Select the type of clean room to create and then click Start.

    Note

    • For walled garden clean rooms, select Hybrid.

    • Your options may vary depending on which clean room types your organization is contracted for.

    Create_CR_Hybrid.png
  4. From the Configuration step, enter or select the following information and then click Next Step:

    Create_CR_Config.png
    • Clean room name

    • Clean room description

    • Start date

    • End date (optional)

      Note

      If you configure an end date, the clean room becomes a read-only clean room after the specified date. No new question runs or datasets can be configured and new partners cannot be added to an expired clean room. You can reactivate an expired clean room by changing its end date.

    • Cloud: AWS, Azure, or GCP

    • Region: The following regions are available based on the selected cloud:

      • GCP: US, APAC, or EU

      • AWS: US or UAE

  5. From the Parameters step, adjust the data control parameters as desired to enable additional layers of privacy protection to your query outputs (which are typically based on the privacy tolerance of your organization):

    Create_CR_DataControlParameters.png
    • Data Decibel: Configure the level of noise to prevent identifying an individual or consumer. Noise is configured at a clean room level and applied to specific measures that will be determined during the question creation process.

    • Crowd Size: Configure the k-minimum value, or the threshold that must be achieved by a specific measure in the query in order for it to display results. If the number of users is less than this value, the row of data in the query result is redacted.

    Note

    For more information on these parameters, see "Privacy-Preserving Techniques and Clean Room Results."

  6. If desired, enable additional parameters by sliding the appropriate toggle to the right:

    • Enable Intelligence

    • Enable Exports

  7. Click Next Step.

  8. From the Question Permission step, define what partners can do on questions within the clean room. You can override these permissions for each question at any time.

    Create_CR_Question_Permissions.png

    Note

    To learn more about question permissions and how to override them, see "Question Permissions and Overrides".

  9. Click Next Step.

  10. Confirm your clean room configuration settings and click Save.

Now you're ready to enable an existing question in the clean room or create a new question with the Question Builder.

Open an Existing Clean Room

Procedure. To access your configured clean rooms:
  1. Go to Clean Rooms → View Clean Rooms or select Go to Clean Rooms from the Clean Rooms tile.

    mceclip0.png

    The Clean Rooms page displays any configured clean rooms.

  2. Select Details to enter a clean room.

    mceclip2.png

Clean Room Questions

Once you've entered the clean room, you can see all available questions for that specific clean room.

Depending on your permissions, the following question-level actions can be taken from the Questions page:

  • New Question: Click New Question to open Question Builder.

  • Report: From the Report list, click Create New Report, Schedule Runs, or View Reports to see all question runs and outputs. If you have Clean Room Intelligence enabled, it can also be accessed from this list.

  • Extended Menu: Next to the Report list, select the additional menu icon to clone the question (if permissions are enabled) or delete a question from the clean room.

  • Manage Datasets: Add datasets to a question and assign ownership if you are a clean room owner or to assign your dataset types if you are a clean room partner. If datasets have not yet been configured, an i icon is. A green checkmark icon is displayed if datasets are already configured.

mceclip3.png

For information about questions, see "Question Builder".

Schedule Runs

You can use the Schedule Runs option to automate the creation of question runs instead of manually creating each run. If scheduled runs are not available for your organization, contact your LiveRamp representative.

Procedure. To create a scheduled run:
  1. Click Report next to a question and then select Schedule Runs.

    image idm357
  2. Click New Scheduled Run.

  3. Enter a name for the run.

  4. Select the frequency the reports should generate (daily, weekly, monthly).

    • When selecting Weekly, you can then select which days of the week the report should run under Every.

    • When selecting Monthly, you can then select the specific days the report should run each month under Every.

  5. Select a start date. This is when the scheduled runs will begin generating. If needed, select an end date. Otherwise, scheduled runs will continue generating indefinitely.

    For example, if you want to run weekly automated reports throughout the last quarter of the year, select October 1 as the Schedule Start Date and December 31 as the Schedule End Date. This means reports will populate weekly on the specified days beginning on October 1 and will no longer automatically run after December 31.

    image idm362
  6. In the "Parameters" section, select the interval type:

    • Days: Select the relative date (number of days prior to the run date) or a fixed date for the start and end date that the report output should reflect.

      For example, when using relative date, if you want to receive weekly automated reports on Sundays that populate data for the previous week (such as Monday through Saturday), the number of days before the run date should be 8 days for the start date and 1 day for the end date.

    • Months: Select the number of previous months each report output should reflect. In Question Builder, the query must have the @START_DATE and @END_DATE data parameters enabled in order to schedule runs by Month.

  7. If your question has additional run-time parameters, the name of each parameter will populate with an open field. Enter the run-time parameters applicable to your scheduled run.

    image idm367
  8. At the bottom of the New Scheduled Run page, the run schedule will populate based on how you've configured the schedule. This shows you the exact dates when runs will occur. Clicking See Details will show the run-time parameters that will be applied on a given day's run, including the run dates that will be reflected in each run output.

    image idm372
  9. Click Save.

Using Date Parameters

If you do not enable date parameters in the question you are scheduling, the run automatically occurs on the schedule you selected and includes data available from the database in the run results.

If you do have date parameters enabled in your query, there are two ways you can further refine the schedule for your question runs:

  • Relative Date: Select the number of days prior to the scheduled run that run results will generate. For example, if you want each run to include the previous 7 days of data, enter ‘8’ in the first box and ‘1’ in the second box.

  • Fixed Date: Select the date that the results should populate data from. For example, if you enter January 1, 2025, each scheduled run will populate data from January 1, 2025, until the scheduled run date.

Create a Question Run

Selecting View Reports next to a question will populate the list of question runs for that question.

The following question run-level actions can be taken from the Question Runs page:

  • Add New Report: Create a new question run.

  • View Report: See the visualization for a specific run.

  • Delete: Delete a question run.

mceclip5.png

Consider the following when creating a question run:

  • Run-time parameters may differ per question and contain different attributes beyond dates.

  • Run dates should typically span one month or more for optimal results and alignment with planning and optimization use cases.

  • If you have an industry clean room (ADH, AMC, or FAA), question runs should not be run multiple times for the same date range to avoid differential privacy according to each industry clean room's requirements.

Procedure. To create a question run:
  1. From the Question Runs screen, click Add New Report.

    mceclip6.png
  2. Enter a name for the question run and the run-time parameters (dates) you want.

    mceclip7.png
  3. Click Save. The run will display in Queued status, followed by Running, and then Completed.

  4. Once the run completes, click View Report to see the associated insights.

    mceclip8.png

    Visualizations include a chart view and a table view.

  5. In the "Page Settings" section, you can do the following:

    • Question: Switch between questions within the clean room you are in.

    • Question Run: Switch between runs for the question being viewed.

    • Question-Specific Filters: Filter the question results by different dimensions, which differ by question and use case.

  6. To download the results as a CSV file, click Download CSV.

    mceclip9.png

If your organization has access to LiveRamp Clean Room Intelligence, you can access its visualizations. For more information, see "Visualizations and Analysis".