To create a Campaign Offer Contact Status Breakout schema
1.
Select Settings > Configuration and expand Reports > Schemas > Campaign > Campaign Offer Response Breakout Star Schema.
2.
Click New category name and enter a descriptive name for the reporting schema that indicates the audience level. For example, Campaign Offer Contact Status Household.
3.
In the Input Tables section, enter the name of the response history table for this audience level, and then click Save Changes.
A new node appears in the Configuration tree for the schema. You cannot change the name of the node.
4.
Under the new node, select Columns > Contact Status Code and then configure the contact status codes for this audience level.
For help with this step, see the procedure To add contact status codes.
5.
Under the new node, select SQL Configuration > Campaign Contact Status Contact History and click Edit Settings.
6.
In the form that appears, 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_CCSBO_HH_.
7.
Click Save Changes.
8.
Under the new node, select SQL Configuration > Campaign Offer Contact Status Contact and click Edit Settings.
9.
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_COCSBO_HH_.
10.
Click Save Changes.
Copyright IBM Corporation 2014. All Rights Reserved.