Most often Siebel Marketing and Oracle BI will be used to load campaign members for a marketing campaign based on Segment criteria defined within Oracle BI:
The Siebel Campaign Membership is then loaded based on the defined Load List Format with Type “Campaign Load”:
Once the Marketing Users clicks the Campaign Load Button the below Siebel Workflow is executed and triggers the generation of a File (csv) that is loaded by the Workflow into the Siebel Campaign Membership:
This Workflow also only exists for loading Contacts and not for Accounts. Even for Accounts (Companies) this Workflow requires at least one Contact within the Account.
However, the Standard (BI Applications 18.104.22.168) additionally offers to load other Entities than the Campaign Membership:
- Marketing Contact Integration Object
- Marketing Prospect Integration Object
- Marketing Person Integration Object
- Marketing Lead Integration Object
- Marketing Response Integration Object
(Described within the Official Bookshelf Documentation.)
This allows to:
- Load/Synchronize Customers into Siebel from other Sources e.g. to load Prospects which have been bought from 3rd Parties.
- Load Leads and Responses into Siebel
For this, the following standard Workflows exist:
E.g. for creating Leads the Workflow:
The Workflows also triggers the generation of a File (csv) by Oracle BI which is being loaded into the respective Siebel Entity e.g. Lead.
This provides Users with the possibility to define criteria that qualify a lead for a specific Campaign. If these criteria (expressed as Segment criteria) are being fulfilled, a Lead will be created within Siebel. A Segment to qualify a Lead based on e.g.Campaign Responses could look like the following:
The Workflow “Marketing Create Leads” then loads the Marketing Lead Integration Object (described above), which has the following definition:
|Lead||Defines all the primary attributes of the entity lead.
User Key: Id
|Lead Organization||Defines the Organization attributes associated with the lead.
User Key: Organization Id
|Lead Position||Defines attributes of Position associated with the lead.
User Key: Position Id
|Lead Product||Defines attributes of Products associated with the lead.
User Key: Product Id
Using the following Load List Format of Oracle BI:
And the corresponding standard Load List definition of Oracle BI:
Instead of being of Type “Campaign Load” the above Standard Load List is of Type “BI Data Load”. To synchronize customer data another Load List Type is available “Customer Synchronization”.
A Marketing User can configure all this steps during design-time of a Marketing Campaign with the Program flow:
Only Load List of Type “BI Data Load” are available for a Marketing User.
2) specifying the stored segment (created beforehand) to evaluate/qualify a Lead based on certain Campaign Responses given by the Campaign Participants.
To summarize. Siebel Marketing offers not only the possibility to load Campaign Members into the Campaign Membership (S_CAMP_CON Table) but also Responses or Leads via standard Marketing Workflows and Load Lists provided out-of-the-box.