Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide > Campaign Load Mapping and Analytic Adapters > About Marketing Integration Objects and Components >
Mapping Rules for Integration Components (Marketing Person)
When creating a campaign load mapping using the Marketing Person integration object, use the following guidelines:
- Only the Contact Key integration component is required to be mapped. The only required field is Key 1.
- The Contact ID and Prospect ID values imported from the external data source must match the Row IDs for the Contact or Prospect in the Siebel contact or prospect tables.
- A Campaign Load Mapping can only be mapped to a single source table for contact information. Because a program stage and all included campaigns can use only a single campaign load mapping, this means that a campaign is limited to a single source table for contacts or prospects.
In a single campaign load record, you can map an integration component's integration component field to only one measure. For example, in a campaign load record for the Contact integration component, if you map the First Name integration component field to a measure called HH First Name, you cannot create another mapping record in the same campaign load mapping for the First Name integration component field to a different measure.
- If all incoming target names are contacts, then you do not need to map Prospect ID. Alternatively, you might use the Marketing Contact integration object. If all incoming target names are prospects, then you do not need to use Contact ID. If the target list includes both contacts and prospects, then both fields are required.
- Mappings for the Campaign Contact integration component are required only if Allow Repeated Contacts is selected for the campaign load mapping. This is because a contact might appear in the campaign for more than one account.
To create a campaign load mapping using the Marketing Person integration object
- From the application-level menu, choose View > Site Map > Marketing Administration > External Data Mapping.
- Map the data source table that contains Contact ID and Prospect ID. For the Siebel Data Warehouse, this table is W_PERSON_D.
- Click the Tables view tab and add two pseudo-fields to the table using the following information:
Reference Name Expression Contact_ID Case when contact_type_i = `Contact' then integration_id else null end Prospect_ID Case when contact_type_i = `Prospect' then integration_id else null end- From the Show drop-down list, select Measures.
- Click the List view tab and create list measures for the following:
- Contact_ID.
- Prospect_ID.
- Create a list measure for Customer or Integration ID in the Data Warehouse (this value will map to Key 1).
In the Siebel Data Warehouse, this field is INTEGRATION_ID field in the W_PERSON_D table and should uniquely identify the contact or prospect in the external data source.
- From the Show drop-down list, select External Data Mapping and click the Campaign Load Mapping view tab.
- In the Campaign Load Mapping list, create a new record, selecting Marketing Person in the Integration Object field.
- In the Mappings list, create a new record.
- In the new record, select the Contact Key integration component and map the following fields:
Integration Component Field Measure Contact Id Contact ID Key 1 Integration ID Prospect Id Prospect ID- As an optional step, if you selected the Allow Repeated Contacts check box, create another record in the mappings list for the Campaign Contact integration component and map the Account ID field.
- Create a new customer hierarchy with one targeting level, mapping the Integration ID field from the external table to the targeting level.
For instructions, see procedures in Creating Customer Hierarchies.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide Published: 23 June 2003 |