MPL Associates wanted a Closed Won revenue reporting system that allowed them to see how much NEW business they were getting from the website. I initially recommended the deal PIT Contact Stage, but I found some issues/bugs with the PIT Contact Stage that caused the reporting to be inaccurate. With an unclear timeline of how long that fix would take, I decided to create my own system!
I used Looker to create the custom raw report I needed and Google Sheets to extract the earliest deal for each unique contact.
Looker Report: I used this over the Deals Dashboard because the Deals Dashboard doesn’t export ContactId (which I need for deduplicating), and it ensures consistent data formatting.
Google Sheets: For the most part, the AM just needs to upload data into the 1st tab of the Google Sheet. The other 2 tabs (which extract the earliest deal for each unique contact based on Open and Close Date) will populate automatically with the dynamic filters and functions!
How the auto-populating tabs work
Created a method for accurate New Business reporting, without reliance on a client-owned field or PIT Contact Stage field, that allows the client and IM team to see the 1st deal for each contact
Here’s how you can mimic this for your client!
Instructions: