Adjusting Unica Campaign response tables for Unica Deliver offer integration
If you are using Unica Deliver offer integration, you must confirm that the Unica Campaign response tracking and mapping tables are set up properly.
About this task
To support ETL of response types between Unica Campaign and Unica Deliver, response types must be defined in both the UACE_ResponseType table (for Unica Deliver) and the UA_UsrResponseType table (for Unica 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 DeliverRespTypeID in UACE_ResponseType
Procedure
- 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.
- 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, Deliverresptypeid, applicationtype) values (9,1,3)
- insert into ua_resptypemapping (campaignresptypeid, Deliverresptypeid, applicationtype) values (10,14,3)
- insert into ua_resptypemapping (campaignresptypeid, Deliverresptypeid, applicationtype) values (11,18,3)
The ApplicationType of 3 indicates Unica Deliver and must not be changed.
Note: Only the Link Click response type is currently used for Unica Deliver offer integration. Landing Page and SMS Reply Message are not populated by the ETL process at this time.