Task 1: Create the required database tables for each new audience level

You must create physical database tables in the Campaign system database to support each new audience level(s) you create. The required tables for each audience level are:

A contact history table

A detailed contact history table

A response history table

A segment membership table

Each required table has a set of required fields. You can create additional custom fields in your audience tables.

You should create indices on the tables you create. For example, if you create the INDIV_ContactHistory table for a new Individual audience level, you could create an index as follows: CREATE INDEX XIE1INDIV_ContactHistory ON INDIV_ContactHistory ( IndivID ).

To create the required audience database tables

The SQL statements used to create the Campaign default audience level tables and their related indices can be used as templates to create tables for other audience levels. For example, you could use UA_ContactHistory as a template for Acct_ContactHistory (for an audience level Account). To see the SQL statements, look in the /Campaign/ddl directory for the script that creates system tables for your database management system.

You have the flexibility to map multiple system tables for a new audience level to the same underlying physical database table (containing sufficient audience fields to represent all necessary audience levels), or you can create separate database tables for each audience level. Unica consulting or your implementation partner can help you decide how to best implement contact and response history tables for your environment.