Integrating Eloqua with RingCentral Events

This guide explains how to install and map the Eloqua app on your Organization account and configure your Eloqua account.

What is Eloqua?

Eloqua is a cloud-based B2B marketing automation tool developed by Oracle. Eloqua offers campaign design, advanced lead scoring, real-time firmographic data, and integrated sales tools. To learn more about Eloqua's pricing, you will need to request a demo on their website. 

How does the integration work?

The integration with Eloqua includes the following features:

1. Pull registrations from Eloqua form to RingCentral Events, and push Magic Links back to Eloqua.
2. Push registrations from RingCentral Events to the Eloqua form.
3. Push the 'attended' status to the Eloqua form.
4. Push custom registration form answers to the Eloqua form.
5. Push UTM parameters to the Eloqua form.
6. Push onsite registration and attendee data to the Eloqua form.

Requirements for Eloqua integration

Depending on how you plan to use the integration, you must create a form with a number of fields in your Eloqua account. This form and these fields will be used to install and map your Eloqua account on your RingCentral Events Organization.  

You can either use the same form to import registrations to RingCentral Events and to export data from RingCentral Events, or create two separate forms for import and export. 

• To use only one form for both import and export:

  1. In your Eloqua account, go to Assets > Forms.
  2. Click Create a Form, or use an existing form.
     Tip: For detailed steps, follow the Oracle Eloqua Help Center guide on Creating a form.
  3. The form must include the following fields: 
     • First Name
     • Last Name
     • Email
     • RingCentral Events Magic Link: This field must be created as hidden.
     • RingCentral Events Ticket Integration Code
       • If you only have one ticket in your event, add this as a hidden field in the form that pushes the Ticket Integration Code to the field you have chosen to hold this value.
       • If you have multiple ticket types, add this as a Single picklist field that holds the Integration Codes as stored values, which pushes the stored values to your Ticket Integration Code field when the form is completed.
     • If you want to export more information related to attendee status, UTM parameters, custom form questions, or onsite activity, configure the hidden fields as required.
       

• To use 2 forms, one for import and another one for export:

  1. In your Eloqua account, go to Assets > Forms.
  2. Click Create a Form, or use an existing form.
     Tip: For detailed steps, follow the Oracle Eloqua Help Center guide on Creating a form.
  3. The first form to import data from Eloqua to RingCentral Events must include the following fields:
     • First Name
     • Last Name
     • Email
     • RingCentral Events Ticket Integration Code
       • If you only have one ticket in your event, add this as a hidden field in the form that pushes the Ticket Integration Code to the field you have chosen to hold this value.
       • If you have multiple ticket types, add this as a Single picklist field that holds the Integration Codes as stored values, which pushes the stored values to your Ticket Integration Code field when the form is completed.
  4. The second form to export data from RingCentral Events to Eloqua must include the following fields:
     • First Name
     • Last Name
     • Email
     • RingCentral Events Ticket Integration Code
     • RingCentral Events Magic Link
     • If you want to export more information related to attendee status, UTM parameters, custom form questions, or onsite activity, add the corresponding fields as required.
       

  Important: When using one form for import and another form for export, make sure that HTML names for the fields First Name, Last Name, Email, and Ticket ID are the same in both forms.

  

Installing & mapping Eloqua

To install the Eloqua app on your Organization account: 

1. In your Organization Dashboard, go to the Apps tab.
2. Click Discover more on App Store.
   
   
   
3. In the App store, you can find Eloqua under the CRM integrations and Registration workflow categories.
   
   
   
4. On the Eloqua page, click Install app.
   ✔ You will be prompted to confirm your choice. Click Install to continue.
   
   
   
5. On the Eloqua authentication page, click New authentication.
   
   
   
6. In the pop-up, enter your authentication name (e.g. you can use your Organization's name) and the following Eloqua details. Once ready, click Create.
   • Site name: It is the name of your Eloqua Company. For example, EloquaSandbox.
   • Base URL: The base or root URL of your Eloqua account. For example, https://secure.p01eloqua.com/ (it should not end with "a/").
   • Username
   • Password
     
7. Once the authentication is completed, click Next.
8. On the Map Eloqua Form page, select the form to export your data. Once ready, click Next.
   
   
   
9. On the Map Eloqua Form Fields page, map the fields. Once ready, click Next.
   
   
   
10. On the Import & Export Parameters page, map the Magic Link field and copy the Public URL (it will be explained in later steps where to use the URL).
    
    
    
11. [Optional] On the same page, if you also wish to export registration onto the Eloqua form, map the form fields to the parameters. Once ready, click Next.
    • Status: If a person registers for an event, it will be set to Registered, and if the person attends the event, it will be set to Attended.
    • Registration ID: Registration ID of the person who registered at RingCentral.
    • Event ID: Event ID of your RingCentral event.
    • Event Name: Name of your RingCentral event.
      
12. [Optional] On the Export UTM Parameters page, map the UTM parameters to the Eloqua form fields. Once ready, click Next.
    
    
    
13. [Optional] On the Export Custom Registrations Qs & As page, map your RingCentral Events custom registration form questions to the Eloqua form fields. Once ready, click Next.
    
    
    
14. [Optional] On the Export Onsite Registration Data page, map the onsite parameters to the Eloqua form fields.
    • Event Check-In Time: Time the attendee checked in to the event.
    • Event Check-Out Time: Time the attendee checked out from the event.
    • Session ID: ID of the onsite segment the attendee booked a seat for/attended.
    • Session Name: Name the onsite segment the attendee booked a seat for/attended. 
    • Session Registration Time: Time the attendee booked a seat in the onsite segment.
    • Session Check-In Time: Time the attendee checked in to the onsite segment.
    • Session Check-Out Time: Time the attendee checked out from the onsite segment.
    • QR Code Data: This attribute contains the QR Code data. Please choose a large text data type field for it.
    • QR Code Image URL: This attribute contains the QR Code Image URL. Please choose a large text data type field for it.
      
15. Once ready, click Finish.
    ✔ You'll receive a message confirming the integration has been completed.

Testing the Eloqua Integration

• To test if registrations are imported from Eloqua to RingCentral Events:

  1. Make sure the correct Ticket Integration Code is being used when a registration is created.
     Tip: In the RingCentral Events, retrieve the integration code for each ticket by navigating to the Event Dashboard > Registration > Tickets. Hover over the listing and click the Copy icon to copy URL for each ticket.
     
     
     Then, copy and paste the alphanumeric code from the ticket URL (after the "=" sign) as your integration code.
     
  2. The value that is copied over is added to the Ticket Integration Code field that you have created for that purpose in the import form. In this example, we'll use the Ticket Integration Code as a single picklist option in an Eloqua form:
     
     
     
  3. When you're done, save the form.
  4. Click on Processing.
     
     
     
  5. Select Post Data to Server.
     
     
     
  6. Paste the URL that was copied in step 10 during the mapping of the app in RingCentral events and also map the fields for first name, last name, email and ticket id.
     
     
     
  7. Once done click Save.
  8. Click Actions and select View Form HTML as below. Copy the code and embed it on a test webpage (you can easily do this using Google Sites).
     
     
     
  9. Complete the form with a test registration.
  10. Confirm that the registration has been submitted to the form.
      
      
      
  11. Confirm that the Magic Link has been pushed back from RingCentral Events.
      • If you are using the same form for both export and import then you would see that the Magic Link is created for that registration and posted to the same form.
      • If you have used a different form for submitting the registrations which was selected at the configuration of the app at RingCentral then the Magic Link would be posted to that form.
        
  12. In your RingCentral Events account, go to your Event Dashboard > Registrayion > Magic Link Invites > Manage Invites to confirm that the person has been added there as well:
      

• To test if registrations are exported from RingCentral Events to Eloqua:

  1. Register for the event via the event landing page (use an Incognito window to do a test registration with another account when you're already logged into your Organizer account).
  2. Review the form in your Eloqua account to confrim the registration data has been added to the form.
     Note: If mapped, the attendance status will be updated from registered to attended once you attend the event.