Mapping Unica Campaign contact and response counts to Unica Plan metrics

If you want users to be able to import contact and response counts into Unica Plan, you must map contact count and the response types to Unica Plan metrics.

About this task

Note: Unica Campaign passes data to Unica Plan for one audience level only, the audience level that is mapped to the UA_ContactHistory, UA_ResponseHistory, and UA_DtlContactHist system tables. The audience level can be any audience level, with any number of audience key fields of any data type or name. For details on audience levels, see the Unica Campaign documentation.

The response types are stored in the UA_UsrResponseType system table in the Unica Campaign database. To map a metric to a response type, you must know the name of the response type.

The mappings are stored in an XML file.

Procedure

  1. In Unica Campaign, modify the list of response types in the UA_UsrResponseType table if necessary to include the response types you want to track.
  2. Edit the Unica Plan metrics file being used by your system to include metrics that correspond to contact count and the response types.
  3. Create a map file that associates the Unica Plan metrics with contact count and the response types.
  4. Add the map file to Unica Plan.
  5. Create a campaign template and select the map file from the Metric Data Mapping drop-down list.

Results

The contact and response data is mapped to metrics for all projects that are created from that template.