Creating an Interact Performance schema

Use Interact Performance Star Schema to create Interact Performance Schema.

About this task

To create an Interact Performance schema, complete the following steps.


  1. Select Settings > Configuration.
  2. Expand Reports > Schemas > Interact > Interact Performance Star Schema.
  3. In the New category name field, enter a descriptive name for the reporting schema that indicates the audience level.
    For example, Interact Performance Household.
  4. In the Input Tables section, identify the tables that support the audience level and the audience key.
  5. In the Schema Settings section, select all Over Time Variations options that apply and click Save Changes.

    A new node appears in the Configuration tree for the schema. You cannot change the name of the node.

  6. Under the new node, select SQL Configuration and select the first item, Interactive Channel Offer Contact History Summary.
  7. In the form, edit the value in the Table/View name field to include the code for the audience level.
    The name can be no longer than 18 characters and must be in all uppercase letters.
    For example, if the name of the audience level is household, you might specify: UARI_ICP_OCH_HH_.
  8. Click Save Changes.
  9. Repeat steps 7 and 8 for each item that is listed under the SQL Configuration section of the new reporting schema.