Deal Archaeology: How to Find Where a Deal Actually Died
The day a deal is marked lost is rarely the day it died. Here is how to read the timeline and find the real moment.
Published 2026-11-06 · Data as of 2026-11-06 · Market & data intelligence · Educational, not advice.
A deal is rarely lost on the day it is marked lost. Deal archaeology means reading the CRM timeline backward. Check how long it sat in each stage, how often the close date slipped, and the pattern of activity rather than the amount. Above all, find the last next step with a named owner. Where ownership disappears is often where the deal died.
The closed-lost date is a death certificate, not a cause of death
When a deal is marked closed-lost, the CRM records the day someone admitted it. That is rarely the day it died. More often the deal stopped moving earlier, and the record kept looking alive because nobody had a reason to touch it.
Deal archaeology means reading a deal's timeline backward to find that earlier moment. The goal is not blame. The goal is to learn which pattern killed the deal, so the next one gets caught while it can still be saved.
The lens is simple. First, measure the change: at each point, was the deal moving or stalling? Then turn that into direction: when it stalled, who owned the next move, and did they make it?
What a CRM timeline actually records
Every CRM keeps some version of history: field changes, stage moves, logged activities, emails, meetings, notes, tasks. Read in order, they form layers, and like any dig site the layers are uneven. Some periods are dense with records. Some are empty. The empty stretches are often where the story is.
Before you dig, pull four things for the deal:
- Stage history, with timestamps for every change, including backward moves.
- Close date history, meaning every edit to the expected close date and by how much.
- Activity log, split into touches the rep started and touches the buyer started.
- Next steps and tasks, with who owned each one and whether it was completed.
Reading the layers
Stage velocity
Compare how long the deal sat in each stage with how long your won deals sit there. Use your own history, not a benchmark borrowed from somewhere else. A deal that spent twice your norm in evaluation was telling you something long before it was lost.
Close date drift
A close date pushed once is a forecast correction. Repeated pushes with no stage change in between can mean a deal is being kept alive on paper. Pay attention to the first push that has no matching change in buyer behavior; it is a candidate for the time of death.
Activity shape, not activity volume
A busy timeline looks healthy. But twenty rep emails in a row with no reply is not momentum. It is one person talking to an empty room. A buyer sending ten emails full of questions can mean real engagement, or it can mean they are building a case for someone else.
Look at the ratio and the rhythm instead. When did the buyer stop starting conversations, or when did those messages start coming from someone more junior? When did meetings turn into emails, and emails into silence?
The last owned next step
This is the most useful thing you will find in the dig. Find the last next step that had a named owner, a date, and a clear action. Then check what happened to it. Was it done? Was it pushed? Did it quietly disappear and get replaced by a generic follow-up?
The moment a deal goes from the buyer reviews the proposal with finance by Thursday to check in is often the moment it died. Direction was lost. Nobody owned the next move anymore, on either side.
Common causes of death you will find
Dig through enough lost deals and the same patterns tend to repeat:
- Single-threaded collapse. All activity runs through one contact. That person goes quiet, changes roles, or loses the internal argument, and the deal goes with them.
- The orphaned step. The buyer agreed to a next step and owned it, but it had no date, and the rep never followed up to confirm it happened.
- Stage inflation. The deal was moved forward on hope rather than on the criteria for leaving a stage. It sat in a late stage while the reality was still early-stage.
- Unhandled change. A new stakeholder, a budget shift, or a competitor appeared in the notes, and the next activity did not address it.
From autopsy to early warning
One dig teaches you about one deal. The real value comes when you turn what you find into live signals. Your digs may keep landing on the same moments: the first unexplained close date push, the shift from meetings to one-way email, the next step with no owner. Those are the conditions to watch on open deals today.
Run a short dig on your last ten lost deals. For each one, write down the likely time of death and the pattern behind it. Then see whether a small number of patterns account for most of the losses.
Doing this by hand works, but it is slow and it only looks backward. Delta Arc CRM Intelligence reads the same timeline signals live on top of the CRM a team already uses. It is designed to flag when a deal stops changing and when the next move has no owner, while there is still time to act.
What comes next
Finding where a deal died tells you what to stop doing. The harder question is what a healthy timeline looks like in the first place. Next in The Pulse: the shape of a deal that is genuinely moving, and how to tell real momentum from mere motion.
Sources
This explainer cites no outside data. It applies the method and definitions below.
References for this topic
- Delta Arc methodologythedeltaarc.com
- Delta Arc definitions and evidence classesthedeltaarc.com
This is the free read. Delta Arc CRM Intelligence turns your CRM into a live accountability engine — who owns the next move, and where revenue is stalling. Book a walkthrough.