Skip to main content

Assign Datasets to a Question

Once you've provisioned your datasets to a clean room, you must assign those datasets to any questions in that clean room that need the data from those datasets. 

Questions contain macros as placeholders for the datasets and dataset fields that the question needs to use. When you assign datasets to a question, you specify which actual datasets and fields the question macros should use.

Questions that need datasets assigned have a Datasets status of “Unassigned Data”.

CR-Assign_Dataset_to_Questions-Unassigned_Data_status.png

Note

In some cases, you can only assign datasets that you own.

However, if your partner has provisioned a dataset to the clean room and enabled Partners Can Assign for that dataset, you can assign that dataset to any question on the partner’s behalf. In that case, you’ll see the partner dataset in the Assign Datasets step and can map its fields just like your own datasets.

Partners control this setting when they provision the dataset to the clean room. If you do not see their dataset, they might need to provision it themselves or allow partners to assign it.

Procedure. To assign datasets to a question:

  1. Enter the desired clean room.

  2. From the clean room navigation menu, select Questions to navigate to the Questions page.

  3. In the row for a question that needs datasets assigned, click Assign Datasets.

    Questions-Assign-Datasets-Button.png

    The Manage Datasets wizard displays the dataset macros that are enabled for the question. For information about dataset macros, see "Add a Macro for a Dataset Type".

  4. In the Assign Ownership step, select the organization from the Select Ownership dropdown for each dataset and then click Next.

    Questions-Manage-Datasets-Save_Proceed.png

  5. In the Assign Datasets step, select the appropriate dataset to map to each dataset macro from the dropdown list and then click Next.

    Questions-Assign-Datasets-Step.png

  6. In the Assign Dataset Fields step, select the field values to map to each field macro from the dropdown list and then click Save.

    CR-Assign_Dataset_to_Questions-Assign_Dataset_Fields_step.png

  7. Repeat steps 3 to 6 for any additional questions that need datasets assigned.

The status in the Datasets column changes to “Ready” and your question is now ready to be run.

mceclip9.png

Note

At times you might need to assign a different dataset or different dataset fields to a question. However, do not change any assignments when the question is in either the “Queued” or “Running” status.

In this section: