370+ Manual Deal Updates Eliminated Every Month

The Situation

A financial advisory firm was running their entire sales process through a HubSpot pipeline that had stopped reflecting reality. Deal stages had vague names that didn't match how the team actually worked. Some stages described actions, others described states, and nobody was sure who owned moving deals between them. The team was dragging deals manually, often forgetting, often arguing about who should have done it.

The bigger problem was that the pipeline didn't connect to what actually happened with prospects. Sales meetings were scheduled, attended, cancelled, no-showed, rescheduled, and the deal status had to be updated by hand every single time. Meeting outcomes lived in one part of HubSpot, deal stages in another, and the only thing connecting them was someone remembering to do it.

There was also a compliance constraint that ruled out the obvious solutions. As a financial advisory business, the firm operates under strict regulatory rules about which systems can hold what data. HubSpot is not their approved CRM for client records, so they had signed an affidavit limiting what HubSpot could be used for. That meant we couldn't link HubSpot to their actual CRM, couldn't pull data across systems, and had to build everything within HubSpot's own logic without any of the usual workarounds.

Our Approach

We started by rebuilding the pipeline itself. The old stages mixed past tense, future tense, and action items in ways that confused the team, so we designed clean stages that map to one thing only: where the deal actually is right now. Intro Call, Discovery, Presentation, Closing Questions, Onboarding, Closed Won, Closed Lost. Nothing else.

Then we built the automation that makes the pipeline run itself. Every meeting outcome (scheduled, qualified, unqualified, no-show, cancelled, signing scheduled, paperwork signed) triggers the right action automatically. Positive outcomes move the deal forward to the next stage. Negative outcomes add the prospect to a tracking list and assign a follow-up task to the advisor or admin. If a no-show or cancelled status sits unchanged for three weeks, the deal automatically moves to Closed Lost. The team never has to remember to clean up stalled deals.

We also solved a tricky problem unique to their business. Most prospects come in as couples, and the firm's clients also have multiple deals open across different pipelines (sales pipeline, AUM pipeline, life insurance pipeline). Without the right filter, an automation that moves "the deal" forward could move all related deals at once and break everything. We added a deal type filter, so only new business deals in the sales pipeline get touched by the automation. Existing client deals across other pipelines stay manual, exactly as their compliance setup requires.

The handover included a full walkthrough of every workflow path, so the team could see exactly what happens at each meeting outcome and adjust task assignments themselves without needing us.

Before

• Pipeline stages used inconsistent language (past tense, future tense, action items mixed together)

• Deals moved manually, often forgotten, often double-handled by team members

• No connection between meeting outcomes and deal stages, every update done by hand

• No system for tracking why deals stalled (no-show, cancelled, unqualified) or following up on them

• Couples generated duplicate deals, one per spouse, cluttering the pipeline

• Multiple pipelines for different products meant any automation risked moving the wrong deal

After

• Clean pipeline with stages that describe deal status, not actions or tense

• Automation moves deals forward based on meeting outcomes, no manual dragging

• No-show and cancelled prospects automatically added to tracking lists by stage

• Stalled deals (3 weeks of no-show or cancelled) automatically moved to Closed Lost

• Follow-up tasks assigned automatically to the right advisor or admin

• Couples get one deal with both names, not duplicates

• Deal type filter ensures automation only touches new sales deals, not existing client work in other pipelines

• Full compliance with the firm's HubSpot usage restrictions

The Outcome

The sales pipeline now reflects reality without anyone having to maintain it. The team stopped fighting over who moves deals and started focusing on the meetings themselves. Stalled prospects get followed up on automatically, and dead deals stop cluttering the active view. The whole system works inside HubSpot's compliance boundaries, no external integrations, no data crossing into systems where it doesn't belong.