Creating marketing activity exports

You can export the following Oracle Eloqua-generated marketing activities to synchronize data with Salesforce when the activity export group is run:

  • Email send
  • Email open
  • Email click through
  • Subscribe
  • Unsubscribe
  • Bounceback

    Note: Bounceback activities are recorded asynchronously in Oracle Eloqua, which means the Bulk API Activity Created Date (when the bounceback occurred), may not be immediately available to export after the bounceback occurred. Therefore, the Salesforce Integration App is using the upper date limit for a filter one hour before the time of Bulk API sync creation to ensure the bounceback activities have been recorded and synced to Salesforce.

  • Web Visit
  • Page View
  • Form Submit

An export group is a way to combine export payloads and avoid sending duplicate data to Salesforce. For each export group, you can specify up to ten contact fields.

Prerequisites

  • A configured connection
  • When a marketing activity is exported from Eloqua, it can be linked to the corresponding Lead or Contact in SFDC when the associated task is created in Salesforce. This linkage will be successful assuming the correct field mapping, that is provided by default. If there is no SFDC Lead or Contact ID present on Eloqua Contact at activity export time, the activity cannot be linked to a Lead or Contact in Salesforce.

To create a marketing activity export:

  1. In the Salesforce Integration app, click Marketing Activities. The Marketing Activities page is displayed.

    An image of the Marketing Activities tab

  2. Click Create Export.
  3. Enter a unique name for the marketing activity group.
  4. From the Activity Type list, select the activity that you want to export.

    An image of the Marketing Activities list

  5. If you select Email Send, Email Open, or Email Click Through, you can leave the default Email Send Type value of All or select another option from the list. These options are Eloqua email channels that can filter the export based on the way the email activity data was sent. For example, if you select Campaign, the export will only include email activities sent via the campaign canvas. This would limit the exported data and make the export complete more quickly than if you included all sources.

    If you select an option other than All, the Filter Rule option is displayed, which allows you to include or exclude the specified email send type.

  6. In the Contact Field Availability section, enter up to 10 contact fields to be used for export field mapping. Alternatively, you can click Browse Fields to display all contact fields you can choose from.

    An image of the Marketing Activities' export group's contact field selector

    Important: There is a maximum of 10 contact fields allowed in an activity export definition. The addition of contact fields to activity exports will add to export time.

  7. In the Filter Activities section, you can specify the criteria that must be met for an activity to be sent to Salesforce. You can use the Eloqua contact fields you specified in the Configure Marketing group section.

    Note: The maximum number of conditions for one marketing activity is 5. Additionally, empty values are allowed in the value field, and reports will not contain Filtered Records if none of the records are filtered. If the filter is applied, the reports will display how many records were filtered out of the total.

    To add further conditions to your marketing activity, click Add Condition.

  8. Click Next. The Create Marketing Activity page is displayed.

    An image of the Marketing Activities' export group's Exports section

  9. Define the following options for an export within the group.
    • Export Name: Provide a name for the export that is unique within the export group.
    • Connection Name: Choose a connection.
    • Salesforce Object: Select the target Salesforce object from the list.
    • Action Type: There are two action types: Create or Update. Create is typically used to create a new task in Salesforce and associate it with Salesforce Contact or Lead. For Subscribe and Unsubscribe marketing activities, choose the Update action type to configure Salesforce Lead or Contact email subscription status updates.
    Default mappings are displayed for the export in the Update Salesforce Fields section.

    An image of the Exports' Update Salesforce Fields section

  10. Adjust any of the mappings between the From Eloqua and To Salesforce fields and add any related objects that you need.

    Note: The fields available for mapping in the Contact section are limited to the fields you selected in the Contact Field Availability section.
    An image of the Exports' Contact section with the list of fields selected from the

  11. Click Create Export.

    You will be redirected to Marketing Export Created page. From this page, you have three options:

    • Close: Return to the Marketing Activities page.
    • Enable: Run the every 15 minutes.
    • Create Export: Create another export. Create additional exports as needed.

Once your export is enabled, it runs and is then automatically started 15 minutes after each prior export has finished.

You can determine whether a marketing activity export was successful or partially succeeded by expanding an export group and selecting View Report from an individual marketing activity export's An image of the Edit Icon menu.

Clicking Disable temporarily stops the exports. If the export is currently running and has not yet started syncing to Salesforce, the export is canceled and disabled. If the export has begun, it will finish and then be disabled.

Learn more

Salesforce Integration app

Viewing report data

Exporting activities

Activities export definitions

Activity fields

Salesforce app, SFDC, marketing activities, email send type, BatchWizard, Batch Wizard, Quicksend, SOAPAPI, SOAP API, Salestools, FormProcessingStep, Form Processing Step, DCOServicesStep, DCO Services Step, ExternalTest, External Test, TestCenter, Test Center, Deliverability, LowVolumeAPI, Low Volume API, Campaign