Step: Map tables for Optimize

To configure Optimize to work with Campaign, you must map all of the Optimize system tables in Campaign, and your contact history and segment membership tables.

For more information about mapping system tables in Campaign, see the IBM® Unica® Campaign Administrator’s Guide.

Mapping the segment membership system tables in Campaign for use with strategic segments is optional. Map the segment membership system table for an audience only if you use the audience with flowcharts or Optimize sessions that use strategic segments.

1.	Map all system tables.

2.	Map all contact history tables.

Confirm each audience level in your Campaign configuration has a contact history table. You must map each contact history table. See the IBM® Unica® Campaign Administrator’s Guide for more information about additional contact history tables.

3.	(Optional) For each audience used in Optimize sessions that use strategic segments, map the segment membership system table for the audience to the database table that defines segment members.

Requirements when using strategic segments.

If you plan to use strategic segments, ensure that there is a segment membership table for each audience level in your Campaign configuration. You must map each segment membership table.

Create two indexes on the audience segment membership tables. Create the first index on SegmentID and create the second on the audience level columns. For example, the UA_SegMembership table ships with an index on CustomerID and on SegmentID.

For more information about system tables and strategic segments, see the IBM® Unica® Campaign Administrator's Guide.

Optimize system table mapping reference

Optimize contact history table mapping reference