Configuring contact and response history tables for cross-session response tracking
Whether you create a copy of the contact history tables, or use the actual tables in the Campaign system tables, you must perform the following steps to configure the contact and response history tables.
The contact and response history tables must be mapped properly in Campaign prior to performing these steps.
Run the aci_lrnfeature SQL script in the interactDT/ddl/acifeatures directory in the Interact design environment installation directory against the UA_DtlContactHist and UA_ResponseHistory tables in your Campaign system tables.
This adds the RTSelectionMethod column to the UA_DtlContactHist and UA_ResponseHistory tables. Run the aci_lrnfeature script against these tables for each of your audience levels. Edit the script as necessary to work with the correct table for each of your audience levels.
If you are creating a copy of the Campaign contact history tables accessible by the runtime environment for cross-session response tracking support, use the following guidelines:
UA_DtlContactHist (for each audience level)
You must update the data in these tables on a regular basis to ensure accurate response tracking.
Run the aci_crhtab SQL script in the ddl directory in the Interact runtime environment installation directory against the contact and response history data source.
This script creates the UACI_XsessResponse and UACI_CRHTAB_Ver tables.
Create a version of the UACI_XsessResponse table for each audience level.
To improve the performance of cross-session response tracking, you may want to limit the amount of contact history data, either by the way in which you copy the contact history data or by configuring a view in to the Campaign contact history tables. For example, if you have a business practice that no offer is valid for longer than 30 days, you should limit the contact history data to the last 30 days. To modify the number of days of contact history data to maintain, open the configuration property Campaign | partitions | partitionn| Interact | contactAndResponseHistTracking and set the value of daysBackInHistoryToLookupContact.
You will not see results from cross-session response tracking until the contact and response history module runs. For example, the default processSleepIntervalInMinutes is 60 minutes. Therefore, it may take at least an hour before cross-session responses appear in your Campaign response history.
UACI_TrackingType table