Bespoke deal boards with HubSpot & Zapier
Established in 2004, Goldmine Media have been around for over 15 years and have truly managed to evolve along with their industry’s needs. They are an integrated full-service communications and marketing agency who help their clients improve their performance through smarter marketing and aesthetic graphic design to build their reputations with compelling content.
Having a very niche target audience, they offer a unique portfolio of marketing services for financial professionals. They provide their clients with anything from a singular solution to cross-channel communication. From strategy to execution, Goldmine Media supports their clients to find the best way to communicate for financial professionals, whether that’s online or offline.
Goldmine had tried multiple CRM systems, including custom-built software as well as Salesforce. These systems were unable to provide the Goldmine Media team with the tools or features needed to make their day-to-day processes more efficient and streamlined. Many day to day activities, particularly for their business development representatives, were very suitable to get automated, in order to scale their marketing and sales efforts. HubSpot would be just the right platform.
After a thorough screening process, they were sold on HubSpot’s capabilities and how automation would be incredibly powerful for their inbound marketing efforts and sales team. They were also impressed by HubSpot’s reporting tools and wanted to integrate them into their board meetings for forecasting and revenue reports.
Once the portal was set up for Goldmine Media, we soon noticed that the standard deal board setup wouldn’t quite work for their reporting. To give you a full overview, Goldmine Media report on their revenue as follows:
As a result, the default product properties within HubSpot didn’t really fit the job description.
The members of board at Goldmine Media review their income based on the monthly one-off income, as well as continuous monthly retainer income, which should be an incremental number. After all, more retainer clients means a higher monthly earnings.
After a thorough brainstorming session, the team at Aira came to the conclusion that this problem wasn’t easily solved by a couple of workflows, but would need more extensive input into the problem. The desired solution was:
Fortunately, we have a big whiteboard wall at Aira, where we could draw out the entire process, including workflows, links to webhooks and expected results, to figure out what would work best for the client and would give us the desired result.
In order for us to have an automated secondary deal, we needed to create a duplicate deal. We did this by setting up an internal workflow within HubSpot, which simply copies over deals in any deal stage of the primary pipeline to the secondary pipeline (matching the deal stage it is in), creating a deal called ‘Deal Name – Residual Revenue’ and copies over:
Now it starts to get interesting. The primary deal has been duplicated to the secondary pipeline, but in order to sync it moving forward, like we’ve shown above, there needs to be a property that links the deals both ways. That’s why we’ve set up two custom properties:
In order to link the secondary deal (automatically set up), back to the primary one with the ‘Child Deal ID’, we needed to set up a workflow on HubSpot, which links to Zapier. Checking all deals in the secondary pipeline, whose ‘Parent Deal ID’ is known, means that we check all secondary deals, which already have a primary deal linked to it.
If a deal has these enrollment triggers, that triggers a webhook from Zapier which pushes the secondary deal’s default ‘Deal ID’ to the custom property ‘Child Deal ID’ in the primary pipeline. Now, the deals have linked both ways.
This is done through another workflow which continuously checks for changes in the original, primary deal, in order to reflect any change to the deal stage in the secondary deal. Whenever a deal meets the following (re-)enrollment triggers, it goes through the workflow:
By allowing re-enrollment, this creates a continuous loop whenever a deal meets all the criteria, so that the secondary deal can reflect accurately where the deal is in the deal stages. When a deal is enrolled, it gets checked for every single deal stage, using if/then branches for each deal stage. Once the workflow finds which deal stage the primary deal is in, it triggers a webhook into Zapier, specifically for that deal stage, which pushes the secondary deal to the same deal stage. This ensures an accurate overview of where all deals are, supports forecasting and gives the team an accurate funnel to see where deals drop off, without the secondary pipeline skewing any data.
Note: For this to work, both pipelines need to incorporate the exact same deal stages, so the secondary deal can follow where the primary deal is.
This is similar to the previous step, but the (re-)enrollment triggers are as follows:
Once the deal has triggered by changing the ‘Monthly Residual Amount’ property, the workflow will trigger a webhook into Zapier, which changes the default ‘Amount’ property in the secondary deal, ensuring that the amount reflected is accurate as these may change during the sales process.
The latter two workflows and their related webhooks in Zapier keep the pipelines clean and current and give the sales team the opportunity to simply work in the one primary deal, but seeing their work and changes reflected in a way that helps support revenue reporting for the board of directors, as well as for their own accomplishments.
We configured the deals settings so that the business development representatives are asked for all the relevant information is asked for both the one-off and ongoing fees and information when the primary deal is created and have also set the properties so that all relevant properties for both the one-off and ongoing projects are easily accessible in one place. The automation then does its magic and ensures that the primary and secondary pipelines are synced!
After hours of testing, we had a training session with the Goldmine Media team to show them how it all works (and how simple it is!). We sent them back to the office and told them to play around with it and try to break it. Fortunately, they haven’t, and after another day or so of them testing, we went live.
With a full sales dashboard populated, the members of the board regularly review how both projects and ongoing deals stack up against annual goals. They can now accurately look at what comes in each month, with one-off fees making up part of the monthly income and the monthly recurring fee amounts becoming incrementally larger.
“We were looking for support scaling our business making use of marketing and sales automation” said Andrew Taylor, CEO of Goldmine Media, “When we realised that reporting on revenue turned out to be not possible in the default setup of deals, the team at Aira jumped at the chance to try something out of the box. They kept us closely involved in the process, to truly understand what outcome was required and then presented us with what they believed to be the solution. We’ve gone from excel sheets and keeping notes on potential deals to a fully digital and automated solution.”
“Their willingness to try something completely new and making it work has really impressed us. We feel that we can always call the team at Aira and whoever picks up makes sure that we are supported.”