Overview
When a Contact is enriched in Eloqua, the fields are written into the CDO tables (both the Standard and SLM CDO if Site Level Matching is enabled). This flow will allow the Leadspace fields that are in the CDOs to be written to your standard Contact table when blank.
Setup
Here is an screenshot of a sample program canvas (updating 4 fields):
Let's dig into each of the different steps on how to set up. In this article, we will walk thru how to setup for updating just ONE field. Steps will need to be repeated for subsequent field updates.
A few items to set up before we build the actual program canvas.
1. Create Additional Fields in the CDO
First we need to create new fields for each field that you are wanting to update from the CDO to the Contact table. This is to create a flag to do the update. (Ex: If you are wanting to update 'City' you can create a new field 'Update City' or something equivalent)
Navigate to Contact Card > Custom Objects.
Select LS_Standard_CDO > Custom Object > Custom Object Record Fields > Create New Fields.
Create a new field called 'Update [field you are updating]' (Ex: Update City)
2. Set up the Record Service
Navigate to Contact Card > Custom Objects.
Click on the down arrow next to LS_Standard_CDO > Custom Object Record Services.
From there, click on Modified Data > Edit Service Actions.
Add a new processing step.
Step: 'Save to Contact Table'
Description: Give the name of the field you are updating (Ex: City)
Details:
In this example we are updating 'City' when blank.
Required Parameters
Email Address: Data Card Field 'Original Email' (this will be the unique identifier)
Contact Type: Regular Contact
Overwrite Existing: Yes
Optional Parameters
Put in the field that you are wanting to update.
In this case:
City: Value - LS Person City (in our example we just have 'City' as the field name in the CDO)
This Processing Step Gets Executed
Only if the following Condition is met:
'Update [field]' is not 'BLANK' (ex: Update City)
You will need to create a separate one for each field you are updating.
*Make sure to Enable the Record Service.
3. Create the Update Rules
Go to Contact Card > Tools > Data Tools.
Update Rule Set.
Name: [field you are updating]
Custom Object Set: Select the CDO
Edit Update Rule:
Update City (or select the field name you are updating)
Select an update action: Append set value to Field
Value: Y
Apply and save.
You will need to create a separate update rule for each field.
Then create one additional update rule to reset all the 'Update [field]' fields back to blank.
4. Build the Program Canvases
A) First, we need to build a program for each of the fields you are wanting to update.
The 'Compare Custom Object Fields' criteria:
- LS_Standard_CDO '[LS Field you are Updating] (ex: LS Lead City) in this case City
- NOT is blank
You will need to create the flow above for each field you are needing to update.
B) Next, we need another flow for the Reset Update Rule.
C) Final flow, for just updating City in this example, except this time create a new Contact Program.
If you would like more information about setting up this flow, please reach out to support@leadspace.com and we will be happy to set up a call.