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

Examples of Recommended Campaign Load Mappings

Campaign Load Mappings depend on the following:

• The data source. The data source includes Siebel Data Warehouse, Siebel transactional database, or a data source other than Siebel applications.
• The data elements required to be imported. These elements include Contact fields, Account fields, Contact address, and so on.
• Contact qualification. Determine if new contacts or existing contacts qualify for a campaign.
• Presence of contacts and prospects in the Siebel database. Determine if all contacts and prospects are already present in the contact and prospect tables in the Siebel database.

This topic contains descriptions of mappings with the name of the sample campaign load format report in which the recommended mappings appear. You can find the examples listed in the following topics in the Siebel File System: Shared Campaign Load Formats/Marketing/Example List Formats.

Examples of Mappings to the Siebel Data Warehouse

These mappings are applicable when campaigns are run against Siebel Data Warehouse.

• Recommended Mappings for Existing Contacts And Prospects. See the following sample campaign load format report:

  Campaign Load - Contacts and Prospects Example

• Recommended Mappings for Existing Accounts. See the following sample campaign load format report:

  Campaign Load - Existing Accounts

Examples of Mappings to the Siebel Database

The mappings shown in the following reports are applicable when campaigns are run on Oracle's Siebel database.

• Recommended Mappings for Contacts And Prospects. See the following sample campaign load format report:

  Campaign Load - Contacts and Prospects Example

• Recommended Mappings for Accounts. See the following sample campaign load format report:

  Campaign Load - Existing Accounts

Examples of Mapping to a Non-Siebel Database

The mappings shown in the following reports are applicable when campaigns are run on a non-Siebel database.

• Recommended Mappings for New Contacts. This is for cases where some of the contacts being loaded for the campaign do not exist in the Siebel database. See the following sample campaign load format:

  Campaign Load Contacts - Example

• Recommended Mappings for New Accounts. This is for cases where some of the accounts being loaded for the campaign do not exist in the Siebel database. See the following sample campaign load format:

  Campaign Load Accounts - Example

• Recommended Mappings for New Prospects. This is for cases where some of the prospects being loaded for the campaign do not exist in the Siebel database. See the following sample campaign load format:

  Campaign Load Prospects - Example