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 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 Unica Campaign installation may have additional custom response type codes.

Control Treatment Flag

Description

If you use the standard IBM® Cognos® reports provided in the Unica 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