Skip to main content
ON24 Knowledge Center

Eloqua Registrant Data Query Service App

 

Installation and API Credentials

Install the app at https://cloudmarketplace.oracle.com/marketplace/en_US/listing/35458291

Generate ON24 REST API credentials.

 

Add App to Campaign

In your campaign add the Registrant Data Query Service - API version to the canvas

clipboard_eccec64c68d14ce7921c89cdfa44980b2.png

Wait for the app image to turn green and double click on the instance. Click on the edit button at the bottom right to configure the app. If there is a problem creating a new instance of the app, the icon will turn red.

clipboard_e3a38aeeec24dae029ee78e823c88aa9e.png

 

Configure Event Details

The Event Details configuration page will prompt you to add the following:

  1. Client ID 
  2. Token Key
  3. Token Secret
  4. Event ID (if left empty the app will pull data from all events from account)
  5. Batch Job Interval

Click Verify and Continue.

clipboard_e3ea2aec43f737abbe4253d186810b143.png

*Note -  Each initial installation, the API process will synchronize data for the last 15 days on it's first run.  Each subsequent run, the API process will synchronize data for the last 2 days.

Configure Contact Field Mapping

On the Field Mapping for Contacts, select the ON24 Fields from the left column to map to the Eloqua Contact fields in the right column. The ON24 “Email” will automatically map to the Eloqua contact field “Email Address”.

If you want to configure the feeder to map data into a custom object, move on to the next section. If you are only mapping ON24 registrant data to contacts, click on the Configure button and a green check mark will appear. At this point you can close the Cloud Feeder Configuration window.

 

Registrant and Attendee Data to Custom Objects Field Mapping

The custom object requires the 2 fields below:

  1. Email Address: The app will automatically pull in the ON24 Attendee’s email address. In the Custom Object details section assign “Email Address” to the Email Address Field.
  1. Event User Id: The app will automatically pull in the ON24 Attendee’s unique identifier in the ON24 platform which is called the Event User Id. In the Custom Object details section assign “Event User Id” to the Unique Code Field.

NOTE: If you don’t see the custom object in the drop-down list of available custom objects, then the above field mapping was not configured correctly.

Select the custom object from the drop-down list. The ON24 Registrant and Attendee data is available in the drop-down options in the left-hand column, and the custom object fields are listed in the right-hand column.

The custom object can include any of the following fields related to attendee information.

ON24 Field Name Description Required Data Type

Total resources viewed

Total number or resources viewed from the Resource Widget. No Number
Survey question 5 Client-determined survey question asked to the audience. No Text
Survey question 4 Client-determined survey question asked to the audience. No Text
Survey question 3 Client-determined survey question asked to the audience. No Text
Survey question 2 Client-determined survey question asked to the audience. No Text

Survey question 1

Client-determined survey question asked to the audience. No Text
Survey answer 5 User-submitted answer to the survey question. No Text
Survey answer 4 User-submitted answer to the survey question. No Text
Survey answer 3 User-submitted answer to the survey question. No Text
Survey answer 2 User-submitted answer to the survey question. No Text

Survey answer 1

User-submitted answer to the survey question. No Text
Source campaign code Campaign Code fro the originator event (e.g. EHub or Virtual Conference) No Text

Resource viewed 5

Name of 5th resource viewed in the Resource Widget. No Text

Resource viewed 4

Name of 4th resource viewed in the Resource Widget. No Text

Resource viewed 3

Name of 3rd resource viewed in the Resource Widget No Text

Resource viewed 2

Name of 2nd resource viewed in the Resource Widget. No Text

Resource viewed 1

Name of 1st resource viewed in the Resource Widget. No Text

Question and answers

This tag lists the questions asked by the user and answers from presenters. No Large Text

Prospect Engagement Profile

Prospect Engagement Profile URL. No Large Text
Poll question 5 Client-determined poll question asked to the audience. No Text
Poll question 4 Client-determined poll question asked to the audience. No Text
Poll question 3 Client-determined poll question asked to the audience. No Text
Poll question 2 Client-determined poll question asked to the audience. No Text

Poll question 1

Client-determined poll question asked to the audience. No Text
Poll answer 5 User-submitted answer to the poll. No Text
Poll answer 4 User-submitted answer to the poll. No Text
Poll answer 3 User-submitted answer to the poll. No Text
Poll answer 2 User-submitted answer to the poll. No Text

Poll answer 1

User-submitted answer to the poll. No Text
Meeting conversions widget type   No Text
Meeting conversions widget submitted timestamp   No Date/Time
Meeting conversions widget name   No Text
Meeting conversions widget id   No Number
Meeting conversions widget action   No Text

Live minutes

The total number of minutes this user attended the live event. Multiple console launches are aggregated into a single number. No Number
Live end End time of event. No Date/Time

Last archive activity

The date/time this attendee was last known to have an open event console during the archived event. No Date/Time
Get pricing widget type   No Text
Get pricing widget submitted timestamp   No Date/Time
Get pricing widget name   No Text
Get pricing widget id   No Number
Get pricing widget action   No Text
Free trial widget type   No Text
Free trial widget submitted timestamp   No Date/Time
Free trial widget name   No Text
Free trial widget id   No Number
Free trial widget action   No Text

First live activity

The date/time this attendee first opened the event console during this live event. No Date/Time

Event title

Title of the event. No Text
Event time Start time of event. No Date/Time

Event id

ON24 unique event identifier. No Number

Engagement score

This is a number between 0 and 10.0 measuring how engaged a user was based on activity during the webcast. No Numeric
Demo conversions widget type   No Text
Demo conversions widget submitted timestamp   No Date/Time
Demo conversions widget name   No Text
Demo conversions widget id   No Number
Demo conversions widget action   No Text

Custom tags

This tag lists the custom tags related to the event. No Large Text
Cumulative live minutes   No Number
Cumulative archive minutes   No Number
Contact us widget type   No Text
Contact us widget submitted timestamp   No Date/Time
Contact us widget name   No Text
Contact us widget id   No Number
Contact us widget action   No Text

Campaign code

Data stored in the Campaign Code field in Elite. No  Text
Call to actions name 3 Display name of the third CTA widget a user clicked on. No Text
Call to actions name 2 Display name of the second CTA widget a user clicked on. No Text

Call to actions name 1

Display name of the first CTA widget a user clicked on. No Text
Call to actions id 3 Display the unique indetifier of the third CTA. No Number
Call to actions id 2 Display the unique indetifier of the second CTA. No Number

Call to actions id 1

Display the unique indetifier of the first CTA. No Number
Call to actions date 3 Date user clicked on the third CTA widget. No Date/Time
Call to actions date 2 Date user clicked on the second CTA widget. No Date/Time

Call to actions date 1

Date user clicked on the first CTA widget. No Date/Time
Call to actions clicks 3 Display number if clicks of the third CTA. No Number
Call to actions clicks 2 Display number if clicks of the second CTA. No Number

Call to actions clicks 1

Display number if clicks of the first CTA. No Number

Audience url

Audience URL. No Large Text

Asked questions

The number of questions the user asked. No Number

Archive minutes

The total number of minutes this user attended the archived portion of this event. Multiple console launches are aggregated into a single number.  No Number

Answered surveys

The number of surveys the user responded to. No Number

Answered polls

The number of polls the user responded to. No Number

NOTE: The Email Address and Event User Id fields are not shown as part of the field mapping as these fields are mapped automatically by app.

Click on the Configure button and a green check mark will appear. At this point you can close the Cloud Feeder Configuration window.

 

Add App to Program

Depending on what you want to accomplish, you'll either select 'Contact Program' or 'Custom Object Program'. In this case, for ON24-related use cases, Contact data will be referring to Registrant-related information, whereas Custom Object refers to Attendee-related information:

After you select the Program type, select the template from where the canvas will be starting from, in this scenario, it will be a blank template, whether it's for Contact or Custom Object Programs:

 

If you select Custom Object Program, you'll be asked to select a custom object to continue. Further to the bottom we will see how to setup a Custom Object:


 

  • Was this article helpful?