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