Siebel Marketing Installation and Administration Guide > Designing Marketing Campaign Load Formats > About Marketing Integration Objects >

About the Marketing Contact Integration Object


The Marketing Contact integration object provides field mappings to typical contact- and account-related information from the external data sources. The predefined integration object, Marketing Contact, defines the information that is exchanged between the external data source and Siebel Marketing, using EAI technology. For more information about EAI, see Overview: Siebel Enterprise Application Integration. For a list of fields for the Marketing Contact integration object, see Field Names for Marketing Integration Components.

Figure 1 shows the integration components for the Marketing Contact integration object. Required fields apply when a new contact is inserted into the Siebel transactional database.

Figure 1. Marketing Contact Integration Components

During campaign load, integration component User Keys determine if a record already exists in the component (for the given values) and if the record is unique. Required fields cannot be a null value for the new record.

Table 11 describes the Marketing Contact integration components.

Table 11. Marketing Contact Integration Component Description
Component
Comment

Account

Maps account information associated with the contact.

Account Address

Maps the account address.

Account Organization

Maps information about the account's organization.

Campaign Contact

Maps campaign history-level information such as campaign Id, load number, wave number, contact Id, prospect Id, account Id, and the keys that bind contacts with their unique IDs in the data warehouse.

Contact

Maps contact-level information such as the contact's name, telephone number, email address, and so on.

Contact Address

Maps the contact's address information.

Contact Organization

The Contact Organization component maps information about the contact organization.

Mapping Rules for the Marketing Contact Integration Components

Using contact information for campaign load requires the following integration components:

  • Contact. Includes information such as contact first name, contact last name, and so on.
  • Campaign Contact. Fields must be mapped in the campaign load report. Mapping includes the required campaign load columns and the keys that store unique IDs from the data warehouse for the party (contacts, prospects, or accounts) being loaded.

Use the following rules when mapping components:

  • A parent integration component must be mapped before mapping a child component. For example, the Account Address component cannot be mapped unless Account is mapped.
  • User Key fields must be mapped for each integration component if one or more fields for the component is mapped.
  • Required fields must be mapped for each integration component if one or more fields for the component are mapped.
  • Make sure that the campaign load format includes a column indicating the organization in which the contact and account data must be loaded.

Sample Mappings for Contact Key Components

The combination of keys that are mapped in the campaign load report depend upon the target levels that you use.

Table 12 describes examples of Key mappings for sample target levels.

Table 12. Key Mappings for Sample Target Levels
Target Level
Key Mapping

Contacts

Key 1

Accounts

Key 2

Prospects

Key 3

Households

Key 4

Siebel Marketing Installation and Administration Guide Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.