Eloqua Connector

Intro

Eloqua Corp. is a marketing automation SaaS company which develops automated marketing and demand generation software and services for business-to-business marketers. You can use Domo’s Eloqua connector to compile reports on marketing statistics such as contacts, emails opened, website visits, subscribes and unsubscribes, and so on. To learn more about the Eloqua API, visit their page (https://community.oracle.com/community/topliners/code-it).

The Eloqua connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.

You connect to your Eloqua account in the Data Center. This topic discusses the fields and menus that are specific to the Eloqua connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases	This connector is appropriate for web analytics and digital marketing use cases.
Primary Metrics	Sends Opens Clicks Impressions Form fills Web visits Landing page visits Unsubscribes Subscribes Contacts
Primary Company Roles	Digital marketers Marketing directors Marketing analysts CMOs
Average Implementation Time	50+ hours
Ease of Use (on a 1-to-10 scale with 1 being easiest)	6

Best Practices

Set your "Contacts" report to Replace, not Append (as "Contacts" may change over time).
You may need to make recursive DataFlow if you need a historical record of your contacts. For more information, see Creating a Recursive/Snapshot Magic ETL DataFlow.
For the "Activities" report, set your connector to pull a full history, then reconfigure to do a daily Append (this will let you keep your historical data and move forward and diminish runtime).
If you need to join "Activities" to "Contacts" reports ("Form Submits," "Email Sends," "Email Click-throughs," and "Email Opens"), join on the "CONTACT ID" and to the "ID" fields.
For subscribes, unsubscribes, and bouncebacks, join on "EMAIL ADDRESS."

Prerequisites

To connect to your Eloqua account and create a DataSet, you must have the following:

The username for your Eloqua account
The password for your Eloqua account
The company name associated with your Eloqua account

Connecting to Your Eloqua Account

This section enumerates the options in the Credentials and Details panes in the Eloqua Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your Eloqua account. The following table describes what is needed for each field:

Field	Description
Company	Enter the company name associated with your Eloqua account.
Username	Enter the username you use to log into your Eloqua account.
Password	Enter the password you use to log into your Eloqua account.

Once you have entered valid Eloqua credentials, you can use the same account any time you go to create a new Eloqua DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary Report menu, along with various other menus which may or may not appear depending on the report type you select.

Important: Pulling back excessively large amounts of data may result in Eloqua disabling the user's API connection. Re-enabling the API connection could take up to a few days. Avoid this by limiting the data calls to about 15 million rows per day.

Menu

Description

Eloqua Report

Select the Eloqua report you want to run. The following reports are available:

Accounts	Returns information on all accounts associated with your company for the given number of days.
Bouncebacks	Returns information on all bouncebacks for the given number of days.
Campaigns	Returns information on all campaigns for the given number of days.
Contacts	Returns information on all selected contacts.
Custom Object	Returns information on a selected Custom Data Object.
Custom URL from “Data Export”	Returns information on a Data Export URL that is ready to download. You enter the URL in the Custom Export Report URL field.
Email Click-Throughs	Returns information on the number of users who clicked links in emails sent by your company for the given number of days.
Email Opens	Returns information on the number of users who opened emails sent by your company for the given number of days.
Emails	Returns information on company emails for the given number of days, such as subject line, current status, sender name, creation time, etc.
Email Sends	Returns information on emails sent by your company for the given number of days.
Form Submits	Returns information on the number of users who have submitted forms (either complete or incomplete) on your website for the given number of days.
Form Submits (All Fields)	Returns information on the number of users who have submitted completed forms on your website for the given number of days.
Landing Pages	Returns statistics for landing pages for your website.
Microsites	Returns information on the number of visits to your company’s microsites for the given number of days.
Page Views	Returns information on the number of visits to specific pages in your website for the given number of days.
Subscribes	Returns information on the number of users who have subscribed for the given number of days.
Subscriptions	Returns information on user subscriptions for the given number of days.
Unsubscribes	Returns information on the number of users who have unsubscribed for the given number of days.
Users	Returns information on users of your company’s Eloqua instance.
Web Visits	Returns information on the number of visits to your website for the given number of days.

Note: Data for Eloqua is scattered across numerous reports. With the QuickStart offering, users will not be able to connect data between two individual reports.

Days

Enter the number of days back that should be represented in the report. For example, if you entered 60, the report would contain data for the last 60 days.

Data to be Retrieved

Specify whether the report contains all data or just new data since the last successful run. If there has not been a successful run, the All data option should be used.

Contact Fields

Select up to 95 contact fields. If you do not select any contact fields, the report pulls information for all contacts. Click Clear All to clear all selected contacts.

Custom Object

Select a Custom Data Object from the list.

Custom Export Report URL

Enter the URL for a Data Export that is ready to download. For example: https://secure.p01.eloqua.com/ExportedFiles/customerName/dbb7134f-0305-4e3d-f445-c96971493894

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

FAQ

Can I use the same Eloqua account for multiple DataSets?

Yes.

How frequently will my data update?

As often as needed.

Are there any API limits I should be aware of?

No.

Troubleshooting

The API does not tie to the front-end UI. You will likely have duplicate activities on your "Sends" table.

Suggested Reports

Get up and running quickly with Eloqua data for metrics regarding emails, contacts, landing pages, forms and more by following these suggestions.

Load 180 days of data for the following DataSets to get started.

Email Data

Suggested DataSets to use:

Email Sends
Email Opens
Email Click-Throughs
Unsubscribes
Bouncebacks
Campaigns
Emails

Landing Page Data

Page Views
Web Visits
Landing Pages

Form Submits Data

Form Submits

People Data

Contacts
Users
Accounts

Custom Data

Custom Object