Eloqua Integration with Sitecore

By Sitecore Practice Team 2 min read

Recently we had a requirement to track download of selected media library assets and also to collect some basic information about the visitor (which can vary from file to file and should be based on the form defined in Eloqua) and post it to Eloqua.

To accomplish this, we have created a new template “CustomMedia” that contains a checkbox field named “Track with Eloqua” and a General Link field named “EloquaLink” as shown below.

Eloqua
The first field indicates which asset downloads need to be tracked. The second field is a reference to the Eloqua form associated with the download.

The following templates were updated to inherit the “CustomMedia” template:

  • “sitecore/templates/System/Media/Unversioned/File”
  • “sitecore/templates/System/Media/Versioned/File”
  • “sitecore/templates/System/Media/Media Folder”

The next step is to create a custom MediaRequestHandler that will retrieve the associated form id for the media asset being downloaded, fetch the form fields from Eloqua and render them on a page for the user through a sub layout. When the page is submitted, the form field values are posted to Eloqua and the user is redirected to the asset download. If needed, a cookie can be used to hold the user-entered values so that the user need not enter form values on each download.

The web.config file needs to be updated to add the custom handler.

The last step is to integrate the Eloqua form with Sitecore for which we have created a new template containing a Single-Line text field named “FormId”. These items will contain the ids of the Eloqua forms and can be associated with the media assets for which we need to track the downloads.

Explore Additional Resources

Learn how you can select the best Digital Experience platform for your business.

Our Certified Sitecore Experience Platform and Sitecore MVP’s specialize in helping you deliver seamless contextually personalized customer experiences.

Our Consulting team specializes in providing Eloqua health checks to help you identify performance and process gaps in your Oracle Marketing Cloud.

GET HELP FROM OUR EXPERTS

Over the past 19 years, we have completed thousands of digital projects globally. We have one of the largest and deepest multi-solutions digital consulting teams in the world. Our proprietary processes and years of Digital Experience expertise have earned us a 97% customer satisfaction rating with our clients ranging from Global Fortune 1000 to Mid-Market Enterprises, leading educational institutions, and Non-Profits.

If you would like more help on Eloqua Integration with Sitecore Contact Us Today.

About TA Digital

TA Digital is the only global boutique agency that delivers the “best of both worlds” to clients seeking to achieve organizational success through digital transformation. Unlike smaller, regional agencies that lack the ability to scale or large organizations that succumb to a quantity-over-quality approach, we offer resource diversity while also providing meticulous attention to the details that enable strategic success.

Over the past 20 years, TA Digital has positioned clients to achieve digital maturity by focusing on data, customer-centricity and exponential return on investment; by melding exceptional user experience and data-driven methodologies with artificial intelligence and machine learning, we enable digital transformations that intelligently build upon the strategies we set into motion. We are known as a global leader that assists marketing and technology executives in understanding the digital ecosystem while identifying cultural and operational gaps within their business – ultimately ushering organizations toward a more mature model and profitable digital landscape.

Recognized in 2013, 2014, 2015, and 2019 Inc. 5000 list as one of the most successful technology companies in the United States, TA Digital is pleased also to share high-level strategic partnerships with world class digital experience platform companies like Adobe, SAP and Salesforce and possess global partnerships with industry leaders such as Sitecore, Episerver, Elastic Path, BigCommerce, AWS, Azure and Coveo.

Sitecore Practice Team

Written By

Sitecore Practice Team