The Challenge

Most companies run regular events. This means Eloqua assets need to be updated for each new event. That usually means the involvement of a marketing automation team member to execute the technical changes. The time between “request > execute > approve > go live” can span from hours to a couple of days. We like to think of clever ways to reduce this as much as possible at Sage, while sticking to our processes and standards of quality.

The challenge was to enable the webinar team at Sage to update form pick-lists with upcoming event dates and remove event dates that had already taken place. We didn’t want to provide Eloqua licences for the webinar team, nor did we want to involve the marketing automation team to make these basic form updates on a daily/weekly/monthly basis.

The solution for this challenge would allow ongoing webinar landing pages and pick-lists to be updated by the webinar team. This allows webinar programs to go on for months without the need for marketing automation intervention.

 

Applications and knowledge required -

You’ll need the following:

  • Access to Oracle Eloqua
    • Knowledge of using Landing Pages and Forms
    • HTML
    • jQuery
  • Instructions for TableTop.js.
  • A Google Account and access to Google Sheets


What you need -

 

  • You will need a Google Sheet to store some data. In this case we want to store “status”, “date” and “key”.

 

    •   You will need to publish the Google Sheet to the web

 

      • File > Publish to the web
      • Under the Link tab change from “Entire Document” to  “sheet 1”

 

 

  • You need an Eloqua landing.
  • You will need to build a form on your Eloqua landing page
    • Add the relevant form fields and your target fields to populate the Google Sheet data
  • Add the javascript library TableTop.js to your landing page. This has the ability to pull data from a Google sheet. (you will be using your Google Sheet just like a json database)
  • You must write some javascript/jquery in order to use your google sheet data in the pick-list in your form. Here is an example of a custom script we use at Sage:

 

 

  • Save the landing page, go to your form and test your connection between the landing page and Google Sheets. If the values from the Google Sheet populates in your target field, then the integration has been successful.

 

This will take a bit of work, practice and research, but in the end it’s totally worth it.


Result

 

By connecting Google Sheets with TableTop.js on an Eloqua Landing Page, we are able to populate values in a pick-list in real-time from a Google Sheet.

 

Prior to this implementation the team would need to request updates via the Marketing Automation Team. This would generally take a couple of days to go through our whole build process.

We would typically receive at least 50 separate requests from this particular webinar team each month. By implementing this dynamic form across all of their multi-webinar campaign forms, we have saved at least 50 hours per month of our Automation Teams time.

The webinar team now have control and the self-serve ability they require to add future dates to the landing page form. As a result no Marketing Automation Team intervention is required for new event updates. The Marketing Automation Team can focus more time on other cool projects and innovations.

This project was inspired by the Oracle Marketing Cloud University - Luminary Courses:

  • B2B: Develop and Design
  • B2B: Advanced Criteria Functions