Reports > Schemas > Campaign > [schema name] > Columns > [Contact Metric]

Use this form to add contact metrics to the Campaign Performance or Offer Performance reporting schemas.

Column Name

Specifies the name to use in the reporting view or table for the column specified in the Input Column Name field.

Valid values

The name can be no longer than 18 characters, it must be in all UPPER-CASE letters, and it cannot have spaces.

Default value

[CHANGE ME]

Function

Specifies how the contact metric is determined or calculated.

Valid values

count, count distinct, sum, min, max, average

Default value

count

Input Column Name

The name of the column that provides the contact metric you are adding to this reporting schema.

Valid values

The name of the column in the Contact History and Detailed Contact History tables.

Default value

[CHANGE ME]

Control Treatment Flag

If you use the sample IBM Cognos 8 reports or create your own custom reports that include control groups, then each contact metric must have two columns in the reporting schema. One column represents the metric for the control group and the other column represents the metric for the target group. The value in Control Treatment Flag specifies whether the column in the view represents the control group or the target group.

If your reports do not include control groups, you do not need the second column for the control group.

Valid values

0: the column represents the target group

1: the column represents the control group

Default value

0