To map IBM® Campaign contact and response counts to Marketing Operations metrics

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

Campaign passes data to Marketing Operations 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 Campaign documentation.

The response types are stored in the UA_UsrResponseType system table in the 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.

In Campaign, modify the list of response types in the UA_UsrResponseType table if necessary to include the response types you want to track.

Edit the Marketing Operations metrics file being used by your system to include metrics that correspond to contact count and the response types.

Create a map file that associates the Marketing Operations metrics with contact count and the response types.

Add the map file to Marketing Operations.

Create a campaign template and select the map file from the Metric Data Mapping drop-down list.

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