Mapping HCL 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.
About this task
Note: 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.
Procedure
- 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.
Results
The contact and response data is mapped to metrics for all projects that are created from that template.