Making GA Data Usable in Eloqua
Welcome to part four of my guide to integrating Google Analytics with Eloqua. If you have reached this page and want to read the entire solution guide from the first (thoroughly recommended) then you can find it here: https://greg-staunton.com/google-analytics-tracking-on-eloqua-forms.
In this part of the guide I am going to take you through “Storing your Google Analytics data in Eloqua properly”.
Introduction
If you have followed all of the previous steps your campaigns will:
- Be fully integrated with Google Analytics
- Automatically passing Google Analytics UTM parameter values back to Eloqua
We now need to store this information in robust manner so you can use it for other purposes. Currently you will have all the information stored and easily accessible any time you navigate to the form, click settings and then view submission data. Of course you could manually pull together all of the elements you wish to report on but that will take a lot of time and the chances are you will miss something. You’ve got the best marketing technology at your fingertips in the world so let’s put it to work.
There are two ways we can store this information against the contact in Eloqua:
- Contact Record
- Custom Object
Contact Record
It would be very easy to create the different UTM parameters as contact fields against the contact record in Eloqua and on first pass this might seem like a good idea. We can easily report on them, we can also pull in other data such as lead rating (Explicit, Implicit and Combined). However this has some serious drawbacks:
- Respondents will respond to more than one campaign over time
- Appending and maintaining other data becomes more impossible
Imagine this scenario. A contact hits your campaign landing page in January, the lead gets passed to sales, they sell something. You can tie this information back to the contact record very easily. But what if the contact then submits another campaign form a month later but doesn’t buy anything. If you were to report on the contact records in Eloqua then you could artificially attribute revenue to the second campaign, not the first. Then none of your numbers add up and your report is useless.
Custom Objects
I’m the kind of guy who calls a spade a spade, Data Cards, Custom Data Objects, CDOs, etc are all the same thing – a Custom Object. I will be referring to them as such throughout the rest of the guide.
Just so we are all on a level understanding a custom object holds a load of information – any information – in a different place to the contact record but it is attached to the contact record. This is why you can have loads of custom objects, all unique tied to that same contact.
I always describe custom objects at a base level to clients like this:
“Imagine you are hosting a client dinner and you need to ask your clients about any special dietary requirements and what it is they wish to order from a menu. Would you really want this information stored against the contact record?”
The answer is No. You may wish to email the client back though and include some of there choices as a confirmation in an email, this is one example of what a custom object is used for.
Now we are all up to speed I will continue with this use case.
First of all you are going to need to create a custom object in Eloqua. Go to Audience > Custom Objects > New Custom Object. Then give your custom object a name:
Now you need to add in the different fields for the UTM parameters and you will also need to add in Email Address, this is vital so we can tie the Google Analytics custom object to the contact in Eloqua:
You now need to take two steps. First of all you need to set the email address field in the custom object to the email address field (this makes the tie) and then you need to leave the other fields to (none).
* This is very important, I will explain why in a bit.
You have now created you Google Analytics custom object. The reason that we left the other two fields set to (none), specifically the Unique Code Field is because we want to let contacts have more than one Google Analytics custom object set to them because they may engage through more than one campaign or even through multiple channels on one campaign.
Finally we need to set the form to set all UTM parameter values to the Google Analytics custom object through the campaign form. You need to add the step to Update Custom Object – With Form Values, select the Google Analytics Data custom object and then leave Select Key Field blank. This will create a unique number for each custom object ensuring that they are never overwritten.
So… There you have it. I hope you have found this guide useful. Please don’t hesitate to ask any questions or leave your comments.
Finally if you found this guide useful please share it on twitter using the link below.
[bctt tweet=”Check out this handy guide to making Google Analytics parameters usable in Eloqua” url=”https://bit.ly/2VGYe7K”]
Eloqua Technical: How to capture exactly which campaign, medium, etc, a lead used to come on to your website even though they navigated around several pages before conversion.
I got asked by a subscriber how they could track UTM parameters on the first touch to their website from all mediums, campaigns, etc because contacts where coming to their website, navigating around and then submitting forms. After I helped them they no longer had a...
Eloqua Blog: The benefits of Integrating Oracle Unity with Eloqua
I am getting more and more enquiries about Oracle Unity and what benefits integrating it with Eloqua will bring. To help you better understand this new world I have put together this article. If you want to know more about it or have a project to integrate the two...
Eloqua Guide: How to use the Eloqua Sandbox
In the ever-evolving landscape of digital marketing, it's crucial to have a safe and controlled environment to test new strategies, campaigns, and configurations before implementing them in your live Eloqua instance. Eloqua offers a sandbox environment for this...
Eloqua Progressive Profiling 3: Hiding standard fields when you have the data
When an Eloqua landing loads, provided the user has the Eloqua cookie set, their information is automatically populated which gives you something to play with. The third part part is what I call standard Eloqua form fields (If this is the first piece of the tutorial...
Hey Greg,
Thank you for this informative guide.
I’ve followed all the steps but for some reason, injecting the utms into the custom object fields does not work for me.
Hi Adam,
These guides will take you through this:
https://greg-staunton.com/google-analytics-tracking-on-eloqua-forms
https://greg-staunton.com/eloqua-google-analytics-integration
https://greg-staunton.com/passing-ga-data-eloqua-forms
https://greg-staunton.com/making-ga-data-usable
I will also make an update to this post so noone else has this problem. Sorry about that. Let me know if it works.