Home
Integration guides
Unica Campaign and Acoustic Campaign Integration Guide for IBM Marketing Cloud
Response tracking tables for the integration
To support the Campaign and Acoustic Campaign integration, response tracking tables are required to store data about user responses to email, SMS, and push events.
Integration database tables, ETL, and partitioning
The Campaign integration with Engage populates database tables that Campaign uses for auditing and tracking. Consult with your database administrator to discuss how long you need to keep the data for querying. Depending on the volume of activity for your account, the tables can grow large over time.

Integration guides
- Unica Campaign and Acoustic Campaign Integration Guide for IBM Marketing Cloud
  - Overview of the Unica Campaign and Acoustic Campaign integration
    The integration of Unica Campaign and Acoustic Campaign combines the marketing segmentation tools of Unica Campaign with the messaging capabilities of IBM Marketing Cloud.
  - Configuring the Unica Campaign and Acoustic Campaign integration
    To ensure a successful integration of Campaign and Acoustic Campaign, the following products must be configured: Unica Campaign, Acoustic Campaign, IBM UBX, and IBM UBX Toolkit.
  - Email: using Unica Campaign and Acoustic Campaign
    If Unica Campaign and Acoustic Campaign are integrated, you can use Unica Campaign to send personalized email communications from Acoustic Campaign.
  - SMS text messaging: using Campaign and Acoustic Campaign
    If Unica Campaign is integrated with Acoustic Campaign, you can you can use Unica Campaign to send SMS text messages from Acoustic Campaign.
  - Mobile push: using Unica Campaign and Acoustic Campaign
    If Unica Campaign and Acoustic Campaign are integrated, you can use Unica Campaign to send mobile push notifications from Acoustic Campaign.
  - Response tracking tables for the integration
    To support the Campaign and Acoustic Campaign integration, response tracking tables are required to store data about user responses to email, SMS, and push events.
    - Response and Contact Mapping
      When Unica Campaign and IBM Engage are integrated, the contact and response mapping is defined by default.
    - Email tracking data available as an event
      The following table lists the email tracking data that can be downloaded from UBX Toolkit to Unica Campaign.
    - SMS tracking data available as an event
      The following table lists the SMS tracking data that can be downloaded from UBX Toolkit to Unica Campaign.
    - Mobile push tracking data available as an event
      The following table lists the mobile push tracking data that can be downloaded from UBX Toolkit to Unica Campaign.
    - Integration database tables, ETL, and partitioning
      The Campaign integration with Engage populates database tables that Campaign uses for auditing and tracking. Consult with your database administrator to discuss how long you need to keep the data for querying. Depending on the volume of activity for your account, the tables can grow large over time.
    - Event types
      The tracking tables provide data to describe different types of message responses. The type of response is considered an event type.
    - Report IDs
      IBM Engage Report IDs appear in the tracking tables.
    - Reasons for contact suppression
      Engage sometimes does not send a message to an address for various reasons.
    - Purging data from response tracking tables
      You can periodically archive or purge the rows that have been processed by the ETL in order to free up space in the database.
    - Multi-thread Implementation of Event Download and Processing
      If you are using Unica Campaign version 11.1 or later, multiple threads are used for UBX event download to Unica Campaign and ETL processing. Unica Campaign-UBX integration involve 2 phase of operations.
- Unica Plan and Unica Campaign Integration Guide

Integration database tables, ETL, and partitioning

The Campaign integration with Engage populates database tables that Campaign uses for auditing and tracking. Consult with your database administrator to discuss how long you need to keep the data for querying. Depending on the volume of activity for your account, the tables can grow large over time.

Each integration table shares some characteristics.

The primary key is an identity or sequence column. The IDs in the primary keys reflect the order in which rows were inserted.
The tables have a datetime/timestamp column to indicate the time at which a particular event happened.
The rows in each table are inserted once and the integration does not update them after the initial insert.
There are no predefined indexes, foreign keys, or check constraints other than the primary key.

If you are not using recipient email address as the audience level in Unica Campaign, you can add one or more columns to the tracking tables. However, your data must include a way to look up audience level for any contact. You must configure the integration to download the values for those columns from your Engage database. When you add columns, do not use unique indexes or constraints because you might prevent data from being inserted.

The integration does not automatically purge or archive the tables. Your administrator can schedule archiving or purging of the data. A typical purging scheme might set up range partitioning on the datetime/timestamp field, with partitions for each month or quarter. The purging plan can drop partitions when they become outdated. However, different database capabilities and performance characteristics can affect your strategy for partitioning and purging of data. How you query the data might also affect your strategy.

As the Engage ETL runs on the Unica Campaign web application, a cluster user can control the Engage ETL execution on individual nodes by specifying the JVM option -Dengage.etl.disabled=true. If -Dengage.etl.disabled=true, Engage ETL does not work on the specified cluster node.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.