HMH: Eloqua campaign reporting on SFDC Dashboards
Client Challenge
HMH approached Automate2Revenue who I was contracted to with the following objectives:
- Deliver SFDC CMO dashboards in Early 2021 that reflect current lead management state
- Agree on an approach for lead and campaign management using industry best practices
- Demonstrate how implementing the proposed Lead Management and Campaign Management strategy will:
- Meet both current and prospective customer needs
- Help achieve transformational goals and revenue objectives
- Address internal data pain points
Their issues surrounded two distinct areas that needed to be addressed in order to facilitate accurate CMO dashboards in SFDC that would allow granular reporting that was robust enough to drill right down into the return on investment of each campaign on each medium.
As well as optimizing their approach to campaigns so we could build the SFDC dashboards the following other issues needed to be addressed
Lead Management
- Missing key data on lead and contact records
- 43,924 leads rejected this year. (26k in September likely due to a clean up)
- Too many values for lead status
- No consistency between lead and account status
- 41,258 with no Original Lead Source
- Inadequate user experience due to digital experience with forms on website
Campaign Management
- Channels are inconsistent and often not accurate
- Campaigns are created in Workfront with little to no connection to Eloqua
- Social campaigns created in Sprinklr
- Google Ads inconsistent and not able to be tracked currently in Eloqua or Salesforce through automated means
- Campaign responses are inconsistent
- Webinars are not currently tracked effectively
Approach
I took a backwards approach, back tracking from the goal, namely creating these CMO dashboards in Eloqua. Below is an overview of the technical solution design.
Solution overview
I broke out the following areas that needed to be addresses in order to facilitate Eloqua feeding SFDC the appropriate data to facilitate custom CMO dashboards.
- Minimum mandatory fields
- Eloqua / SFDC integration app migration
- Standardize campaign templates
- Sprinklr / GA / Eloqua integration
- Template form types
- Marketing lead status
- Workfront integration
- Rejected & recycled lead program
- 2020 lead source program
Solution 1: Minimum mandatory fields set
The following items were addreses
- Minimum mandatory fields needed to be for contact data
- Picklists created for:
- Lead status
- UTM Medium
- UTM Source
- UTM Campaign
- UTM Term
UTM Source, Campaign and Term are self explanatory, UTM Medium was finally agreed and the marketing lead source set to this:
Lead Source (UTM_Medium) | Description |
CPC | All digital paid advertising, including paid social |
Internal HMH customer-facing emails | |
SOCIAL | All organic posts on Facebook, Twitter, LinkedIn and YouTube |
Print advertising booked through the agency | |
PAID MEDIA | Digital advertising booked through the agency for education-specific sites and emails with limited audiences |
DIGITAL PRINT | Digital versions of the print ads above |
EXTERNAL EMAIL | Subset of paid media; dedicated, advertorial emails sent out through partners. |
MICROSITE | A specific subset of paid media; |
DIRECT MAIL | Print materials (brochures, flyers, postcards) distributed through mail, sales reps, and online |
SEARCH | Incoming traffic from Search engines |
Solution 2: Eloqua / SFDC integration app migration
As of the 21st February 2021 Oracle no longer supported Eloqua native integration studio
This presents the opportunity to:
- Redesign and fully map the SFDC integration
- Implement closed loop reporting – even though our actual reporting was to be done using lead, contact, campaign member and opportunity objects in SFDC.
Solution 3: Standardized campaign templates
We developed standard campaign canvas workflow templates for:
- One shot emails
- Lead nurture
- Tradeshows
- Webinars
- Sampling site
Solution 4: Eloqua / Sprinklr integration
Install and setup Sprinklr integration apps:
- Sprinklr / GA integration
- Sprinklr / Eloqua integration
Solution 5: Template form types
Template forms for were created for all form types
We then used this opportunity to move into progressive profiling but that did mean a landing page template standardization by type
Solution 7: Workfront integration
We explored Eloqua / Workfront integration how ever it ended with not being required – The Workfront integration still isn’t suitable for Eloqua, you can read more about it in my in depth blog post: https://greg-staunton.com/eloqua-workfront-integration – Seriously though you are better off with Oracle Content Manager or Compendium in old money.
Solution 8: Rejected and Recycled lead program
REJ leads will be analyzed and the profile model will be updated
REC leads will be analyzed and the engagement model updated, they were then going to be put into a lead nurture program
* Best in class:
MQL -> SAL = 90%
SAL -> SQL = 70%
Solution 9: 2020 lead source program
We created a program to assign:
- Lead source original from lead CDOs
- Create a lead source washing machine
Impact
I don’t really feel the need to talk about the impact to be honest. The images tell you everything you need to know.
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...
Thanks for the helpful article! Can you elaborate on the lead source program? The results certainly are impressive!
How have you tracked first/last touch in Eloqua? How have you mapped this to account/opportunity?