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, user@example.com, is created and is subscribed to receive emails.
  2. The contact user@example.com then unsubscribes globally.
  3. The contact user@example.com now changes their email address to user2@example.com in Salesforce.
  4. The contact user2@example.com is imported to Eloqua via the Salesforce Integration app. Following this import, the contact's email address is changed from user@example.com to user2@example.com. The subscription status of the Eloqua contact user2@example.com becomes subscribed because it is a new email address.
  5. If the user chooses to update the email address back to user@example.com in Salesforce and synchronizes this update via the Salesforce Integration app, the email subscription status of the same Eloqua contact user@example.com becomes unsubscribed once again, because of the change in step 2.

Learn more

Creating imports

Creating opportunity imports

Creating user imports