Import data from Eloqua Form to Hubilo

Import registrations from Eloqua form to Hubilo:

The Integration of Eloqua with the Hubilo Platform is an interesting and useful feature that allows you the autonomy to avail the functions like:

  1. Import your event registration data directly from your Eloqua Forms to Hubilo.

  2. Export your registration data and session analytics to Eloqua.

Prerequisites to import data from Eloqua Form to Hubilo:

  • Create a Form on Eloqua and ensure to add the following fields to it.

    Fields that Hubilo will support importing from Eloqua:

    1. First Name (mandatory) - firstName

    2. Last Name (mandatory) - lastName

    3. Email Id (mandatory) - email

    4. Contact Number - phone

    5. Gender - gender

    6. Company(Organisation) Name - company

    7. Designation - jobtitle

    8. Country - country

    9. State - state

    10. City - city

    11. Website link - website

    12. Facebook Link - facebook_url

    13. LinkedIn link - linkdin_url

    14. Twitter Link - twitter_url

    15. Instagram link -instagramLink

    16. Hubilo Group ID (mandatory) - trayGroupId

    How to create Eloqua Form? How to create Eloqua Contacts?

  • Copy the attendee group id from your Hubilo Dashboard > event settings & ensure this value is added to the Hubilo Group ID property field on your Eloqua Forms which you wish to import. 

 

Steps to be followed to Integrate Eloqua with Hubilo for Importing registrations:

 

Step 1: Log in to your Hubilo account. Click on "Integrations".

 

Step 2: Find the Eloqua Integration Card under the Integrations Tab and Click on Connect button.Screenshot_2022-12-07_at_18.48.19.png

 

Screenshot_2022-12-07_at_18.49.20.png

 

Step 3: Authentication Workflow:

Click the connect button, choose 'New Authentication', fill in the required details, and log in to your Eloqua account to proceed.

 

 

 

Step 4: The export registration window will open up - You can Skip & click on Next - if you don't wish to export data

 

 

Step 5: Click on Next > Import Registration > Copy the webhook URL (paste it in your notes - as it would be required later) that you will need to configure on Eloqua Form to push registration data to the Hubilo event.

 

 

Setup Eloqua Forms to import data to Hubilo:

 

Step 1: Log in to Eloqua > Click on Forms

 

 

Step 2: Setup your Form - How to create Eloqua Form?

 

Step 3: Ensure to add the following field in your Form to collect the data - as these are the fields that can be imported to Hubilo.

 

You can also create these fields in your Eloqua Contacts - therefore it would be easy for you to simply select and add them to your Forms.

 

Fields that Hubilo will support importing from Eloqua:

  1. First Name (mandatory) - firstName

  2. Last Name (mandatory) - lastName

  3. Email Id (mandatory) - email

  4. Contact Number - phone

  5. Gender - gender

  6. Company(Organisation) Name - company

  7. Designation - jobtitle

  8. Country - country

  9. State - state

  10. City - city

  11. Website link - website

  12. Facebook Link - facebook_url

  13. LinkedIn link - linkdin_url

  14. Twitter Link - twitter_url

  15. Instagram link -instagramLink

  16. Hubilo Group ID (mandatory) - trayGroupId

 

 

Step 4: Preset the Hubilo Group ID field with the correct User Group Id value from the Hubilo dashboard

The Hubilo Group ID field that you have created on Eloqua needs to be mapped with the correct User Group Id value from the Hubilo dashboard

Please ensure that the Group ID from Hubilo's dashboard is updated in Eloqua Fields for the entry to reflect on Hubilo Dashboard.

 

The group ID value can be copied from Settings > Groups> select the particular Group> Copy the group ID and paste it into the field created for each user.

 

 

 

Step 5: Once the Form Fields have been set up > click on the Processing button on the top right.

 

Click on Post Data To Server tab > >

  • Here you have to paste the webhook URL which you copied earlier from Hubilo

  • You will then have to map the Hubilo key names to the Target fields in the configuration on “Post to Server“.

 

 

Fields that Hubilo will support importing from Eloqua:

  1. First Name (mandatory) - firstName

  2. Last Name (mandatory) - lastName

  3. Email Id (mandatory) - email

  4. Contact Number - phone

  5. Gender - gender

  6. Company(Organisation) Name - company

  7. Designation - jobtitle

  8. Country - country

  9. State - state

  10. City - city

  11. Website link - website

  12. Facebook Link - facebook_url

  13. LinkedIn link - linkdin_url

  14. Twitter Link - twitter_url

  15. Instagram link -instagramLink

  16. Hubilo Group ID (mandatory) - trayGroupId

 

Step to automatically send emails when registrants are imported using Eloqua Integrations:

Once the integration is done, toggle on the option 'Send Hubilo's invite email with auto-calendar-block and boost event attendance.' 

 

Select 'Invite all attendees including those imported till now' to send an invite email to everyone imported till now.

Select 'Invite newly imported attendees only' to send an invite email to new attendees only.

Note:

  • Data can only be imported from Eloqua Form to Hubilo - as Eloqua Forms supports functionality to send data via Webhook URL.

  • Only Attendee data will be synced from Eloqua to Hubilo.