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.
- Select Oracle Marketing Cloud from the list of providers.
- Select the Eloqua OAuth2 method for authorization.
- Enter your Oracle Eloqua username and password into the login screen.
- Enter a Label to identify your authorization.
- (Optional) Enter a Description for further context on your authorization.
- 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:
- Create a contact export definition to initiate a contact data export.
- For each activity type, create an activity export definition to initiate an activity data export.
- Create a contact import sync to synchronize the outgoing contact data into a temporary staging area.
- Iterate over contact data and reflect all contact changes on the
eloqua_contactsstream. - For each activity type, create an activity import sync to synchronize the outgoing activity data into a temporary staging area.
- Iterate over activity data and reflect all activity changes on the
eloqua_activitystream. - If configured to import Eloqua visitor data, get visitor data since last import and add new visitor data to
eloqua_visitorsstream. - Schedule next import.
Fields
The following fields are included in the default mapping of the eloqua_activity stream:
| Source Field | Conditional | Lytics User Field | Description | Type |
|---|---|---|---|---|
| AssetId | IF eq(AssetType, "Email") | eloqua_email_id | Eloqua: Last Email ID | string |
| ContactIdExt | eloqua_contact_id unique id | Eloqua: Contact ID | string | |
| EmailSendType | eloqua_email_send_type | Eloqua: Last Email Sent Type | string | |
| IpAddress | ip_address | IP Address | string | |
| count(ActivityType) | IF eq(ActivityType, "EmailClickthrough") | eloqua_clickct | Eloqua: Click Count | int |
| count(ActivityType) | IF eq(ActivityType, "EmailOpen") | eloqua_openct | Eloqua: Open Count | int |
| count(ActivityType) | IF eq(ActivityType, "EmailSend") | eloqua_sendct | Eloqua: Send Count | int |
| email(EmailAddress) | email unique id | Email Address | string | |
| emaildomain(EmailAddress) | email_domain | Email Domain | string | |
| max(epochms()) | IF eq(ActivityType, "EmailClickthrough") | eloqua_lastclick_ts | Eloqua: Last Click | date |
| max(epochms()) | IF eq(ActivityType, "EmailOpen") | eloqua_lastopen_ts | Eloqua: Last Open | date |
| max(epochms()) | IF eq(ActivityType, "Unsubscribe") | eloqua_unsub_ts | Eloqua: Unsub Date | number |
| max(epochms()) | IF ActivityType IN ("EmailOpen", "EmailClickthrough") | last_active_ts | Last Active | date |
| min(epochms()) | IF eq(ActivityType, "EmailClickthrough") | eloqua_firstclick_ts | Eloqua: First Click | date |
| min(epochms()) | IF eq(ActivityType, "EmailOpen") | eloqua_firstopen_ts | Eloqua: First Open | date |
| set("email") | IF ActivityType IN ("EmailOpen", "EmailClickthrough") | channels | All Channels Used | []string |
| set(CampaignId) | eloqua_campaign_ids | Eloqua: Campaign the send was a part of | []string | |
| set(EmailWebLink) | eloqua_email_urls | Eloqua Email URLs | []string | |
| valuect(ActivityType) | eloqua_events | Eloqua Events | map[string]intsum | |
| valuect(hash(urlmain(EmailWebLink))) | IF ActivityType IN ("EmailOpen", "EmailClickthrough") | hashedurls | Hashed Urls Visited | map[string]intsum |
| valuect(hourofday()) | IF eq(ActivityType, "EmailOpen") | eloqua_hourlyopen | Eloqua: Hourly Events | map[string]intsum |
| valuect(hourofweek()) | IF eq(ActivityType, "EmailOpen") | eloqua_hourofweek | Eloqua: Hour of Week Events | map[string]intsum |
| valuect(yymm()) | IF eq(ActivityType, "EmailOpen") | eloqua_monthly | Eloqua: Opens By Month | map[string]intsum |
The following fields are included in the default mapping of the eloqua_contacts stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| business_phone | business_phone | Business Phone Number | string |
| city | city | City | string |
| company | company | Company | string |
| company_revenue | company_revenue | Company Annual Revenue | number |
| company_size | company_size | Company Size | string |
| country | country | Country | string |
| date_created | eloqua_date_created | Eloqua: Contact Created Date | date |
| date_modified | eloqua_date_updated | Eloqua: Contact Last Update Date | date |
| eloqua_contact_id | eloqua_contact_id unique id | Eloqua: Contact ID | string |
| email(email_address) | email unique id | Email Address | string |
| emaildomain(email_address) | email_domain | Email Domain | string |
| fax | fax | Fax Number | string |
| first_and_last_name | name | Full Name | string |
| first_name | first_name | First Name | string |
| industry | industry | Industry | string |
| isbounced | eloqua_bounced | Eloqua: Contact Bounced | string |
| issubscribed | eloqua_subscribed | Eloqua: Contact Subscribed | string |
| job_role | employment_role | Work Role | string |
| last_name | last_name | Last Name | string |
| mobile_phone | mobile_phone | Mobile Phone Number | string |
| set(lead_id) | salesforce_lead_ids unique id | Salesforce: Lead Ids | []string |
| set(sfdc_contact_id) | salesforce_contact_ids unique id | Salesforce: Contact Ids | []string |
| state_or_province | state | State | string |
| title | job_title | Job Title | string |
| zip_or_postal_code | postal_code | Postal Code | string |
The following fields are included in the default mapping of the eloqua_visitors stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| contactId | eloqua_contact_id unique id | Eloqua: Contact ID | string |
| epochms() | lastvisit_ts | Last Visit | date |
| max(epochms()) | last_active_ts | Last Active | date |
| set(externalId) | eloqua_external_ids unique id | Eloqua: External IDs | []string |
| set(visitorId) | eloqua_visitor_ids unique id | Eloqua: Visitor IDs | []string |
| type | eloqua_visit_type | Last Eloqua Web Visit Type | string |
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.
- Select Oracle Marketing Cloud from the list of providers.
- Select the Import Audiences and Activity Data job type from the list.
- Select the Authorization you would like to use or create a new one.
- Select the Activity checkbox to import Eloqua user activity.
- (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
- Select the Contacts checkbox to import Eloqua contact data.
- 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.
- Using the Contacts Import Interval dropdown, specify how often to import contacts. Default is
Hourly. - (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
- Select the Visitors checkbox to import Eloqua visitor data.
- Using the Visitors Import Interval dropdown, specify how often to import visitors data. Default is
Hourly. - (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
- Select the Keep Updated checkbox to continuously import contact and activity data.
- 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.
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 Field | Description | Oracle Marketing Cloud: Eloqua Field | Type |
|---|---|---|---|
| Email Address | string |
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.
- Select Oracle Marketing Cloud from the list of providers.
- Select the Export to Eloqua job type from the list.
- Select the Authorization you would like to use or create a new one.
- Select the audiences to export.
- From the ID Field input, select the ID field in Lytics that will get mapped to an identifying field in Eloqua.
- 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.
- Click Start Export.
Updated 9 months ago