Mapping tables for Contact Optimization

You can exchange data between Contact Optimization and Campaign by mapping the Contact Optimization system tables, contact history tables, and segment membership tables to the Campaign tables.

About this task

Note: 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 Contact Optimization sessions that use strategic segments.

For more information about mapping system tables in Campaign, see the HCL® Campaign Administrator's Guide.

Complete the following steps to map tables for Contact Optimization:

Procedure

  1. Map all system tables.
  2. Map all contact history tables.

    Confirm that each audience level in your Campaign configuration has a contact history table. You must map each contact history table. For more information about additional contact history tables, see the HCL Campaign Administrator's Guide.

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

    Requirements when you use 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. The UA_SegMembership table ships with an index on CustomerID and on SegmentID.

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