Creating a Campaign Offer Response Breakout schema
You can create reporting schemas for extra audience levels or partitions if you want to configure reporting for multiple audience levels or multiple partitions.
Procedure
- Select Settings > Configuration and expand Reports > Schemas > Campaign > Campaign Offer Response Breakout Star Schema.
- Click New category name and enter
a descriptive name for the reporting schema that indicates
the audience level.For example, Campaign Offer Response Household.
- 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.
- Under the new node, select Columns > Response
Type and then configure the response types for this audience
level.
For help with this step, see the procedure Adding response types.
- Under the new node, select SQL Configuration > Campaign Response Breakout and click Edit Settings.
- 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_CRBO_HH_.
For more information about table and view naming conventions, see the Reports | Schemas | [product] | [schema name] | SQL Configuration.
- Click Save Changes.
- Under the new node, select SQL Configuration > Campaign Offer Response Breakout 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_CORBO_HH_.
- Click Save Changes.