Sales Tracker

A sales tracker is useful when it makes the next sales decision obvious. A spreadsheet full of names, amounts and percentages is not a pipeline by itself. The tracker should show where each opportunity is, what evidence supports that stage, what happened most recently, who owns the next action, and when that action is due.

Salesforce documents opportunity views organized by stage and fields such as amount and expected revenue. HubSpot likewise describes pipeline stages as steps in the buying process. SOE uses those mechanics as a starting point, then adds an evidence-for-stage and next-action discipline.

Use one row per active opportunity.

A stage should describe a meaningful change in the buying process.

A practical starting sequence is:

1. Target
2. Contacted
3. Connected
4. Qualified
5. Discovery
6. Proposal
7. Decision
8. Won
9. Lost
10. Nurture

These are not universal stages. Adapt them to the actual buying process. The important rule is consistency: your team should know what has to be true before an opportunity moves forward.

Add one sentence to every active opportunity:

Why is this opportunity in this stage?

Examples:

• Qualified: problem, fit and decision path have been confirmed.
• Proposal: a defined offer has been presented.
• Decision: the buyer is actively evaluating or approving the purchase.
• Nurture: the problem is real, but the purchase is not active now.

Avoid notes such as “Very interested.” Interest is not a stage. Evidence is.

Every open opportunity should have exactly one primary next action.

Write it as an action: send revised proposal, confirm the decision-maker, book discovery, answer an unresolved question, or follow up after internal review.

Do not write “follow up,” “check in,” or “wait.” A useful next action tells another salesperson what should happen without needing a meeting to explain it.

Review these fields together: Stage → Last activity → Next action → Next-action date. If the next-action date has passed, take the action, move the opportunity to a more accurate stage, move it to nurture, or close it as lost if the evidence supports that decision. Do not keep dead opportunities in the active pipeline simply because removing them makes the forecast look larger.

For each active opportunity ask: What changed since the last review? What evidence supports the current stage? What is the next customer-facing action? Who owns it? What could prevent movement? What would make us close it or move it to nurture? What did we learn? A useful review is a decision meeting, not a reading of every row.

Start with a small set: Active pipeline for opportunity, owner, stage, amount, expected close, last activity, next action and next-action date. Needs action for open opportunities due today or overdue. No next action for active opportunities without a concrete next action. Stalled for opportunities whose stage has not changed beyond the team’s agreed window. Decision stage for buyers evaluating the proposal. Won / Lost review for recently closed opportunities and outcomes.

Keep pipeline amount, expected amount, committed amount and won revenue separate. Do not multiply every opportunity by an arbitrary percentage simply because the tracker has a probability column. If probabilities are used, define what they mean and keep the definition stable.

Before treating an opportunity as qualified, capture the problem, impact, fit, authority, timing, commercial path and the evidence that supports those answers. The purpose is to make missing information visible, not to force a sales methodology into the tracker.

A lost opportunity should not disappear without a reason. Use controlled categories such as no priority, no budget, poor fit, timing, competitor, internal decision, price/value mismatch, no decision, unreachable decision-maker, solution limitation, or other. Then ask what evidence supports the loss reason and whether the company should change something because of the loss. One lost deal is an event. Repeated loss reasons are a signal.

Show open opportunities, pipeline value, opportunities needing action, overdue next actions, deals in decision, won this period, lost this period, top loss reason, oldest active opportunity and next major decision. The dashboard should lead to questions, not replace the underlying records.

A sales tracker should answer five questions in seconds: Where is the opportunity? Why is it there? What happens next? Who owns that action? What evidence tells us whether the opportunity is real? If the tracker cannot answer those questions, adding more fields will probably not fix it. Improve the definitions and operating discipline first.

This template is SOE editorial synthesis. It does not reproduce a CRM vendor template. Salesforce documentation was used to verify stage-based opportunity tracking, pipeline views, amounts and activity-oriented pipeline inspection. HubSpot documentation was used to verify configurable pipeline stages, stage rules and weighted-pipeline concepts. SOE adds the evidence-for-stage rule, explicit next-action field, stale-deal review, qualification evidence and loss-learning loop. No customer result, sales statistic, founder experience or performance claim is asserted by this template itself.

This is SOE editorial synthesis, not a reproduction of a CRM vendor template. Salesforce documentation was used to verify opportunity-level fields such as Amount, Expected Revenue, Owner and stage-linked forecasting. HubSpot documentation was used to verify configurable pipeline stages, stage probabilities, weighted amounts and next-step tracking.

• Salesforce Help: Opportunity Fields
• Salesforce Help: Pipeline Forecasting Best Practices
• HubSpot Knowledge Base: Set up and manage object pipelines
• HubSpot Knowledge Base: Forecast tool

The vendor sources support the underlying pipeline mechanics. The evidence-for-stage rule, explicit next-action discipline, stale-deal review and loss-learning loop are SOE's editorial synthesis. No customer result, sales statistic, founder experience or performance claim is asserted by this template itself.

Related reading: \2 · \2

Use one row per active opportunity and keep the evidence-for-stage, owner, next action and next-action date current. Review stale opportunities weekly and close or nurture them when the evidence no longer supports an active stage.

1. Fill it with one real situation rather than hypothetical inputs.
2. Record the evidence behind each important field.
3. Make the smallest decision the tool is designed to support.
4. Set a review date and update the tool when the evidence changes.

Good output: another person should be able to understand what was decided, why, what remains uncertain, and what happens next without needing a separate founder explanation.