Rebuilding a national homebuilder's sales operation
Fourteen sales consultants across display centres, an established CRM, and a sales management layer that could not see its own team without opening records one at a time. The engagement was not a project with an end date. It was ownership of a revenue operation that had drifted.
- The goal
- Give management a real picture of the sales operation, move accountability from managers chasing people to consultants seeing their own numbers, and make the CRM the system of record rather than the source for a spreadsheet.
- What it was costing
- Territory routing had been decorative for years. Three deposit-stage controls had never fired once. Manager reporting was manual, KPI boards were re-keyed into Excel by hand, and the governing principle — if it is not in the CRM it did not happen — was not survivable given what the CRM actually contained.
Client anonymised — a national residential builder, delivered under another company. Names, territories, team structures, partner names and record identifiers are withheld or changed. Every figure below is real.
- Consultants in scope
- 14 sales consultants across display centres
- Assignment rules audited
- 10 lead-assignment workflows
- Controls that had never fired
- 3 deposit-stage workflows, silently inert
- Programme phases
- 6 phases, sequenced and gated
Starting from what management could not see
The engagement began with an onsite discovery across three sessions — wholesale and packages, sales management, and marketing — because the presenting complaints were symptoms and it was not yet clear what the operation actually looked like.
What came out of it was a picture of a business managing itself by hand on top of a system it had already paid for. To prepare a Monday one-on-one, a manager opened a consultant's record and read calls and deal bins individually; there was no single page that showed a week. The consultant KPI board was produced from the CRM, exported, and re-keyed into a spreadsheet, and that spreadsheet — not the CRM — was what consultants checked morning and evening.
The root cause of the visibility gap was structural rather than cosmetic. Teams existed in the CRM but were being used only to drive an online-lead rotation, with people added and removed depending on how busy their display centre was. It was a routing list, not a hierarchy, so no manager rollup could exist on top of it.
The stated management principle was "if it is not in the CRM it did not happen". That is the right principle and it was not yet safe to enforce, because several things that had happened were not in the CRM and several things in the CRM had not happened.
Finding out the routing had been decorative for years
A complaint arrived that leads were not reaching the right regional consultants, alongside a visibility issue where two people could suddenly see records they should not. The easy move was to reverse a recent team change, declare it fixed and move on.
It was not the cause. An audit of all ten lead-assignment workflows, plus the user, role and team model, showed the visibility came from a permission set scoped to all contacts — unrelated to teams and predating the engagement entirely. A separate view setting was exposing 76 ownerless deals.
The routing finding was larger. All three round-robin workflows branched four ways by territory and then rotated into only two pools. Two territories fed one pool and two fed another. Regional routing had never worked the way the business believed, for as long as anyone could remember.
It was rebuilt by deriving the territory map from actual record ownership over the current year rather than from the documented territory list — which corrected two entries the documentation had wrong — then repointing nine rotate actions with the existing pools kept alongside the new ones so rotation never emptied mid-change. The full technical account is written up separately in Four branches, two pools, and nobody knew.
Controls that were enabled and had never run
Three workflows policing deposit-stage data completeness were switched on, correctly configured by inspection, and had never enrolled a single record.
The cause is a platform behaviour with no error surface: association absence cannot be expressed the way it had been written. One API rejects the filter outright; the other accepts it, stores it, and never runs it. Nothing anywhere reports a problem.
They were rebuilt against a pattern that does work, verified with throwaway lists showing 453 of 662 deposit deals carried the required association, and date-bounded so that enabling them did not retro-blast the entire history. That detail matters more than the fix — a corrected control switched on against years of backlog is its own incident. The technical write-up is in Three workflows, enabled and enrolling nobody.
Scorecards, once the data could carry them
Management wanted weekly scorecards, and the sequence agreed was deliberately enablement before enforcement: service levels first, then scorecards tied to KPIs, then self-serve visibility — rather than managers nagging.
Each candidate metric was tested against live data before acceptance, and six of eight failed. One field was populated on exactly one deal portal-wide. New-deal completeness had no room to move, because 165 deals created in thirty days had zero missing region and zero missing sale type. Contact hygiene was 99.6% complete only because three workflows write it automatically, so it measured the automation rather than the person.
Two data problems were surfaced rather than absorbed. Meeting counts run at roughly double reality, because consultants create a meeting in the CRM for the reminder and then send a separate calendar invite. No-shows are deleted rather than outcome-marked, which destroys the record of the attempt. Any meeting-based KPI in the business is overstated until those habits change, and saying so was more useful than building a scorecard on top of them.
What shipped was two components rather than eight, ramped from a 15.5% baseline rather than set at an aspirational bar, cross-checked against a hand-built figure before launch, and filtered on the one field that reliably separates human work from machine-generated work.
The integrations, and the ones that fail silently
Two partner lead sources were brought into the CRM properly during the programme — inbound enquiries through the forms API, and status updates through a custom object with authenticated webhooks.
One of them produced the most instructive failure of the engagement. Submissions were being accepted with a success response and silently discarded, because the payload carried a page reference on a domain the platform did not recognise and treated the whole submission as spam. A first theory about rate limiting was wrong, and was corrected against evidence rather than defended.
That pattern — an integration reporting success while dropping data — is the one worth taking away. It is why every integration on this programme is verified by reading the record at the far end rather than trusting the response at the near one.
What ongoing ownership looks like here
The programme is sequenced across six phases with an exit gate on each: access and quick wins, management visibility, process definition and pipeline redesign, automation and enablement, marketing, then the wholesale channel. Phases overlap deliberately, and process mapping starts early because most of the automation depends on it.
Some decisions were to not build. A forecast submission tool was rejected because it adds a manual task and the consultant-set rating is not trusted internally — deal scoring became the forecasting mechanism instead. Parking stages are being removed on principle so that time-in-stage measures a real stall rather than a filing convention.
Four deal stages and four workflows are locked by an upstream system and require third-party sign-off. Two API capabilities are unavailable on this portal's connection, so certain work is manual by necessity. Those constraints are documented as standing constraints rather than rediscovered each time somebody proposes a change.
What changed
- Regional lead routing genuinely routes by region for the first time, rebuilt against actual record ownership rather than a documented map that was wrong in two places.
- Three deposit-stage controls that had never fired now run, bounded so that switching them on did not replay years of history.
- Managers work from a shared dashboard instead of assembling each consultant's week by opening records one at a time.
- The consultant KPI board no longer needs re-keying into Excel, and two KPIs generated outside the CRM are captured against a custom object and reported alongside everything else.
- A permission-set cause of a visibility complaint was separated from the routing work and decided on its own merits, rather than being fixed by reversing an unrelated change.
- Three data-quality problems the business did not know it had — double-counted meetings, deleted no-shows, and a display metric that cannot tell zero from blank — are documented with evidence and sequenced for process change rather than papered over.
Where it stands
Ongoing. Phases 0 to 3 are substantially delivered; pipeline redesign, the marketing workstream and the wholesale channel are sequenced and in progress. Commercial outcomes such as conversion and cycle time sit with the client's own reporting over the coming quarters and are not claimed here — what changed so far is that the operation can now be measured honestly, which is the precondition for the rest.
Questions people ask about this
What does a fractional RevOps engagement actually cover?
Ownership of the revenue operation rather than a single project: management visibility and reporting, lead routing and territory design, process definition and pipeline structure, sales enablement and scorecards, and the integrations feeding the CRM. On this engagement that was sequenced across six phases with an exit gate on each, so each phase had to be demonstrably working before the next started.
How can you tell if CRM lead routing is really routing by territory?
Count the branches and then count the destinations. Routing that branches four ways by region but rotates into only two pools is not routing by region, however it looks in the builder. Then derive the territory map from actual record ownership over a recent period rather than from the documented list — on this engagement that comparison corrected two territory assignments the documentation had wrong.
Why would a CRM workflow be switched on and still never run?
Because some filter conditions are accepted by the API and stored without ever matching. Association absence is the common case: one API rejects the filter outright while the other saves it and silently never enrols anyone. There is no error surface, so the workflow reads as healthy in the interface. Three deposit-stage controls on this engagement had never fired once.
What makes a sales scorecard measure the wrong thing?
Most CRM fields describe accumulated state rather than the week being scored, so they measure backlog the person inherited. Test each candidate against live data first: on this engagement six of eight failed, including one field populated on a single deal portal-wide and a hygiene metric that was 99.6% complete only because workflows write it automatically.
Should you fix data quality before building a sales scorecard?
You need to know about it, but you do not always need to fix it first. Meeting counts here ran at roughly double reality and no-shows were being deleted rather than outcome-marked. Rather than delay, the scorecard was built on components that survive those problems, and the data issues were documented with evidence as process changes for the client to make.
Ongoing ownership of a revenue operation — visibility, routing, process, enablement and the integrations underneath — rather than a project that ends before the habits change.
Fractional RevOps Leadership