Creating a Campaign Performance schema
Use Campaign Performance Star Schema to create a Campaign Performance schema.
Complete the following steps to create a Campaign Performance schema:
1.
Select Settings > Configuration and expand Reports > Schemas > Campaign > Campaign Performance Star Schema.
2.
Click New category name and enter a descriptive name for the reporting schema that indicates the audience level. For example, Campaign 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 all the Over Time Variations options that apply and then 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 > Contact Metric and then configure the contact metrics for this audience level.
For help with this step, see the procedure Adding contact or response metrics.
6.
Under the new node, select Columns > Response Metric and then configure the response metrics for this audience level.
For help with this step, see the procedure Adding contact or response metrics.
7.
Under the new node, select SQL Configuration and select the first item, Campaign Contact History.
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.
For example, if the name of the audience level is household, you might specify: UARC_CCH_HH_.
9.
Click Save Changes.
10.
Repeat steps 8 and 9 for each item listed under the SQL Configuration section of the new reporting schema.
Copyright IBM Corporation 2014. All Rights Reserved.