Adding contact or response metrics
You can add contact or response metrics to the Campaign Performance and Offer Performance reporting schemas.
Before you begin
Determine the following information:
- Which reporting schema supports the report that you want to add the metric to. See Unica Campaign reports and reporting schemas for information.
- Whether you need to add a column to the reporting schema for the control group in addition to the target group. See Control groups and target groups in the reports.
- How the metric is calculated. For example, it could be summed, averaged, or counted.
About this task
To add contact or response metrics, complete the following steps.
Procedure
- Select .
- Expand .
- Expand the Columns node and select either Contact Metric or Response Metric.
- In the form on the right, click New category name and enter the name of the contact or response metric.
- For Column Name, enter the name to use in the reporting schema for the attribute. Use all uppercase letters with no spaces.
- For Function, specify how the metric is calculated or determined.
-
For Input Column Name, enter the name of the column for this attribute
from the appropriate table in the
application database.
Input column names are case-sensitive.
- For Control Treatment Flag, enter the number 0 to indicate that this column in the reporting schema represents the target group.
- Click Save Changes.
- Optional: Repeat this task to add the control group column to the reporting schema, if necessary. This time, enter the number 1 to indicate that this column represents the control group.