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.
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.

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

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.

The following tables are populated when events are downloaded.

UA_EmailSend
UA_EmailOpen
UA_EmailClick
UA_EmailBounce
UA_EmailOptOut
UA_EngageEtlTracker

The UA_EngageEtlTracker table keeps track of the rows that have been processed. This table contains the information for the EventType and the LastProcessedRecordId.

EMAIL_SEND_EVT_CODE = 1;
EMAIL_OPEN_EVT_CODE = 2;
EMAIL_CLICK_EVT_CODE = 3;
EMAIL_BOUNCE_EVT_CODE = 4;
EMAIL_OptOut_EVT_CODE = 5;

You can archive or purge the following rows:

Select * from UA_EmailSend where RecordID <= (select LastProcessedRecordId from UA_EngageEtlTracker where EventType = 1)
Select * from UA_EmailOpen where RecordID <= (select LastProcessedRecordId from UA_EngageEtlTracker where EventType = 2)
Select * from UA_EmailClick where RecordID <= (select LastProcessedRecordId from UA_EngageEtlTracker where EventType = 3)
Select * from UA_EmailBounce where RecordID <= (select LastProcessedRecordId from UA_EngageEtlTracker where EventType = 4)
Select * from UA_Emailoptout where RecordID <= (select LastProcessedRecordId from UA_EngageEtlTracker where EventType = 5)

From 11.1 version, if ETL is enabled, Unica Campaign-UBX integration data from contact and response tracking table will be purged automatically after it is processed and populated to Detailed contact history and Response history. While ETL is processing the contact/response record, it will match up tracking code and externalsystemrefranceid and logs the status of each record to UA_EngageEtlRecordStatus table.

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.