Unbounce Eloqua integration: a how-to


#1

Unbounce doesn’t advertise an integration with Eloqua but it’s fairly easy to do using the “Post form data to a URL” form confirmation option.

First, become familiar with “Blind Form Submit” links - this is what we’ll use to post Unbounce form data to Eloqua: http://topliners.eloqua.com/groups/cx…

So your “Post form data to a URL” field will look like this: http://s1234.t.eloqua.com/e/f2?elqFor… (replace 1234 with your own site ID and FormName with the name of your form)

the next step is configuring your form in Eloqua to map the Unbounce data correctly. You can do this in two ways: 1) change the HTML names of the Eloqua fields to the syntax Unbounce uses (e.g. name, email, etc.) or 2) use the “Post form data to a URL” field to map the unbounce fields to whatever your HTML field names might be in Eloqua - e.g. http://s1234.t.eloqua.com/e/f2?elqFor…

That’s it! Your Unbounce forms now work perfectly with your Eloqua instance.


#2

Hey Rob,

Thanks for sharing this with our community! It seems like this is a pretty straightforward workaround to achieve an Eloqua integration, so I’m sure our customers will appreciate the how-to. Was this workaround something you discovered in your own testing? How has it worked so far?

Also, just for the record here, we are still looking at a direct integration with Eloqua down the road - but feel free to use this solution in the meantime.

Thanks Rob!


#3

I’ve used webhooks to “hack” an Eloqua integration in the past so I figured this would work for me. Thanks for the update re: the direct integration!


#4

Hi Rob and Justin,

Has there been an official integration with Eloqua setup yet?

I’ll test this work around in the meantime.

Thanks!


#5

Hi Michael, 

I’m going to pass this over to Meagan Sobol, our Product Development Manager, so she can chime in with where we’re at re: Eloqua integration. 

Hang tight!


#6

Hi Michael, 

Thank you for reaching out to find out about our plans to release a Eloqua and Unbounce integration. If others in the community also feel that a Eloqua integration would make their lives easier, please chime in and +1 the idea above as well.

At the beginning of 2015 we took steps forward as a organization to ramp up our integration efforts and we have some awesome integrations lined up. I’m happy to say that another highly requested integration (Marketo) is currently underway and we are starting to gather requirements for other integrations like Wordpress and Eloqua. 

We ask for your continued patience while we work towards an official Eloqua integration.

Please keep the feedback coming as it will continue to help us define the integration requirements and ensure we deliver an awesome solution between Eloqua and Unbounce that will not only meet but hopefully exceed your expectations.

Thank you,


#7

Hi Michael,

In addition to my method posted above, you can also use Unbounce’s WebHook integration available on the page overview screen. It’s similar to the “post data to URL” option but allows you to use form confirmation dialogs in Unbounce, which can be a bonus.

You use the same URL for the WebHook as you would use for the post to URL, with a few modificactions. So, for example, this:

http://s1234.t.eloqua.com/e/f2?elqFormName=FormName&elqSiteID=1234

Becomes (for me) this:

http://s1234.t.eloqua.com/e/f2?elqFormName=FormName&elqSiteID=1234&firstName=(first_name)&lastName=(last_name)&emailAddress=(email)

Where 1234 is your Eloqua ID; FormName is your Eloqua form name; firstName, lastName, and emailAddress are the HTML field names in your Eloqua form; and first_name, last_name, and email are your field names and IDs in Unbounce.

One thing to note: if you are using a “Post Data to Server” form processing step in your Eloqua form, the WebHook will NOT execute that step. For reasons unclear to me, if you’re using the post data to URL in Unbounce, it WILL execute the step. This caused considerable headaches for me last week as I was trying to send data from Unbounce > Eloqua > GoToWebinar.


#8

Rob, 
Thanks so much for chiming in here! This is a huge help. :) 


#9

Rob,

My webhook looks like this: 
https://s1234.t.eloqua.com/e/f2?elqFormName=formname&elqSiteID=1234&fullName=full_name&company1=company&emailAddress=email&busPhone=business_phone&country1=country&numberOfEmployees11=number_of_employees

Whenever I submit a test form, the submission data in Eloqua only shows variables such as “full_name”, “company”, “email”, “business_phone”, etc. It does not actually show my name and other test variables. What am I doing wrong?


#10

Hi Anthony,

If you’re using a webhook, you need to use parentheses to have Unbounce insert the field submissions into the webhook URL. So, assuming your unbounce fields are in fact named full_name, company, email, business_phone, country, and number_of_employees, your webhook URL should look like this:

https://s1234.t.eloqua.com/e/f2?elqFormName=formname&elqSiteID=1234&fullName=(full_name)&company1=(company)&emailAddress=(email)&busPhone=(business_phone)&country1=(country)&numberOfEmployees11=(number_of_employees)

Hope this helps!

Rob


#11

Thanks for the reply Rob! Stupid question: when using this type of webhook with Eloqua, do I still need to a write PHP script? Or just use the URL string with the (parameters)? You didn’t mention that above but saw it in the webhook link.

Also, when using the URL string (see below) in the “Post form data to a URL” option within the form editor, I am still getting form labels when test submitting a form. Not actual name, email, etc. Any thoughts?

https://s1234.t.eloqua.com/e/f2?elqFormName=formname&elqSiteID=1234&fullName=(full_name)&company1=(company)&emailAddress=(email)&busPhone=(business_phone)&country1=(country)&numberOfEmployees11=(number_of_employees)

Thanks for the help!


#12

Shouldn’t need to write a PHP script, no – the URL should do just fine.

I’m afraid I’m not sure exactly what’s going on in your instance. You’re not using the webhook and the post form data to URL at the same time are you? They’re not required simultaneously (just two separate options) and using both at the same time might be causing an issue.

Some other things to double-check:

Then, make sure your Unbounce Field Name and IDs are exactly the same as your Eloqua HTML names (so e.g. for the email address, if the Unbounce Field Name is ‘email,’ your Eloqua HTML name should be too). Unbounce will automatically append the form data to the URL for you and you can see if it’s coming through or not.

Rob


#13

Thanks for the help Rob. I have not been using a webhook and the “Post form data to URL” option at the same time. Trust me, I have checked. ha

So, I pasted the http://s1234.t.eloqua.com/e/f2?elqFormName=FormName&elqSiteID=1234 into the “Post form data to URL” option (without the parameters) and made sure the field names matched. Once tested, I saw the correct form information (my name, email, etc). 

After trying that, I ensured the field names matched in the webhook URL and it still did not work. Within the submission data in Eloqua, the values are just (full_name), (email), etc. No real form data. See here – http://imgur.com/3AYRTXR

Do I need to configure the field mapping? The only way I can get (full_name) to show in the Eloqua submission data is to use what is seen here – http://imgur.com/gRd26iN I have tried using (full_name) under “Webhook (POST to URL) field” but it does not work.

Any thoughts?


#14

After trying that, I ensured the field names matched in the webhook URL and it still did not work. Within the submission data in Eloqua, the values are just (full_name), (email), etc. No real form data. See here – http://imgur.com/3AYRTXRAre you publishing the page and actually submitting test form data, or is this data coming through after you test the webhook in Unbounce’s web app? When I do the latter, I see the same thing (e.g. http://i.imgur.com/BOu3g9t.png). It’s not until I publish the page and run a test myself on the live URL that I see submitted form data coming through.> Do I need to configure the field mapping? The only way I can get (full_name) to show in the Eloqua submission data is to use what is seen here – http://imgur.com/gRd26iN I have tried using (full_name) under “Webhook (POST to URL) field” but it does not work.Honestly, I don’t even touch that field mapping stuff. I mean, mine looks like this but Unbounce did that automatically; I didn’t set anything up myself. The (parameters) in the URL are supposed to take care of that programatically.


#15

Thank you so much for your help Rob. I did not realize you had to publish the page and thought I had tried that before. Guess not. ha It’s up and running now. 

Thanks again!


#16

Rob, you’re the best.

 


#17

Hi Rob, thanks for posting this. So we gave it a try and even though Unbouce recognizes the form the data doesn’t feed into the Eloqua fields. There is a field called “data.json:” and there’s where all the customer data pulls in a jumbled mess. Any idea why this is happening?


#18

Hi Gaya,

Are you using the blind form submit method (the one in the original post) or the webhook method (see my first reply to Michael above)?

In any case, it’s likely that your fields are not mapped correctly. Make sure the Unbounce field names (http://i.imgur.com/lmmLN8W.png) match the Eloqua HTML names (http://i.imgur.com/PBDRJNI.png) exactly. I get the “data.json” jumbly mess in my submitted forms as well, but if I map the fields correctly it pulls the data into the Eloqua fields just fine.

Rob


#19

Thanks for chiming in, Rob! This bit is helpful.


#20

Hi Rob, thank you! We got this to work, however now once the form is completed the site visitor is directed to a blank page. Any ideas on how we can redirect people to a thank you page?