ExtraHop's very talented digital analyst had accepted a new job at a different company.
Their web analytics, Salesforce reporting as well as reporting rhythm was driven by this individual. And everything he did - all that institutional knowledge - was not documented prior to his departure. When he left, the knowledge left with him.
Besides his position, there was a lot of turnover in other key roles within the marketing department.
To top it off: the new marketing leads at ExtraHop wanted to adjust marketing reporting to focus more on business metrics (opportunities, pipeline create, revenue driven) to move beyond the reporting that had been used in years past.
Get Analytics Tips and TricksWe had worked with ExtraHop for a few years at this point so we had built up a great deal of trust over that time.
Even though we had never taken on an analytics project this large, they trusted us to work through this with them to become the replacement to their in-house digital analyst.
See How We Work Together“ExtraHop wanted to look at different metrics than had been looked at in the past. We elped guide them through that and made sure that we got everything in a row for them to be able to look at what they were requesting. These changes were drastically different. Before they focused on MQL numbers. The new team wanted to look at pipeline create and how much business that the marketing team was actually driving.”
~ Spencer Mayes
As we dove into this project, we realized it really hinged on clean data being integrated through every step of the measurement funnel.
Bad data in equals bad data out in our marketing reports. This project started by cleansing data from first marketing touchpoint through to a sale.
Now that we had clean data flowing into Salesforce, the next step of our work focused on ensuring the Data Quality from the integrations and processes we created was correct.
Again: bad data in equals bad data out in our reports.
Our team invested time test driving all the data integrations for systems or processes we integrated to guarantee that the data flowing into Salesforce was correct.
We had clean data flowing from first touchpoint to last touchpoint.
Now comes the fun part: creating report outs that actually tell us the business impact of specific marketing channels or efforts.
As the ExtraHop marketing team was pretty new to the company at this point, we had a clean slate to work with. We used this clean slate to build reports that worked well for marketing as well as executive stakeholders to provide a clear picture of channel or program performance.
Over the course of this 12 month project we were able to take the new ExtraHop marketing team members from a state of distress (“oh no! We do not have what we need!”) to a place where they had all the correct data flowing from system to system.
This helped them with: