Creating an Offer Performance schema
Use Offer Performance Star Schema to create an Offer Performance schema.
About this task
To create an Offer Performance schema, complete the following steps.
Procedure
- Select .
- Expand .
- In the New category name, enter
a descriptive name for the reporting schema that indicates
the audience level. For example, Offer Performance Household.
- In the Input Tables section, identify the tables that support the audience level and the audience key.
-
In the Schema Settings section, select the 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.
-
Under the new node in the Configuration tree, select
and configure the contact metrics for this audience level.
For help with this step, see Adding contact or response metrics.
-
Under the new node, select
and configure the response metrics for this audience level.
For help with this step, see Adding contact or response metrics.
- Under the new node, expand SQL Configuration, select the first item (Offer Contact History) and click Edit Settings.
-
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: UARC_OCH_HH_.
- Click Save Changes.
- Repeat steps 8 through 10 for each item that is listed under the SQL Configuration section of the new reporting schema.