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 |
|
Primary Company Roles |
|
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.
Menu |
Description |
||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Eloqua Report |
Select the Eloqua report you want to run. The following reports are available:
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: |
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