Opportunity stage history is the stored record of every stage change on a deal: the previous value, the new value, the timestamp, and the user who made the change. The opportunity record itself holds one stage value. The history holds the path, and almost every useful pipeline metric is computed from the path rather than the position.
The current record answers almost nothing
A pipeline report built from current stage values tells you the distribution of open deals at one moment. It cannot tell you how long those deals have been sitting, whether any of them moved backward, whether any jumped a step, or what share of deals entering a given stage ever left it forward.
Those are the questions that predict outcomes. Time-in-stage, stage conversion, regression rate, and skip rate are all transition metrics, and a transition needs two values and two timestamps to exist.
What to capture
Log the stage change with its old and new value, the timestamp, and the user. Then log close date and amount changes on the same timeline, because those three fields together describe what is actually happening to a deal. ORM treats a change in stage, close date, or amount as meaningful activity, and reads the absence of all three as its own signal.
Capture the reason where a reason exists. A regression with a recorded cause is a coaching artifact. A regression with no cause is a mystery you will relitigate at quarter-end.
Retention will bite you
Most CRM platforms trim field history after a fixed window, and that window is routinely shorter than the lookback a forecasting model needs. Teams discover this the first time they try to compute conversion rates across three years and find the transitions have been deleted underneath them.
Snapshot the history out on a schedule. A daily extract into a warehouse costs little and it is the only version of this data you control. ORM builds a fully trained model from a company's historical sales performance in four to six weeks, and the depth of usable history is what determines whether that history is worth training on.
What it lets you compute
With clean transitions you get the full set. Dwell time per stage, per segment. Conversion between adjacent stages, with the deals that skipped a stage counted correctly instead of vanishing from the denominator. Regression rate by boundary. Velocity by cohort rather than by snapshot.
It also supports close-timing models. ORM groups opportunities with a machine learning model and predicts a close curve for each group, with curves running from 1 to 80 weeks and most of the expectation landing before week 12. Curves like that are fit on transition data, so stage history is the input that decides whether the output is worth anything. The same data carries the earliest read on deal slippage, and it is the foundation under any serious attempt at forecast accuracy built on sales pipeline stages.
Frequently Asked Questions
What is opportunity stage history?
It is the audit trail of stage changes on an opportunity: old value, new value, timestamp, and the user who made the change. The current stage field tells you where a deal is. Stage history tells you how it got there and how long each step took.
Why is the current stage field not enough?
Because it holds one value with no duration and no path. Dwell time, conversion between adjacent stages, regression rate, and skipped stages are all computed from transitions, and a single current value contains none of them.
How long does a CRM keep field history?
Most platforms trim field history after a fixed retention window, and the window is usually shorter than the multi-year lookback a forecasting model needs. Snapshot the history into a warehouse on a schedule rather than assuming the CRM will hold it.
What should you capture beyond the stage value?
Capture close date and amount changes on the same timeline. ORM treats a change in stage, close date, or amount as meaningful activity on a deal, and reading the three together separates a deal that is progressing from one that is being edited.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like opportunity stage history into prescriptive action for your team.
Schedule a Demo