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 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.

To add contact or response metrics, complete the following steps.

Select Settings > Configuration.
Expand Reports > Schemas > Campaign > name of the appropriate reporting schema.
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 HCL 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.