Eloqua Integration with Sitecore

Mar 17, 2017


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 Integration with Sitecore

 

 

 

 

 

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.

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

About TA Digital

TA Digital is the only global boutique digital transformation agency that helps organizations realize immediate and long-lasting value through exceptional user experience and data-driven methodology. For nearly two decades, we have been helping clients overcome the lack of scale and resource diversity of small regional agencies and the quantity-not-quality approach of large system integrators. We are known as a global leader that helps marketing and technology executives understand the digital ecosystem, identify operational gaps within their organization and finally ushering them into a more mature and profitable digital landscape.

TA Digital has high-level strategic partnerships with digital experience platform companies like AdobeSAP and Salesforce. TA Digital also has global partnerships with industry leaders like SitecoreEpiserverElastic PathBigCommerce, AWS, Azure and Coveo. The company was also recognized in 2013, 2014, 2015, and 2019 Inc. 5000 list as one of the most successful technology companies in the United States.