Checking email address changes before imports

Selecting the Check Email Address Changes when setting up an import means that the Salesforce Integration app checks for email address changes before running the import. This feature helps marketers keep their records consistent between Eloqua and Salesforce and prevent duplicate records in Eloqua.

To take advantage of this feature, users need to enable the tracking of email address changes in Salesforce. By default, Salesforce history tracking is turned off. The Check Email Address Changes option in the Salesforce Integration app's import configuration dialog is disabled until the app detects that history tracking for the email address field in Salesforce is turned on. The Salesforce Integration app is always looking for the most recent email address in Salesforce and compares it to the contact’s email in Oracle Eloqua.

When users change the email address in Salesforce and synchronize this change to the Oracle Eloqua contact, the history of the Eloqua contact's activities is fully preserved. Note that, based on existing Eloqua rules, a contact’s email subscribe/unsubscribe status and bounceback status are associated with the contact’s email address, not the ID. The following example illustrates this behavior:

  1. First, a brand new Eloqua contact,, is created and is subscribed to receive emails.
  2. The contact then unsubscribes globally.
  3. The contact now changes their email address to in Salesforce.
  4. The contact is imported to Eloqua via the Salesforce Integration app. Following this import, the contact's email address is changed from to The subscription status of the Eloqua contact becomes subscribed because it is a new email address.
  5. If the user chooses to update the email address back to in Salesforce and synchronizes this update via the Salesforce Integration app, the email subscription status of the same Eloqua contact becomes unsubscribed once again, because of the change in step 2.

Learn more

Creating imports

Creating opportunity imports

Creating user imports