|
1.
|
Select Settings > Configuration and expand Reports > Schemas > Campaign > Offer Performance Star Schema.
|
|
2.
|
In the New category name, enter a descriptive name for the reporting schema that indicates the audience level. For example, Offer Performance Household.
|
|
3.
|
In the Input Tables section, identify the tables that support the audience level and the audience key.
|
|
4.
|
In the Schema Settings section, select the Over Time Variations options that apply and then click Save Changes.
|
|
5.
|
Under the new node in the Configuration tree, select Columns > Contact Metric and then configure the contact metrics for this audience level.
|
|
6.
|
Under the new node, select Columns > Response Metric and then configure the response metrics for this audience level.
|
|
7.
|
Under the new node, expand SQL Configuration, select the first item (Offer Contact History) and click Edit Settings.
|
|
8.
|
In the form that appears, 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.
|
|
9.
|
|
10.
|
Repeat steps 7 through 9 for each item listed under the SQL Configuration section of the new reporting schema.
|
|
Copyright IBM Corporation 2014. All Rights Reserved.
|