Documentation / Product / Integrations / Oracle Marketing Cloud: Eloqua

Oracle Eloqua: Import Contacts and 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

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 FieldLytics User FieldDescriptionType
AssetIdeloqua_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)eloqua_clickctEloqua: Click Countint
count(ActivityType)eloqua_openctEloqua: Open Countint
count(ActivityType)eloqua_sendctEloqua: Send Countint
email(EmailAddress)email unique idEmailstring
emaildomain(EmailAddress)emaildomainEmail Domainstring
max(epochms())eloqua_lastclick_tsEloqua: Last Clickdate
max(epochms())eloqua_lastopen_tsEloqua: Last Opendate
max(epochms())eloqua_unsub_tsEloqua: Unsub Datenumber
max(epochms())last_active_tsLast Active on Any Channeldate
min(epochms())eloqua_firstclick_tsEloqua: First Clickdate
min(epochms())eloqua_firstopen_tsEloqua: First Opendate
set("email")channelsAll Channels Used[]string
set(CampaignId)eloqua_campaign_idsEloqua: Campaign the send was a part of[]string
set(EmailWebLinkurl)eloqua_email_urlsEloqua Email URLs[]string
valuect(ActivityType)eloqua_eventsEloqua Eventsmap[string]intsum
valuect(hash(urlmain(EmailWebLink)))hashedurlsHashed Urls Visitedmap[string]intsum
valuect(hourofday())eloqua_hourlyopenEloqua: Hourly Eventsmap[string]intsum
valuect(hourofweek())eloqua_hourofweekEloqua: Hour of Week Eventsmap[string]intsum
valuect(yymm())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
companycompany_nameCompany Namestring
company_revenuecompany_revenueCompany 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 idEmailstring
emaildomain(email_address)emaildomainEmail 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_provincestateState/Provincestring
titlejob_titleJob Titlestring
zip_or_postal_codepostal_codeZip/Postal 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_tsTime of Last Visitdate
max(epochms())last_active_tsLast Eloua Web Visit 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.

  1. Navigate to Data > Jobs and click the Create New Job button.
  2. Select Oracle Marketing Cloud.
  3. Select the Import Audiences and Activity Data job type from the list.
  4. Select the Authorization you would like to use or create a new one.
  5. Select the Activity checkbox to import Eloqua user activity.
  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.
  8. Select the Visitors checkbox to import Eloqua visitor data.
  9. Select the Keep Updated checkbox to continuously import contact and activity data.
  10. Click the Start Job button. oracle marketing cloud eloqua import configuration