Creating response tracking tables for the integration

Creating response tables is a one-time task that is performed as part of the integration configuration. However, if you are using Unica Campaign version or later, this step is not applicable for your setup. From Unica Campaign version onwards, when you use Unica Campaign to download events, the response tracking tables are created automatically.

Before you begin

  • The UBX Toolkit must be installed and configured.
  • You must have administrative access to install and configure files on the database server where you will create the tables.

About this task

Response tracking tables are required to store event data about customer responses. Events include information about customer actions such as opens, clicks, and bounces. The tables that you create will be populated when users run UBX Toolkit scripts to download and then import data. Unica Campaign can then access the populated tables as data sources in flowcharts.


  1. The UBX Toolkit provides DDL sample scripts for SQL, DB2, and Oracle. Use the appropriate script to create database tables in the desired format.
    Tip: By examining the script files in a text editor, you can see the fields and data types that will be created, and you can easily identify the primary keys.
  2. Use the database table mapping file (EventToDBTableMapping.xml) provided in the UBX Toolkit to match event data to field names in the database tables. This determines how data gets inserted into the tables.
  3. To learn more about using and managing tracking tables, see Response tracking tables for the integration.
  4. To see which events can be stored in the response tracking tables, see Email: Response tracking.

What to do next

The next step is to configure UBX. See Configuring UBX for the integration.