The client has very strict cookie consent settings on their website! As a result, we were missing a lot of form submissions who those don’t consent to tracking. Additionally, we discovered forms had not been tracking for a few months on one of their subdomains, further contributing to the gap that we were seeing on the attribution and lead capture side of things.
In addition to our gaps, we also observed that their CRM did not have solid attribution. Many of their ‘source’ fields were related to recent activities or emails sent, rather than true attribution or even the lead event that drove the lead/opportunity.
Ultimately, this led to a mass amount of CRM data deals & we couldn’t leverage to the client’s CRM source information to gather insights into gaps.
In an effort to close the gap on CRM data deals, we leaned into their Marketing Automation Platform, Marketo, which was also their form builder. We were able to get the clients to give us access to Marketo.
As a result, this allowed me to review and pull lists of historical form submissions. Within Marketo, some not all of the form submissions had attribution tied to them! This was a great sign that we may have something to work off and tie back to our efforts.
We exported the list of form submissions by lead type & had an integration dev (shoutout Rafael) map the Marketo attribution fields to the backend source fields (crm_source, crm_medium, etc.). Once updated, we then created a looker report that then allows our team to have visibility into deals that were categorized as CRM data in RevenueCloudFX but did have attribution in Marketo.
This effort allowed us to tie an additional 25 open/won/lost deals to PPC, 27 open/won/lost deals to SEO, and 5 open/won/lost deals to Paid Social. This allowed us to tie back significantly more deals and revenue back to our campaigns.
Closed gaps on missing deal attribution due to forms not tracking, missing forms due to cookie consent, and lack of attribution in the client’s CRM, which was leading to concerns on investment and ROI of current strategies.
Link to Spreadsheet: https://docs.google.com/spreadsheets/d/1f2Gx2DHuvhvaoeqTU7dbfmwYUWpC2Dhzd0cqnZhTk-g/edit?usp=sharing