Creating a Campaign Offer Response Breakout schema

If you want to configure reporting for multiple audience levels or multiple partitions, you can create reporting schemas.

About this task

To create a Campaign Offer Response Breakout schema, complete the following steps.

Procedure

  1. Select Settings > Configuration.
  2. Expand Reports > Schemas > Campaign > Campaign Offer Response Breakout Star Schema.
  3. Click New category name and enter a descriptive name for the reporting schema that indicates the audience level.
    For example, Campaign Offer Response Household.
  4. In the Input Tables section, enter the name of the response history table for this audience level and click Save Changes.

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

  5. Under the new node, select Columns > Response Type and then configure the response types for this audience level.

    For help with this step, see Adding response types.

  6. Under the new node, select SQL Configuration > Campaign Response Breakout and click Edit Settings.
  7. In the form, edit the name 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: UARC_CRBO_HH_.

    For more information about table and view naming conventions, see the Reports | Schemas | [product] | [schema name] | SQL Configuration.

  8. Click Save Changes.
  9. Under the new node, select SQL Configuration > Campaign Offer Response Breakout and click Edit Settings.
  10. Edit the name 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, UARC_CORBO_HH_.
  11. Click Save Changes.