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.
- Implementation Technique: REST API.
- Frequency: Data is imported once in a batch process, 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 | Lytics User Field | Description | Type |
|---|---|---|---|
| AssetId | 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) | eloqua_clickct | Eloqua: Click Count | int |
| count(ActivityType) | eloqua_openct | Eloqua: Open Count | int |
| count(ActivityType) | eloqua_sendct | Eloqua: Send Count | int |
| email(EmailAddress) | email unique id | string | |
| emaildomain(EmailAddress) | emaildomain | Email Domain | string |
| max(epochms()) | eloqua_lastclick_ts | Eloqua: Last Click | date |
| max(epochms()) | eloqua_lastopen_ts | Eloqua: Last Open | date |
| max(epochms()) | eloqua_unsub_ts | Eloqua: Unsub Date | number |
| max(epochms()) | last_active_ts | Last Active on Any Channel | date |
| min(epochms()) | eloqua_firstclick_ts | Eloqua: First Click | date |
| min(epochms()) | eloqua_firstopen_ts | Eloqua: First Open | date |
| set("email") | channels | All Channels Used | []string |
| set(CampaignId) | eloqua_campaign_ids | Eloqua: Campaign the send was a part of | []string |
| set(EmailWebLinkurl) | eloqua_email_urls | Eloqua Email URLs | []string |
| valuect(ActivityType) | eloqua_events | Eloqua Events | map[string]intsum |
| valuect(hash(urlmain(EmailWebLink))) | hashedurls | Hashed Urls Visited | map[string]intsum |
| valuect(hourofday()) | eloqua_hourlyopen | Eloqua: Hourly Events | map[string]intsum |
| valuect(hourofweek()) | eloqua_hourofweek | Eloqua: Hour of Week Events | map[string]intsum |
| valuect(yymm()) | 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_name | Company Name | string |
| company_revenue | company_revenue | Company 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 | string | |
| emaildomain(email_address) | emaildomain | 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/Province | string |
| title | job_title | Job Title | string |
| zip_or_postal_code | postal_code | Zip/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 | Time of Last Visit | date |
| max(epochms()) | last_active_ts | Last Eloua Web Visit 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 Jobs Dashboard 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.
- 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.
