Out of the box, Salesforce is good at showing you the present state of leads and opportunities. But marketers quickly start wishing they could understand a contact’s history – how someone progressed through the buying cycle.
Salesforce doesn’t natively display this time-series data, and marketers can’t see:
- how specific campaigns drove MQLs and Opps
- which contacts stop and restart multiple buying cycles
- how quickly contacts move from stage to stage
So Marketing teams spend hours every week aggregating data, wrestling with Excel, and struggling to unpack insights.
To answer these questions, Sponge will often create a Funnel History custom object in Salesforce. We stamp it with dates and stage names as leads and contacts progress through the funnel.
Here’s how it works:
Two leads enter the funnel in January. Meet Bob and Susan!
And the custom Salesforce Funnel History object begins stamping dates and stages.
As Bob and Susan move through the funnel, converting to SALs…
…new stamps are created and new data is added to the existing Salesforce Funnel History records.
Bob and Susan continue converting…
And the Funnel History object keeps stamping new data…
These stamps ultimately allow you to report when leads enter the funnel and how quickly they convert. Here I’m asking, “how many MQLs did we create Jan 1-18?” Two.
And here I’m asking, “how many of these MQLs became SQLs?” One.
We also layer on the campaign data to see which marketing tactics are producing MQLs, SALs, etc.
This kind of data is so exciting for reporting (#nerdlert). Ultimately, it means marketers are wasting way less time monitoring and measuring performance across the MAP, Salesforce, Google Analytics, and Excel.
Curious if you’re leveraging the full power of your marketing tech stack? Request a free audit and we’ll benchmark your setup.