Snowflake Data Clean Rooms: Activation connectors¶

You must be a DCR administrator to configure this connector.

To configure the connector so that your clean environment is integrated with your Google Ads account:

1. In the left navigation of the web app, select Connectors.

2. Select the Activation tab.

3. Expand Google Ads.

4. Enter your Google credentials.

5. In the Account ID field, enter the ID associated with your Google Ads account.

6. Specify your API preference. If you select My Developer Token, enter your developer token for the Google Ads API.

7. Select Save.

See the user guide tab to learn how to activate results using this connector.

Here is how to activate analysis results with Google Ads. These instructions assume that this connector has been properly installed and configured by a DCR administrator.

To push the results of an analysis to Google Ads for activation:

1. Run an analysis that returns data that can be activated. For example, analyses using the Audience Overlap & Segmentation template can be activated.

   For more information about running an analysis, see Run an analysis as a provider or Run an analysis as a consumer.

2. In the Results section, select Activate.

3. In the Activation Hub dialog, select Google Ads.

4. In the Account ID field, enter the identifier for the account where you want to push the segment.

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

6. In the Description field, enter a description of the data you are pushing to Google Ads.

7. In the Activation IDs section, select the columns that contain hashed email and/or hashed phone identifiers.

8. Select Push Data.

You must be a DCR administrator to configure this connector.

To integrate your clean room environment with Google DV360-PAIR, you must configure this connector as follows:

1. Before configuring the connector, link your account ID in Google DV360 to CMU: Snowflake.

2. In the left navigation of the web app, select Connectors.

3. Select the Activation tab.

4. Expand Google DV360.

5. In the Account ID field, enter the account ID of your Google DV360-PAIR account. Contact Snowflake support for the correct data partner account ID for your clean room.

6. In the Account Type field, enter the type of your Google DV360-PAIR account.

7. If you want Snowflake’s data clean room users to be able to activate results to multiple Google DV360-PAIR accounts, select + Account and enter the new account ID and account type for an additional account. Contact Snowflake support for the correct data partner account ID for your clean room.

8. Select Save.

See the user guide tab to learn how to activate results using this connector.

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. This connector must first be properly installed and configured by a DCR administrator.

When using Google Display & Video 360-PAIR, the publisher is always the provider, and the advertiser is always the consumer.

Publisher

The publisher must take the following steps to use Google PAIR in a clean room:

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

2. Install and configure the Google Display & Video 360-PAIR connector as described in the configuration guide tab.

3. Create a clean room that encrypts identifying columns with Google PAIR, then share the clean room with the advertiser (described below).

4. Provide the encrypted PAIR IDs in the bid request sent to an SSP (described below).

Publisher: 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, then select Finish.

Publisher: 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 take the following steps to enable Google PAIR in a clean room:

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

2. Install and configure the Google Display & Video 360-PAIR connector as described in the configuration guide tab.

3. Install the clean room so it is PAIR-enabled (described below).

4. Activate the results of their analysis to their Google DV 360 account (described below).

Advertiser: Join a 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.

Advertiser: Run the 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.

You must be a DCR administrator to configure this connector.

To configure the connector so that your clean environment is integrated with your LiveRamp account:

1. In the left navigation of the web app, select Connectors.

2. Select the Activation tab.

3. Expand LiveRamp.

4. Use the Select Upload Type drop-down list to do one of the following:

   • If you want to share data with LiveRamp using SFTP:

     1. Select SFTP.

     2. Enter the username and password provided by LiveRamp for the purpose of using their SFTP.

   • If you want to share data with LiveRamp using Snowflake data sharing:

     1. Select Snowflake Share.

     2. Use the Account drop-down to select the LiveRamp Snowflake account.

     3. Select Generate Share.

     4. Send your LiveRamp representative the name of your account and the generated share.

5. Select Authenticate.

See the user guide tab to learn how to activate results using this connector.

Here is how to activate analysis results with the LiveRamp connector. These instructions assume that this connector has been properly installed and configured by a DCR administrator.

To push the results of an analysis to LiveRamp for activation:

1. Run an analysis that returns data that can be activated. For example, analyses using the Audience Overlap & Segmentation template can be activated.

   For more information about running an analysis, see Run an analysis as a provider or Run an analysis as a consumer.

2. In the Results section, select Activate.

3. In the Activation Hub dialog, select LiveRamp.

4. In the Segment Name field, enter a descriptive name for your results. This name must start with a letter, and can contain only letters, numbers, and underscores.

   The string _SNOWDCR will be appended to this name.

5. In the RampID drop down, select the column from your table that contains your RampID.

6. Select Push Data.

You must be a DCR administrator to configure this connector.

To configure the connector so that your clean environment is integrated with your Meta Ads Manager account:

1. In the left navigation of the web app, select Connectors.

2. Select the Activation tab.

3. Expand Meta Ads Manager.

4. Enter your Meta Business Manager credentials.

5. In the Meta Ads Manager Account ID field, enter the ID of your Meta Ads Manager account.

6. Select Save.

See the user guide tab to learn how to activate results using this connector.

These instructions assume that this connector has been properly installed and configured by a DCR administrator.

To push the results of an analysis to Meta Ads Manager for activation:

1. Run an analysis that returns data that can be activated. For example, analyses using the Audience Overlap & Segmentation template can be activated.

   For more information about running an analysis, see Run an analysis as a provider or Run an analysis as a consumer.

2. In the Results section, select Activate.

3. In the Activation Hub dialog, select Meta Ads Manager.

4. In the Account ID field, enter the identifier for the account where you want to push the segment.

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

6. In the Description field, enter a description of the data you are pushing to Google Ads.

7. In the Activation IDs section, select the columns that contain identifiers, then select the type of those identifiers.

8. Select Push Data.

You must be a DCR administrator to configure this connector.

To configure the connector so that your clean room environment is integrated with your account with The Trade Desk - CRM:

1. In the left navigation of the web app, select Connectors.

2. Select the Activation tab.

3. Expand The Trade Desk - CRM.

4. In the Username field, enter the username associated with your account with The Trade Desk.

5. In the Password field, enter the password your account with The Trade Desk.

6. In the Advertiser ID field, enter the advertiser ID associated with your account with The Trade Desk.

7. In the Region field, select the region of your The Trade Desk account.

8. Select Authenticate.

See the user guide tab to learn how to activate results using this connector.

These instructions assume that this connector has been properly installed and configured by a DCR administrator.

To push the results of an analysis to The Trade Desk - CRM for activation:

1. Run an analysis that returns data that can be activated. For example, analyses using the Audience Overlap & Segmentation template can be activated.

   For more information about running an analysis, see Run an analysis as a provider or Run an analysis as a consumer.

2. In the Results section, select Activate.

3. In the Activation Hub dialog, select The Trade Desk - CRM.

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

5. In the Activation IDs section, select a column that contains identifiers, then select the type of those identifiers.

6. Select Push Data.

You must be a DCR administrator to configure this connector.

To configure the connector so that your clean room environment is integrated with your account with The Trade Desk - UID 2.0:

1. In the left navigation of the web app, select Connectors.

2. Select the Activation tab.

3. Expand The Trade Desk - UID 2.0.

4. In the Advertiser ID field, enter the advertiser ID associated with your account with The Trade Desk.

5. In the Secret Key field, enter the secret key associated with your account with The Trade Desk.

6. Use the Data Center drop-down list to select a The Trade Desk data center.

7. Select Authenticate.

See the user guide tab to learn how to activate results using this connector.

These instructions assume that this connector has been properly installed and configured by a DCR administrator.

To push the results of an analysis to The Trade Desk - CRM for activation:

1. Run an analysis that returns data that can be activated. For example, analyses using the Audience Overlap & Segmentation template can be activated.

   For more information about running an analysis, see Run an analysis as a provider or Run an analysis as a consumer.

2. In the Results section, select Activate.

3. In the Activation Hub dialog, select The Trade Desk - UID 2.0.

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

5. In the Activation IDs section, select a column that contains identifiers, then select the type of those identifiers.

6. Select Push Data.

You must be a DCR administrator to configure this connector.

To configure the connector so that your clean room environment is integrated with Yahoo DSP:

1. In the left navigation of the web app, select Connectors.

2. Select the Activation tab.

3. Expand Yahoo DSP.

4. Enter the MDM ID associated with your Yahoo account.

5. Select Authenticate.

See the user guide tab to learn how to activate results using this connector.

These instructions assume that this connector has been properly installed and configured by a DCR administrator.

To push the results of an analysis to Yahoo DSP for activation:

1. Run an analysis that returns data that can be activated. For example, analyses using the Audience Overlap & Segmentation template can be activated.

   For more information about running an analysis, see Run an analysis as a provider or Run an analysis as a consumer.

2. In the Results section, select Activate.

3. In the Activation Hub dialog, select Yahoo DSP.

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

5. In the Description field, enter a description of the data you are pushing to Yahoo DSP.

6. In the Activation IDs section, select columns that contains identifiers, then select the type of those identifiers.

7. Select Push Data.