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 Contact Status Breakout schema, complete the following steps.
Procedure
-
Select .
-
Expand .
- 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.
-
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.
-
Under the new node, select and configure the contact status codes for this audience level.
- Under the new node, select SQL Configuration
> Campaign Contact Status Contact History and
click Edit Settings.
-
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_CCSBO_HH_.
- Click Save Changes.
- Under the new node, select SQL Configuration
> Campaign Offer Contact Status Contact and click Edit
Settings.
- 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_.
- Click Save Changes.