Task 1: Create the required database tables for each new audience level
This task is part of the workflow for setting up a new audience level.
About this task
You must create physical database tables in the Unica 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.
To create the tables for other audience levels, you may want to use the SQL statements used to create the Unica Campaign default audience level tables and their related indices as templates. For example, you could use UA_ContactHistory as a template for Acct_ContactHistory (for an audience level Account). To see the available SQL statements, look in the /Campaign/ddl directory for the script that creates system tables for your database management system.