Default Customer audience level system tables

Unica Campaign is delivered with system table ddl scripts to create the tables that support the default Customer audience level.

After installing Unica Campaign, you must map these system tables to tables in the Unica Campaign system database as follows:

Table 1. Default audience level system tables

Unica Campaign System Table

Database Table Name

Customer Contact History

UA_ContactHistory

Customer Response History

UA_ResponseHistory

Customer Detailed Contact History Table

UA_DtlContactHist

Customer Segment Membership

UA_SegMembership

If these tables are mapped as listed above, then the sample reports provided with Unica Campaign will work with a minimum number of changes.

The SQL statements used to create these tables and their related indices can be used as templates to create tables for other audience levels.