Understanding Lytics / Integrations

Oracle Marketing Cloud: Eloqua

This article covers:

Authentication

  1. Navigate to the Oracle Marketing Cloud integration in the Integrations section of Lytics.

    app

  2. If this is your first time using Eloqua you will be prompted to choose one of integrations explained below. Choose one.

  3. Connect Eloqua to Lytics by selecting Add new authorization. NOTE: You will only do this once.

  4. You will be redirected in the browser to Eloqua to login and authorize Lytics to connect to the Eloqua account.

    oauth

  5. After completing the authorization, you will be bounced back to Lytics to add a description so it can be identified from other Eloqua auths. Enter a description then hit "Authorize" to save. Your credentials are now stored securely and are available for quick use when starting new Eloqua works.

    connect

  6. If IP restrictions are enabled for your Eloqua account you will need to have an administrator whitelist Lytics' IP address. The IP that needs to be whitelisted is 104.154.89.25.
    1. If you are an administrator the whitelist settings can be found under settings -> security -> IP.
    2. Click the Create IP Address Range button.
    3. Paste the Lytics IP address (104.154.89.25) into the both the start and end ranges, and name the range Lytics.
    4. Click the Save button to create the whitelist entry for Lytics.

Export to Eloqua

Initiating this workflow exports a Lytics Audience to a Eloqua Audience Segment

Summary
FrequencyReal-time
Exports toAudience Segment
Namelytics + segment slug name
Identifierscustom, usually to email
Mapped Fieldsyes
Segment Exportsyes
Typeadd & remove
  1. Connect Lytics to Eloqua if you have not previously done so. See Authentication above.

  2. Click Export to Eloqua.

  3. Use the Segments input to select the segments you want to send to Eloqua.
  4. From the ID Field drop-down, select the Lytics field that contains the identifying field in Eloqua (usually email)
  5. Use the Map Fields input to map Lytics fields to Eloqua contact fields. Select Lytics data fields from the left drop-down list and Eloqua fields from the right drop-down list. Note: the ID Field must be mapped.

    export

  6. Click Start Export. Contacts should be available in the Eloqua Audience Segment within a few minutes of starting the export. Larger audiences may take a few hours to be completely added to the segments.

  7. In Eloqua, navigate to Audience > Segments to find the newly created segments,

    eloqua_segments

Import Contacts and Activity

Import contact and contact activity from Eloqua

Summary
FrequencyHourly
Streamseloqua_contacts, eloqua_activity
User fieldsemail, first_name, last_name, custom fields
Provider fieldsEloqua Contact ID, IsSubscribed, IsBounced
User activitysends, opens, clicks
Campaign contentno
Click URL paramnone
  1. Connect Lytics to Eloqua if you have not previously done so. See Authentication above.

  2. Click Import Contacts & Activity

  3. Select the Activity checkbox to contact activity data into Lytics.
  4. Select the Contacts checkbox to import contact profile data into Lytics.
  5. (Optional) Use the Contact Fields input to select the user fields you wish to import into Lytics. Leave Contact Fields empty to import all contact fields. There is a limit of 250 fields, so if the account has more than 250 fields, fields selection is required to get under 250 fields.
  6. Select Keep Updated to continually import contact and activity data.

    import

  7. Click Start Import. Contact data should be available in the account within the hour. If Keep Updated is selected the import will run continuously until a user terminates the import.