Your forecast is mathematically wrong. Not because you can't do math. Because the data feeding it is incomplete, stale, or trapped in tools that don't talk to each other. You know this feeling: your sales team swears the pipeline is solid, but when you ask "where exactly is that deal?" three different answers come back. The contact record says "cold inbound." The last activity was 47 days ago. The opportunity is labeled "negotiation" but nobody's touched it in six weeks. The forecast says you're hitting quota. The cash position says you're not. This isn't a forecast problem. It's a data problem. And it's invisible until you audit it. Why data breaks before velocity becomes obvious Pipeline velocity—the speed a deal moves from stage to close—is the single most reliable sales forecast metric. It's physics, not opinion. If your average deal takes 35 days from discovery to close, and you have 15 deals in pipeline, you can predict cash within a few thousand dollars. But velocity only works if your data is current. Most teams lose 30–50% of their pipeline data the moment it leaves the primary tool. A sales rep logs a call in their calendar or email. The CRM never sees it. An activity happens in Slack, WhatsApp, or email—tools that don't automatically sync back to the pipeline. A contact gets added to your system, but nobody links them to an open opportunity. A deal moves to "final negotiation," but the stage change happens in a spreadsheet, not the system of record. By the time you forecast, you're not modeling the real pipeline. You're modeling the data that happened to stick to your tools. Forensic check 1: Contact-to-deal orphan rate Start here. This is the easiest audit to run and the most revealing. Pull a report of all contacts added to your CRM in the last 90 days. Now count how many are linked to an open opportunity. The gap is your orphan rate. Most teams will find that 35–60% of recent contacts have no deal attached. Some of these will eventually become opportunities. Many never will—they were added but never qualified, or the rep meant to create a deal and forgot, or the contact was imported from a list and lost momentum immediately. Here's what that means for your forecast: Invisible pipeline. Those orphaned contacts are in limbo. They might close this quarter or next year. Your forecast has no way to account for them because they're not in a stage. Duplicate work. When a contact isn't linked to an opportunity, your team can't see the conversation history. A rep follows up not knowing another rep already tried three weeks ago. You lose deal momentum and double your sales cycle. Lost urgency signals. If a contact isn't connected to a deal, activity on that contact doesn't move the deal forward. A reply to an email looks like progress. The forecast sees nothing. The forensic move: Pull your top 10 reps' contacts from the past 60 days. Calculate: (Contacts linked to open deals) / (Total contacts added). If this ratio is below 0.65, you have a serious data-quality problem. If it's below 0.5, your forecast is essentially fiction. Most teams stop here and blame rep behavior. "They're lazy, they won't qualify contacts." Sometimes that's true. But usually the real issue is friction. Linking a contact to an opportunity takes three clicks and a decision about the deal size. Reps avoid it. Fix the friction—make linking automatic, or remove the step entirely—and your orphan rate will drop 50% in two weeks. Forensic check 2: Activity logging completeness and the 47-day ghost deal Now audit activities. This is harder to measure but more predictive of real velocity. Pull a sample of 30 deals currently in your "negotiation" or "proposal" stage. For each deal, count: Days since the last logged activity in your CRM. How many communication channels that activity could have happened in (email, Slack, WhatsApp, call, meeting) without appearing in your CRM. You'll see something like this: 11 deals have activity logged within 7 days. These are probably real. Your forecast can trust them. 8 deals have activity within 14–30 days. Likely real, but there's slippage. A call or reply happened in email and nobody copied the note. 7 deals show activity 31–60 days ago, but the rep insists "we're actively negotiating." The activity is there, but it's in Slack, WhatsApp, or a personal email thread. 4 deals are ghosts. 60+ days with no logged activity. Either the deal is dead and nobody archived it, or all communication is happening outside your CRM and you have zero visibility. That last bucket—the ghost deals—is where forecast accuracy dies. If 12–15% of your "active" deals have no recent logged activity, your velocity math is wrong. You're either: Including deals that are actually stalled and will slip to next quarter. Excluding deals that are moving fast but the activity isn't logged. Both destroy your forecast. The forensic move: Set up a monthly audit. For any deal over 45 days with no logged activity, run a manual check: ask the