Oracle Marketing Cloud: Eloqua

Overview

Oracle Marketing Cloud: Eloqua is a business-to-business (B2B) marketing automation tool that supports lead scoring and email marketing campaigns.

Integrating Lytics with Oracle Eloqua allows you to import your Oracle Eloqua contacts and activity data into Lytics to build rich, cross-channel audiences. You can also export audiences of users to Eloqua for more precise targeting on your email marketing campaigns.

Authorization

If you haven't already done so, you will need to set up an Oracle Eloqua account before you begin the process described below. Oracle Eloqua supports OAuth2, which allows you to simply enter your username and password to connect Lytics with Oracle Eloqua.

If IP restrictions are enabled for your Oracle Eloqua account, you will need to have an administrator add Lytics' IP addresses to the approved list. Contact your Account Manager for the current list of Lytics' IP addresses. You can read more on Oracle Eloqua customizing access to an IP allowlist.

If you are new to creating authorizations in Lytics, see the Authorizations documentation for more information.

  1. Select Oracle Marketing Cloud from the list of providers.
  2. Select the Eloqua OAuth2 method for authorization.
  3. Enter your Oracle Eloqua username and password into the login screen.
  4. Enter a Label to identify your authorization.
  5. (Optional) Enter a Description for further context on your authorization.
  6. Click Save Authorization.

You are now ready to start an import or export job with Oracle Eloqua.

Import Audiences & Activity Data

By importing your Oracle Eloqua contacts and activity into Lytics, you'll be able to apply Lytics' powerful insights to your email campaigns.

Integration Details

  • Implementation Type: Server-side Integration.
  • Implementation Technique: REST API Integration.
  • Frequency: Data is imported once as a Batch Integration, or continuously on an hourly basis.
  • Resulting data: User Profiles and User Fields.

This integration uses the Oracle Marketing Cloud REST APIs to import user contact and activity data. Once the import is started the job will:

  1. Create a contact export definition to initiate a contact data export.
  2. For each activity type, create an activity export definition to initiate an activity data export.
  3. Create a contact import sync to synchronize the outgoing contact data into a temporary staging area.
  4. Iterate over contact data and reflect all contact changes on the eloqua_contacts stream.
  5. For each activity type, create an activity import sync to synchronize the outgoing activity data into a temporary staging area.
  6. Iterate over activity data and reflect all activity changes on the eloqua_activity stream.
  7. If configured to import Eloqua visitor data, get visitor data since last import and add new visitor data to eloqua_visitors stream.
  8. Schedule next import.

Fields

The following fields are included in the default mapping of the eloqua_activity stream:

Source FieldConditionalLytics User FieldDescriptionType
AssetIdIF eq(AssetType, "Email")eloqua_email_idEloqua: Last Email IDstring
ContactIdExteloqua_contact_id unique idEloqua: Contact IDstring
EmailSendTypeeloqua_email_send_typeEloqua: Last Email Sent Typestring
IpAddressip_addressIP Addressstring
count(ActivityType)IF eq(ActivityType, "EmailClickthrough")eloqua_clickctEloqua: Click Countint
count(ActivityType)IF eq(ActivityType, "EmailOpen")eloqua_openctEloqua: Open Countint
count(ActivityType)IF eq(ActivityType, "EmailSend")eloqua_sendctEloqua: Send Countint
email(EmailAddress)email unique idEmail Addressstring
emaildomain(EmailAddress)email_domainEmail Domainstring
max(epochms())IF eq(ActivityType, "EmailClickthrough")eloqua_lastclick_tsEloqua: Last Clickdate
max(epochms())IF eq(ActivityType, "EmailOpen")eloqua_lastopen_tsEloqua: Last Opendate
max(epochms())IF eq(ActivityType, "Unsubscribe")eloqua_unsub_tsEloqua: Unsub Datenumber
max(epochms())IF ActivityType IN ("EmailOpen", "EmailClickthrough")last_active_tsLast Activedate
min(epochms())IF eq(ActivityType, "EmailClickthrough")eloqua_firstclick_tsEloqua: First Clickdate
min(epochms())IF eq(ActivityType, "EmailOpen")eloqua_firstopen_tsEloqua: First Opendate
set("email")IF ActivityType IN ("EmailOpen", "EmailClickthrough")channelsAll Channels Used[]string
set(CampaignId)eloqua_campaign_idsEloqua: Campaign the send was a part of[]string
set(EmailWebLink)eloqua_email_urlsEloqua Email URLs[]string
valuect(ActivityType)eloqua_eventsEloqua Eventsmap[string]intsum
valuect(hash(urlmain(EmailWebLink)))IF ActivityType IN ("EmailOpen", "EmailClickthrough")hashedurlsHashed Urls Visitedmap[string]intsum
valuect(hourofday())IF eq(ActivityType, "EmailOpen")eloqua_hourlyopenEloqua: Hourly Eventsmap[string]intsum
valuect(hourofweek())IF eq(ActivityType, "EmailOpen")eloqua_hourofweekEloqua: Hour of Week Eventsmap[string]intsum
valuect(yymm())IF eq(ActivityType, "EmailOpen")eloqua_monthlyEloqua: Opens By Monthmap[string]intsum

The following fields are included in the default mapping of the eloqua_contacts stream:

Source FieldLytics User FieldDescriptionType
business_phonebusiness_phoneBusiness Phone Numberstring
citycityCitystring
companycompanyCompanystring
company_revenuecompany_revenueCompany Annual Revenuenumber
company_sizecompany_sizeCompany Sizestring
countrycountryCountrystring
date_createdeloqua_date_createdEloqua: Contact Created Datedate
date_modifiedeloqua_date_updatedEloqua: Contact Last Update Datedate
eloqua_contact_ideloqua_contact_id unique idEloqua: Contact IDstring
email(email_address)email unique idEmail Addressstring
emaildomain(email_address)email_domainEmail Domainstring
faxfaxFax Numberstring
first_and_last_namenameFull Namestring
first_namefirst_nameFirst Namestring
industryindustryIndustrystring
isbouncedeloqua_bouncedEloqua: Contact Bouncedstring
issubscribedeloqua_subscribedEloqua: Contact Subscribedstring
job_roleemployment_roleWork Rolestring
last_namelast_nameLast Namestring
mobile_phonemobile_phoneMobile Phone Numberstring
set(lead_id)salesforce_lead_ids unique idSalesforce: Lead Ids[]string
set(sfdc_contact_id)salesforce_contact_ids unique idSalesforce: Contact Ids[]string
state_or_provincestateStatestring
titlejob_titleJob Titlestring
zip_or_postal_codepostal_codePostal Codestring

The following fields are included in the default mapping of the eloqua_visitors stream:

Source FieldLytics User FieldDescriptionType
contactIdeloqua_contact_id unique idEloqua: Contact IDstring
epochms()lastvisit_tsLast Visitdate
max(epochms())last_active_tsLast Activedate
set(externalId)eloqua_external_ids unique idEloqua: External IDs[]string
set(visitorId)eloqua_visitor_ids unique idEloqua: Visitor IDs[]string
typeeloqua_visit_typeLast Eloqua Web Visit Typestring

Configuration

Follow these steps to set up and configure an import job for Oracle Marketing Cloud: Eloqua in the Lytics platform. If you are new to creating jobs in Lytics, see the Data Sources documentation for more information.

  1. Select Oracle Marketing Cloud from the list of providers.
  2. Select the Import Audiences and Activity Data job type from the list.
  3. Select the Authorization you would like to use or create a new one.
  4. Select the Activity checkbox to import Eloqua user activity.
  5. (Optional) In the Activity Since text box, specify the date to import activity from. Please use the format yyyy-mm-dd, e.g. 2023-01-17
  6. Select the Contacts checkbox to import Eloqua contact data.
  7. From the Contact Fields input, select the Contact fields to import. Leave empty to import all fields. If contacts have more than 250 fields, a set of fields must be specified. An identifier must be included in the selection of fields to ensure that data is properly stitched onto a user profile in Lytics.
  8. Using the Contacts Import Interval dropdown, specify how often to import contacts. Default is Hourly.
  9. (Optional) In the Contacts Since text box, specify the date to import contacts from. Please use the format yyyy-mm-dd, e.g. 2023-01-17
  10. Select the Visitors checkbox to import Eloqua visitor data.
  11. Using the Visitors Import Interval dropdown, specify how often to import visitors data. Default is Hourly.
  12. (Optional) In the Visitors Since text box, specify the date to import visitors data from. Please use the format yyyy-mm-dd, e.g. 2023-01-17
  13. Select the Keep Updated checkbox to continuously import contact and activity data.
  14. Click Start Import.

πŸ“˜

This job configuration must include a Since date associated to the object(s) you wish to import to avoid causing errors in the job.

eloqua-import

Export Audiences

Export Lytics Audiences to Oracle Eloqua to deliver marketing campaigns based on your targeting criteria defined in Lytics such as cross-channel behavior, content affinities, and more.

Integration Details

  • Implementation Type: Server-side Integration.
  • Implementation Technique: REST API Integration.
  • Frequency: Batch Integration every 5 minutes, or when the number of audience members to export exceeds 1,000.
  • Resulting data: Lytics audience(s) in Oracle Eloqua.

This integration utilizes Oracle Eloqua APIs to export Lytics Audiences into Oracle Elqoua. On each run of the job, it will sync your selected Lytics Audiences with your Eloqua account.

Fields

The following fields are included in the default mapping to Oracle Eloqua.

Lytics User FieldDescriptionOracle Marketing Cloud: Eloqua FieldType
emailEmail AddressEmailstring

Configuration

Follow these steps to set up and configure an export job for Oracle Marketing Cloud: Eloqua in the Lytics platform. If you are new to creating jobs in Lytics, see the Destinations documentation for more information.

  1. Select Oracle Marketing Cloud from the list of providers.
  2. Select the Export to Eloqua job type from the list.
  3. Select the Authorization you would like to use or create a new one.
  4. Select the audiences to export.
  5. From the ID Field input, select the ID field in Lytics that will get mapped to an identifying field in Eloqua.
  6. From the Map Fields input, map all the fields from Lytics to Eloqua by selecting the Lytics field on the left and its Eloqua destination on the right.
  7. Click Start Export.

oracle-eloqua-export-configuration