Quantcast

Part 7: Eloqua SFDC integration enablement & activity writing

Aug 6, 2020

This is part seven of the Eloqua SFDC native integration guide.  To begin this tutorial at the start please use this link.

Enabling SFDC Integration Programs

Your  Eloqua database will contain three templated programs that are used in the SFDC Integration. Two of these programs will need to be enabled to complete a successful integration. Only one requires configuration before it is enabled (one of the two CRM Update programs).

Note: Form submissions and list uploads do not automatically modify Contact/Lead data within SFDC – the records MUST flow through the SFDC Update program in order to for data to be properly reflected in SFDC.  This should be clearly explained to the client and a go-live date should be established for form/list upload cutover.

Description of Programs

  • SYSTEM – CRM Email Opt Out Program: This program is used to globally unsubscribe from Eloqua any SFDC Lead or Contact that has the Email Opt Out flag checked in SFDC. This will ensure that email compliance is met, and that the communication preferences of a record are kept consistent across both systems. This program has standard logic and does not require configuration work. This program and associated feeder need to be enabled.

Only one of these next two programs needs to be enabled for the SFDC Integration. This decision should be recorded on the client’s SFDC Integration Decisions document and provided back to Eloqua.

  • *SYSTEM – CRM Update (Create only unique leads): This is the primary integration program. All form submissions and list uploads that are to flow into SFDC must feed into this program. This program evaluates then executes the criteria for creating/updating leads, updating contacts and performing campaign associations. This program uses the following logic:
Has Lead ID on Eloqua Contact? Has Contact ID on Eloqua Contact? Action
No No Create Lead, Associate Lead to Campaign
Yes No Update Lead, Associate Lead to Campaign
Yes Yes Update Lead and Contact, Associate Lead and Contact to Campaign
No Yes Update Contact, Associate Contact to Campaign
  • *SYSTEM – CRM Update (Point of Interest): This is the primary integration program. All form submissions and list uploads that are to flow into SFDC must feed into this program. This program evaluates then executes the criteria for creating/updating leads, updating contacts and performing campaign associations. This program uses the following logic:
Has Lead ID on Eloqua Contact? Has Contact ID on Eloqua Contact? Action
No No Create Lead, Associate Lead to Campaign
Yes No Update Lead, Associate Lead to Campaign
Yes Yes Update Lead and Contact, Associate Lead and Contact to Campaign
No Yes Create Lead, Update Contact, Associate Lead and Contact to Campaign

Configuring the SFDC Update Program

SYSTEM – CRM Update (Create only unique leads) OR SYSTEM – CRM Update (Point of Interest)

 

 

Eloqua Salesforce Integration Update

This change requires the creation of a NEW Integration Event, which should be done before configuring the SFDC Update Program.

Create ‘Stacked’ External Call

  1. Navigate to Settings > Setup > Integration.
  2. Click the Outbound tab.
  3. From the left column tree view, expand the Custom folder then expand Custom Contact Events.
Eloqua Salesforce Internal Events
  1. From the drop-down menu next to Custom Contact Events, select Create New Custom Event.
Eloqua Salesforce Create New Custom Event
  1. Enter the Custom Event Name ‘Create Lead and Associate with Campaign’, then click Save.
  2. Click on the newly created Custom Contact Event in the left pane.
  3. From the Event Mapping screen, click ‘Add Existing External Call’ TWICE (you’ll need to add 2 existing calls).
Eloqua Salesforce Integration Execution Order
  1. Select ‘Create Lead’ as the first External Call.
  2. Select ‘Associate Lead with Campaign’ as the second External Call.
  3. Click Save.
Eloqua Salesforce Integration Event Mapping

Configure SFDC Update Program

SYSTEM – CRM Update (Create only unique leads) OR SYSTEM – CRM Update (Point of Interest)

  1. Navigate to Settings > Setup > Program Builder.
  2. Create a new folder ‘SYSTEM’.
  3. From the left column tree view, expand the BP-CRM Integrations and Salesforce folders.
    Note: The Foldering path outlined is present in new Eloqua platforms. Clients may rename these folders or the names of the actual programs. This will likely be the case with existing clients. You should familiarize yourself with the logic of each program to avoid confusion.
  4. Locate the CRM Update program the client has selected. Copy the program to the SYSTEM folder and name it ‘SYSTEM 1.0 SFDC Update’.
  5. Click on the Program Name. The program flow will load in the right pane.
  6. For each of the following steps, click on the drop-down arrow next to the step name and select Edit Step Default Action to configure the settings:
    • Update Lead in SFDC
    • Create Lead in SFDC with Campaign Association
    • Create Lead in SFDC with NO Campaign Association
    • Update Contact in SFDC
    • Update Campaign in Lead
    • Update Campaign in Contact
  7. Configure the settings for each step as follows:
    • The action can run at any time of day
    • Select the Integration Action Type, then the action Run Integration Event
    • Select the Custom Event. These Custom Events contain the field mapping from the Outbound External API Calls configured in Section 8.
Eloqua Salesforce Integration  Event
  1. Click Save and Close in the bottom right corner.
  2. Once all Integration Events are mapped and verified, select Enable Program from the Program sub-menu.
  3. Click on Enable Program and Selected Feeders in the bottom right corner.
  4. Verify that the program is active by checking:
    • The Program Icon is colored in the left tree view
    • The workflow background is white.

Enabling the SYSTEM-CRM Email Out Program

  1. Copy the ‘SYSTEM-CRM Email Opt Out Program’ to the SYSTEM folder and name it ‘SYSTEM 2.0 SFDC Email Opt Out’ [copy the program feeders AND actions].
  2. Click on the Program Name in the left tree view.
  3. Once the program flow has loaded in the right pane, select Enable Program from the Program sub-menu. The Enable Program Feeders window opens.
Eloqua Salesforce Integration Program Feeders
  1. Check the box next to the displayed feeder.
  2. Click on Enable Program and Selected Feeders in the bottom right corner.
  3. Verify that the programs are active by checking:
    • The Program Icon is colored in the left tree view
    • The workflow background is white.
error: Content is protected !!