Lattice provides a cloud feeder app that you can install in Eloqua. Once installed, users can create multiple campaigns with-in Eloqua with each campaign containing an instance of the cloud feeder.
The cloud feeder app is designed to look for lattice campaign updates from Lattice and pull them at user defined intervals.
At a high level, here is how data from Lattice syncronizes to Eloqua
- User in Lattice launches a campaign.
- Lattice generate accounts and contacts and store this snapshot for Eloqua app.
- User in Eloqua creates and activates an Eloqua campaign with the cloud feeder application.
- Assuming the user in Eloqua has setup the cloud feeder app to sync with Lattice daily, the Eloqua app calls Lattice API to get the latest accounts and contacts
- The contacts are then synced with-in Eloqua using the Eloqua's bulk API
Data transfer between Lattice & Eloqua
The Eloqua app constantly polls Lattice for launch update. So, if the user has new data in Lattice, but does not launch the campaign, the Eloqua app does not receive any updates to its leads.
For new leads to be updated in Eloqua, two things must happen
- The user should launch the campaign. This will make the latest data available to Eloqua
- The eloqua app schedule needs to kick in for the app to sync this data in Eloqua
Note: The Eloqua app does not store any account or contact data. Data from Lattice is passed directly to Eloqua. Any temporary data created to facilitate transfer is cleared with-in 24 hours.
Data Sync Frequency: When does the Eloqua app sync data from Lattice
The user has a choice (Daily, weekly, Monthly) to set the sync frequency. But the clock starts immediately after the user activates the campaign.
As soon as the user activates the campaign, the Eloqua app will immediately sync data from Lattice. As long as the campaign remains active, the Eloqua app will try to sync on the user defined schedule e.g if the schedule is daily, the next sync will occur 24 hrs after the current one.
Hint: If you are looking to test syncing data from Lattice, deactivating and activating the campaign is a good way to reset the clock and initiate Eloqua app syncing from Lattice.
Creating New contacts vs. updating existing contacts
The Eloqua app will create new contacts if they don't already exist in the Eloqua lead database. If the lead does exist, those contacts will be updated.
Note: Lattice support custom fields on a contact object, but does not supports writing to Eloqua's custom object.
Contact counts between Lattice & Eloqua
The no of contacts can be different between what is synced in Eloqua vs. what was launched in Lattice.
Different Contacts in Lattice share the same email
Eloqua does not support create leads with the same email id. If the campaign from Lattice contains contacts with the same email id, they will be deduped.
Contact's Email is not a valid Email
Eloqua automatically rejects leads that don't have a valid email. If a contact in Lattice has an invalid email, they will automatically be skipped from syncing to Eloqua. Users can see the no of contacts that has invalid email in the recommendation dashboard with-in the Eloqua App.
API and Conflicts with other integrations
The Eloqua app from Lattice uses the Bulk API's from Eloqua. These are efficient using 1API call per 100K contacts.
The app uses the same Eloqua Bulk APIs that are shared across the account, so if several parallel large data imports (>500k) are queued, Eloqua will spend additional time processing. This will not "block" other integrations though. The import priority is managed by Eloqua Administrators.