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 into Siebel. 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 section contains descriptions of mappings with the name of the sample campaign load format report in which the recommended mappings appear.

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 the Siebel Systems 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 Systems database.

  • Recommended Mappings for New Contacts. This is for cases where some of the contacts being loaded for the campaign are not existing 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 are not existing 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 are not existing in the Siebel database. See the following sample campaign load format:

    Campaign Load Prospects - Example

Siebel Marketing Installation and Administration Guide