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.


#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!


#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?


#21

Hi Gaya, Rob,

When you use Webhook URL to pass the Unbounce form field values to your Eloqua form, you can use the Form Confirmation setting “Go to another page” and put your thank you page URL in there. 

Plus you can tick Append form data to URL.

We use this to pass form submission values to an Eloqua thank you page, because in some cases we use a two step qualification process, with JavaScript in the Eloqua page to capture the URL parameters and write them to the Eloqua form values to pre-populate the second form.

Rob, you’ve been advising people they need to have their field names matching between Unbounce and Eloqua forms, but you don’t need to do that.  You just need to make sure you assign the Eloqua field labels correctly to the Unbounce field labels in your Webhook URL.

See this example web hook URL:

https://s1736809697.t.eloqua.com/e/f2?elqSiteID=1736809697&elqFormName=Skills-For-All&firstN…

This landing page is an example case where the initial form submission in Unbounce pushes to an Eloqua form, then we serve a thank you page with a second step qualification form, pre-populated via Append form data and some JavaScript in the Eloqua thank you page.

Try it out with this test string: http://study.upskilled.edu.au/skills-for-all-sa-only/?ef_id=teststring&utm_source=CPC&utm_me…

If you do fill out this landing page form to see what happens with pre-population from the passed URL query parameters on the thank you page,  please put Test Test for first name, last name and 0400000000 for the phone number so you don’t get a call from our sales team.  Unless you want to take a course :-)

Bradley C Hughes
Digital Marketing Specialist
Upskilled Pty Ltd