Task 3: Map the Unica Campaign system tables to the database tables

This task is part of the workflow for setting up a new audience level.

About this task

After creating the physical database tables for each new audience level and the audience levels in Unica Campaign, you must map the Unica Campaign system tables to these database tables.

You can map user tables to your created audience levels without mapping the Unica Campaign system tables to database tables, but you will not be able to log contact and response history without mapping the Contact History, Detailed Contact History, and Response History tables.

HCL recommends that you map segment membership system tables to physical database tables only for audiences used in Unica Campaign flowcharts or Unica Optimize sessions that contain strategic segments. Using strategic segments in Unica Campaign and Unica Optimize is optional.

Procedure

  1. Select Settings > Campaign settings.
  2. On the Campaign Settings page, under Data source operations, click Manage audience levels.

    The Audience levels dialog opens, displaying existing audience levels.

  3. Select the audience level for which you are mapping database tables, and click History tables.
  4. In the Table mappings dialog, select each Unica Campaign system table and click Map table.
  5. In the table mapping dialog, select the database table that corresponds to the Unica Campaign system table for that audience level. The Source table fields list is populated with the fields from the database table that you selected. The Required fields list is populated with selected fields (from your source database table) and the corresponding required fields (from the Unica Campaign system table).
    Important: Fields can be mapped only if Unica Campaign finds an exact match for the field names.
  6. Click Next to specify mapping for any custom fields in your database tables.
  7. Click Next to specify display names for custom fields. This option is not available for all tables.
  8. Click Finish to complete the mapping. Repeat this procedure for each required Unica Campaign system table for the audience level.
    Note: You can also perform this task from the Manage table mappings link on the Campaign Settings page.