Adjusting Campaign response tables for eMessage offer integration
If you are using eMessage offer integration, you must confirm that the Campaign response tracking and mapping tables are set up properly.
*
New installations can skip this task because the tables were updated during the installation process. Upgrade customers who want to use eMessage offer integration must perform the following steps.
To support ETL of response types between Campaign and eMessage, response types must be defined in both the UACE_ResponseType table (for eMessage) and the UA_UsrResponseType table (for Campaign). Then the response types must be mapped in the UA_RespTypeMapping table. The UA_RespTypeMapping table maps the CampaignRespTypeID in UA_UsrResponseType to the EMessageRespTypeID in UACE_ResponseType
1.
Add the Link Click, Landing Page, and SMS Reply Message response types to the UA_UsrResponseType table using the values shown below:
*
insert into ua_usrresponsetype (ResponseTypeId, Name, Description, ResponseTypeCode, CountsAsResponse, isDefault) values (9, 'Link Click', NULL, 'LCL', 1, 0)
*
insert into ua_usrresponsetype (ResponseTypeId, Name, Description, ResponseTypeCode, CountsAsResponse, isDefault) values (10, 'Landing Page', NULL, 'LPA', 1, 0)
*
insert into ua_usrresponsetype (ResponseTypeId, Name, Description, ResponseTypeCode, CountsAsResponse, isDefault) values (11, 'SMS Reply Message', NULL, 'SRE', 1, 0)
For more information, see Default response types.
2.
Update the UA_RespTypeMapping table to include Link Click (9,1,3), Landing Page (10,14,3) and SMS Reply Message (11,18,3), as shown below:
*
insert into ua_resptypemapping (campaignresptypeid, emessageresptypeid, applicationtype) values (9,1,3)
*
insert into ua_resptypemapping (campaignresptypeid, emessageresptypeid, applicationtype) values (10,14,3)
*
insert into ua_resptypemapping (campaignresptypeid, emessageresptypeid, applicationtype) values (11,18,3)
The ApplicationType of 3 indicates eMessage and must not be changed.
*
Only the Link Click response type is currently used for eMessage offer integration. Landing Page and SMS Reply Message are not populated by the ETL process at this time.
Additional information about eMessage offer integration is provided in the eMessage User's Guide and the Campaign User's Guide.
Copyright IBM Corporation 2015. All Rights Reserved.