Adding contact or response metrics
You can add contact or response metrics to the Campaign Performance and Offer Performance reporting schemas.
About this task
Before you begin, determine the following information:
- Which reporting schema supports the report you want to add the metric to. See the appendix 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.
Complete the following steps to add contact or response metrics:
Procedure
- Select Settings > Configuration and 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 (zero) to indicate that this column in the reporting schema represents the target group.
- Click Save Changes.
- Repeat this procedure to add the control group column to the reporting schema, if necessary. This time, enter the number 1 (one) to indicate that this column represents the control group.