Reports | Schemas | Campaign | Campaign Offer Response Breakout | Columns | [Response Type]
Use the Reports | Schemas | Campaign | Campaign Offer Response Breakout | Columns | [Response Type] property to add any custom response types that you want to include in your reports to the reporting schema.
Column Name
Description
Specifies the name to use in the reporting view or table for the column that is specified in the Response Type Code 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.
Response Type Code
Description
The response type code for the specified response type. This value is held in the ResponseTypeCode column in the UA_UsrResponseType table.
Default value
[CHANGE ME]
Valid Values
The example response type codes are as follows:
*
EXP (explore)
*
CON (consider)
*
CMT (commit)
*
FFL (fulfill)
*
USE (use)
*
USB (unsubscribe)
*
UKN (unknown)
Your Campaign installation may have additional custom response type codes.
Control Treatment Flag
Description
If you use the standard IBM® Cognos® reports provided in the IBM® EMM Reports Pack or custom reports that include control groups, then each response type must have two columns in the reporting schema. One column represents the response type from the control group and the other column represents the response type 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