Using Google PAIR with Snowflake Data Clean Rooms

This topic describes the steps the publisher and advertiser must take to use Google PAIR to activate results of the advertiser’s analysis to their Google DV 360 account.

Important

At this time, Snowflake Data Clean Rooms do not support data subject consent management. Please ensure you are complying with applicable laws and regulations when using Snowflake Data Clean Rooms, including in connection with third-party connectors for activation purposes.

Publisher

The publisher must do the following:

  1. Create a clean room that encrypts identifying columns with Google PAIR, then share the clean room with the advertiser. (in this topic)

  2. Provide the encrypted PAIR IDs in the bid request sent to an SSP. (in this topic)

Create and share a clean room

  1. Sign in to your clean room environment in the web app.

  2. In the left navigation, select Clean Rooms.

  3. Select + Clean Room.

  4. Use the Add Data step to name the clean room and select the tables that are being shared with the advertiser, then select Next.

  5. Expand the Identity Hub section, and select PAIR.

  6. In the PAIR Join Columns section, select the identifier columns that you want to encrypt with Google PAIR.

    For each column selected, the clean room adds a new column to the table. It names these new columns by appending _PAIR to the original column name.

  7. Select Generate Preview. You can see the name of the new column.

  8. Select Add Identity.

  9. In the Join Policies section, select the PAIR columns so they can be matched with the PAIR columns of the advertiser.

  10. Select Next.

  11. Complete the fields for the Audience Overlap & Segmentation template. Do not set the Threshold Value below 1000.

  12. Select Next.

  13. Use the Select Collaborator to select the advertiser, and then select Finish.

Send a bid request

As a publisher, you need to include the encrypted PAIR IDs in your bid request. Best practice is to maintain a URL safe format and use Base64 encoding when providing these IDs within the bid request.

To obtain the PAIR IDs, you need to access your Snowflake account and run the following commands in a worksheet:

-- Find the UUID of the clean room
SELECT * FROM samooha_by_snowflake_local_db.public.cleanroom_record;

-- Replace <uuid> with the UUID of the clean room to find the tables that contain the PAIR IDs
-- Names of tables with PAIR IDs are appended with _PAIR
DESCRIBE SCHEMA samooha_cleanroom_<uuid>.shared_schema;

-- Query the table with PAIR IDs
SELECT * samooha_cleanroom_<uuid>.shared_schema.<tablename_PAIR>;
Copy

Advertiser

The advertiser must do the following:

  1. Configure their Google DV 360 account to link to Snowflake Data Clean Rooms. For instructions, see the Google DV 360 documentation.

  2. Configure their clean room environment to leverage the Google DV 360 connector.

  3. Install the clean room so it is PAIR-enabled. (in this topic)

  4. Activate the results of their analysis to their Google DV 360 account. (in this topic)

Install clean room

  1. Sign in to your clean room environment in the web app.

  2. In the left navigation, select Clean Rooms.

  3. On the Invited tab, find the clean room and select Join.

  4. Select the tables that you want to include in the clean room, and then select Next.

  5. Expand the Identity Hub section, and select PAIR.

  6. In the PAIR Join Columns section, select the identifier columns that you want to encrypt with Google PAIR.

    For each column selected, the clean room adds a new column to the table. It names these new columns by appending _PAIR to the original column name.

  7. Select Generate Preview to see the name of the new column.

  8. Select Add Identity.

  9. Use the Join Policies section to match your PAIR columns to the corresponding PAIR columns of the publisher, and then define any additional join policies.

  10. Select Next.

  11. Complete the fields for the Audience Overlap & Segmentation template, and select Finish.

Run analysis and activate results

  1. Sign in to your clean room environment in the web app.

  2. In the left navigation, select Clean Rooms.

  3. On the Joined tab, find the clean room in the list and select Run.

  4. Select Audience Overlap & Segmentation, and then select Proceed.

  5. Run the analysis, using the encrypted PAIR IDs to match records.

  6. In the Results section, select Activate.

  7. Select Google DV 360.

  8. In the Account ID field, select a Google DV 360 account that has been integrated with the clean room environment.

  9. In the Segment Name field, enter a descriptive name for your results.

  10. In the Description field, enter a description of the data you are pushing to Google DV 360 for activation.

  11. In the Publisher Name, enter the name of the publisher you are collaborating with.

  12. Select the PAIR ID columns, and the type of these identifiers.

  13. Select Push Data.

Language: English