Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric] and [Response metric]
Use these properties to add contact and response metrics to the Campaign Performance or Offer Performance reporting schemas.
Column Name
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric]
- Description
-
Specifies the name to use in the reporting view or table for the column that is specified in the Input Column Name field.
- Default value
-
[CHANGE ME]
- Valid Values
-
The name can be no longer than 18 characters, it must be in all uppercase letters, and it cannot have spaces.
Function
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric]
- Description
-
Specifies how the contact metric is determined or calculated.
- Default value
-
count
- Valid Values
-
count, count distinct, sum, min, max, average
Input Column Name
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric]
- Description
-
The name of the column that provides the contact metric you are adding to this reporting schema.
- Default value
-
[CHANGE ME]
- Valid Values
-
The name of the column in the Contact History and Detailed Contact History tables.
Control Treatment Flag
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Contact Metric]
- Description
-
If you use the sample IBM® Cognos® 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.
- Default value
-
0
- Valid Values
-
-
0: the column represents the target group
-
1: the column represents the control group
-
Column Name
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Response Metric]
- Description
Specifies the name to use in the reporting view or table for the column that is specified in the Input Column Name field.
- Default value
[CHANGE ME]
- Valid Values
The name can be no longer than 18 characters, it must be in all uppercase letters, and it cannot have spaces.
Function
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Response Metric]
- Description
Specifies how the response metric is determined or calculated.
- Default value
count
- Valid Values
count, count distinct, sum, min, max, average
Input Column Name
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Response Metric]
- Description
The name of the column that provides the response metric you are adding to this reporting schema.
- Default value
[CHANGE ME]
- Valid Values
The name of the column in the Response History table.
Control Treatment Flag
- Configuration category
- Reports | Schemas | Campaign | [schema name] | Columns | [Response Metric]
- Description
If you use the standard IBM® Cognos® reports or create your own custom reports that include control groups, then each response metric must have two columns in the reporting schema. One column represents the response from the control group and the other column represents the response from 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.
- Default value
0
- Valid Values
0: the column represents the target group
1: the column represents the control group