Configuring eMessage offer integration with HCL Campaign

1. Configure the contact and response history ETL process for this partition.

Campaign uses its own ETL process to extract, transform, and load offer response data from the eMessage tracking tables into the Campaign contact and response history tables. The ETL process coordinates information across the necessary tables.

To configure the ETL process:

1. In HCL Campaign, select Settings > Configuration.
2. Adjust the properties for the following parameter:

   Campaign | partitions | partition[n] | eMessage | contactAndResponseHistTracking

See Campaign | partitions | partition[n] | eMessage | contactAndResponseHistTracking.

2. Optionally, adjust the ETL logging properties.

ETL logging is enabled by default. The default file location is Campaign_home/logs/ETL.log. To adjust logging behavior, modify the campaign_log4j.properties file, whose default location is Campaign_home/conf.

See The Campaign and eMessage ETL log file.

Optionally, allow monitoring of the ETL process so JMX-based clients can see the progress of the ETL.

In HCL Campaign, select Settings > Configuration, then set the following parameter to Yes:

Campaign | monitoring | monitorEnabledForEmessage

See Campaign | monitoring

3. Upgrades only: Adjust Campaign response tracking and mapping tables.

New installations can skip this step because the tables were updated during the installation process.

Upgrade customers who want to use eMessage offer integration must add the Link Click, Landing Page, and SMS Reply Message response types to the UA_UsrResponseType table, then update the UA_RespTypeMapping table to map the response types to eMessage.*

The UA_RespTypeMapping table is required to coordinate transfer of data across the necessary Campaign and eMessage tables.

See Adjusting Campaign response tables for eMessage offer integration.

4. Optionally, adjust Campaign performance reports.

The Campaign Detailed Offer Response Breakout report includes Link Click, Landing Page, and SMS Reply Message email responses by default, so no adjustments are necessary for this report.*

The other performance reports show the sum of all contacts or responders over all channels that were used, but they do not specifically break out the information by channel. You can customize these reports to include channel information, if desired.

Changes affect both the object-specific reports on the campaign or offer Analysis tab and the reports on the Analytics menu.

See the IBM EMM Reports Installation and Configuration Guide.