Every Lead Became an Opportunity. Their Close Rate Was a Guess.

The Setup

The same real estate coaching company. After we fixed the duplicate lead problem, we started looking at the downstream: what happened to those leads once they entered the pipeline. What we found was worse.

The Problem

Every lead in the CRM auto-converted to an opportunity on capture. That meant "opportunity count" was functionally identical to "lead count," which made close rate — calculated as deals closed divided by opportunities — a meaningless number.

It got worse. The CRM had no standardized status set. Every setter and closer had created their own statuses over time: "Call Booked with Adam," "Texting John back," "Hot for Wednesday." When Adam left the company, 1,400 opportunities were stuck in a status only Adam understood. When John was promoted, his statuses became ghosts.

The same lead often appeared across multiple opportunity records. The setter would create one. The closer would create another. A follow-up sequence would create a third. The CEO looked at his pipeline dashboard and saw a healthy number of active opportunities. The reality was that the same thirty people were being counted six times each.

What We Found

Six thousand active opportunities. When we resolved them to unique leads, the actual count was closer to twelve hundred. Close rate, calculated correctly, was about 28% — not the 6% the reports had shown. That wasn't good news in the way the CEO expected; the real number had been acceptable all along, and the team had been chasing a problem that didn't exist while ignoring the ones that did.

The person-specific statuses had created a graveyard of orphaned deals. Almost 400 opportunities had been untouched for more than 90 days, owned by people who no longer worked at the company. The pipeline looked active because nothing ever cleaned itself up.

What We Built

Seven standardized lead statuses. Twelve setter-specific fields. Fifteen closer-specific fields. Every status maps to a lifecycle stage; every field maps to a metric the CEO actually needs for a decision.

We built the status transitions as a state machine — a lead can only move between statuses that make sense. The CRM enforces it. You can't put a lead in "Contract Sent" without "Proposal Discussed." You can't create a second opportunity for the same lead without explicitly orphaning the first one.

The person-specific statuses were migrated to new owners or archived. A monthly hygiene report flags any opportunity that hasn't moved in 45 days, assigned to the current owner. Most get worked or closed; a few get reassigned.

Total project time: eight weeks.

The After

For the first time, the CEO could look at his pipeline dashboard and trust the number. Active opportunities dropped from 6,000 to roughly 1,200 — not because business got worse, but because the count had been fictional. Close rate settled at 28% where it had been all along.

The real surprise was where the close rate varied: it was significantly higher on leads that came through one specific funnel, and significantly lower on another. That had been invisible before because the opportunity counts had been polluted with duplicates from multiple sources. The CEO reallocated ad spend within a week.

Closing

This client told us later that this was the engagement that made him stop second-guessing the data. Once the pipeline logic was honest, every downstream decision got easier.