1. Resources
  2. Guides & tutorials

Guide · 9 min read · Published March 2024

How to track sales: metrics, dashboard and 5 steps

Record every opportunity in one place, then read pipeline, performance, and activity. The formulas, the five steps, and the dashboard layout are below.

You track sales by recording every opportunity in one place, then reading what is open, what closed, and what the team did to move deals. Pipeline tracking answers the forecast. Performance tracking answers quota. Activity tracking answers whether the work is happening.

Three kinds of sales tracking

Sales tracking covers three questions, and each one has an owner.

Pipeline tracking answers what could still close in this period. The sales leader and the CFO use it for the forecast. The input is open opportunities: stage, amount, and expected close date. A deal with no close date is a name on a list, not a forecast.

Performance tracking answers what already closed against the number the business promised. Quota attainment, win rate, and average deal size sit here. Finance and sales management both read it, for revenue and for which teams are behind.

Activity tracking answers whether the work that fills the pipeline is happening. Calls, meetings, and proposals logged against an opportunity. Front-line managers use it in a weekly one-to-one. It does not belong on the page the CFO reads.

Use all three, on different screens. The forecast meeting reads the pipeline. The monthly review reads performance. The weekly one-to-one reads activity.

The metrics and how to calculate them

Seven metrics cover the forecast and the result. Write one definition for each, and use that definition in the CRM and on the dashboard.

Win rate = closed-won deals / (closed-won + closed-lost). Count deals, and leave open deals out. It matters when you judge whether the open pipeline can produce the revenue still left in the period.

Average deal size = closed-won revenue / closed-won deals, on the same won deals as the win rate. It matters when the number of wins holds steady and the dollars move, or the reverse.

Sales cycle length = average days from opportunity created to closed-won, on won deals only. It matters when close dates slip, because a longer cycle turns the same win rate into less revenue this period.

Pipeline coverage = open pipeline value / remaining quota for the period. Remaining quota is the quota minus what has already closed. Open pipeline is opportunities still open with a close date in the period. It matters at the start of a forecast meeting, and it is incomplete without the win rate.

Sales velocity = (open opportunities x win rate x average deal size) / sales cycle length in days. The result is dollars per day if those rates hold. It matters when you want one number for whether the motion is faster or slower than last quarter.

Quota attainment = closed-won revenue / quota, for the same period. It matters because it is the number the board already knows, and the other metrics are there to explain it.

Stage conversion rate = opportunities that entered the next stage / opportunities that entered this stage, in the same period, calculated for each stage. It matters when the win rate looks fine and deals still stall in one place.

An example with round numbers

These numbers are made up to show the math. The period quota is $500,000. The team has closed 20 deals and lost 30, for $200,000 of closed-won revenue.

  • Win rate = 20 / (20 + 30) = 40%.
  • Average deal size = $200,000 / 20 = $10,000.
  • Quota attainment = $200,000 / $500,000 = 40%.
  • Average sales cycle = 30 days.
  • 60 opportunities are still open, worth $600,000, with close dates in the period. Remaining quota is $500,000 minus $200,000, which is $300,000.
  • Pipeline coverage = $600,000 / $300,000 = 2.
  • Sales velocity = (60 x 0.40 x $10,000) / 30 = $8,000 per day.
  • Stage conversion, in the same example: 100 opportunities entered discovery and 40 reached proposal, so discovery converts at 40%.

Read the example as a set. Coverage of 2 and a win rate of 40% do not promise the remaining $300,000. At that win rate the open pipeline would yield about $240,000, short of what is left to close.

Five steps to track sales

The order matters. A dashboard built before the definitions are fixed will publish more than one version of revenue.

Define KPIs

Write the seven formulas on one page and name an owner for each. Decide the period, whether win rate counts deals or dollars, and which stages count as open pipeline.

If marketing and sales both report pipeline, they use this page. A marketing ROI dashboard only lines up when a deal’s source and its amount mean the same thing in both places.

Set up a CRM

Salesforce and HubSpot both work. Pick one and put every opportunity in it. Require these fields before a record can be saved:

  • Opportunity name
  • Owner
  • Stage, from the agreed list
  • Amount, in one currency
  • Created date
  • Expected close date
  • Outcome: open, closed-won, or closed-lost
  • Source, so spend can be tied to the deals that source produced

Require the fields the formulas use, and refuse a save that is missing amount or close date. Activity fields can wait.

Capture deals the same way every time

One opportunity per deal, with the same stage names for every team. Amount is the value you expect to book. Close date is the date the owner will ask for the signature, and the field changes when that date moves.

Won and lost are both outcomes. Deleting a loss, or leaving it open so the pipeline looks full, makes the win rate useless. The owner updates the record in the week the change happens.

Review on a schedule

A weekly review looks at movement:

  • Deals that changed stage
  • Close dates that slipped out of the period
  • Pipeline added since the last review, and who added it
  • Deals that have sat in one stage longer than the usual time for that stage

The conversation is the next action on each deal that can still affect this period.

A monthly review looks at results: win rate, attainment, average deal size, cycle length, stage conversion, and coverage against the remaining quota. Compare each one with the prior month. A metric that moved belongs to the owner of that definition.

Keep the two reviews apart. The weekly meeting works the list. The monthly meeting reads the pattern.

Report progress on a dashboard

Put the weekly and monthly numbers in one view, refreshed from the CRM. Power BI or Tableau can both hold that view. The definitions stay in the CRM.

Five steps to track sales

From KPIs to the dashboard.

  1. Define KPIs

    Write the formulas and name an owner for each.

  2. Set up a CRM

    One system, with the fields every deal must have.

  3. Capture deals the same way

    The same stages, amounts, and dates on every opportunity.

  4. Review on a schedule

    Weekly movement, monthly results.

  5. Report progress on a dashboard

    The review numbers, in one view.

The five steps for sales tracking, from defining KPIs to reporting progress on a dashboard.

What the sales dashboard shows

The top of the page is four cards: quota attainment, win rate, pipeline coverage, and sales velocity. Each card shows the current period and the prior period.

Below the cards:

  • Pipeline by stage, as a bar, for opportunities with a close date in the period.
  • Closed-won revenue by month, as a line, against quota.
  • A table of deals expected to close in the period: name, owner, stage, amount, close date, and days in stage.

Leave these off the leadership page: a rep leaderboard, every call and email, a second revenue number with a different filter, and lead counts with no amount. The leaderboard and the activity belong in the one-to-one. A second revenue number will not be trusted. A lead with no amount is not pipeline.

Period, team, and owner filters sit above the cards and move every view together. This is the kind of dashboard we build in our business intelligence work: a few numbers a leader will open before the meeting.

Leave these off

What does not belong on the leadership page.

  • A rep leaderboard
  • Every call and email
  • A second revenue number
  • Lead counts with no amount
Four things the article says to leave off the sales dashboard a leader reads.

Getting CRM data into Power BI or Tableau

Bring opportunities across from Salesforce or HubSpot. Keep stage, amount, dates, owner, and outcome as the CRM stores them. Calculate win rate and pipeline coverage in the BI tool, so the definition lives in one place.

Use the connector the tool provides. Where it does not, use a scheduled export of opportunities or deals. A daily refresh is enough for a weekly meeting. Real-time sales tracking means the CRM is updated when the deal changes and the dashboard has refreshed before that meeting.

Power BI

Load Salesforce opportunities with the Salesforce connector, or HubSpot deals with a connector if you have one. If you do not, refresh the model from a scheduled export. Stage, amount, created date, close date, owner, and a won or lost flag should keep the meaning they have in the CRM.

Assume an Opportunities table with Outcome and Amount columns, a Quota table, and a date table related on close date. Create these measures:

Closed Won Deals = CALCULATE(COUNTROWS(Opportunities), Opportunities[Outcome] = "Closed Won")
Closed Lost Deals = CALCULATE(COUNTROWS(Opportunities), Opportunities[Outcome] = "Closed Lost")
Win Rate = DIVIDE([Closed Won Deals], [Closed Won Deals] + [Closed Lost Deals])
Closed Won Revenue = CALCULATE(SUM(Opportunities[Amount]), Opportunities[Outcome] = "Closed Won")
Open Pipeline = CALCULATE(SUM(Opportunities[Amount]), Opportunities[Outcome] = "Open")
Remaining Quota = SUM(Quota[Amount]) - [Closed Won Revenue]
Pipeline Coverage = DIVIDE([Open Pipeline], [Remaining Quota])

DIVIDE returns blank when the denominator is zero, which is what you want when a period has no closed deals. Put the measures on cards with attainment and velocity. Use a clustered bar for pipeline by stage, a line for closed-won revenue by month, and a table for deals closing in the period. The period and owner filters apply to all of them.

Tableau

Use the Salesforce connector, or a HubSpot connector if your version of Tableau has one. Otherwise publish an extract from a scheduled export and refresh it before the weekly review. Keep the same fields: stage, amount, created date, close date, owner, and outcome.

Create the same definitions as calculated fields.

Win rate: SUM(IF [Outcome] = "Closed Won" THEN 1 ELSE 0 END) / SUM(IF [Outcome] = "Closed Won" OR [Outcome] = "Closed Lost" THEN 1 ELSE 0 END)
Remaining quota: SUM([Quota]) - SUM(IF [Outcome] = "Closed Won" THEN [Amount] END)
Pipeline coverage: SUM(IF [Outcome] = "Open" THEN [Amount] END) / [Remaining quota]

Use the same cards, bar, line, and table. The period filter and the owner filter apply to every sheet.

The calculation is written differently in each tool. The number should mean the same thing. If both tools are already in the company, pick one for this page, or the two refresh schedules will drift.

Tracking sales in a small business

A small team does not need a CRM on the first day. It needs one list that matches the formulas.

Use a spreadsheet with one row per opportunity and these columns: name, owner, stage, amount, created date, expected close date, outcome, and source. Write the stage list at the top of the sheet and use those words only. Won and lost stay on the sheet, and win rate uses the formula above.

That sheet is enough while one person sells and one person can point to the current file. Move to a CRM when a second person is selling, when copies of the file show up in email, or when you cannot tell which close date is the real one. HubSpot and Salesforce are the usual next step. Require the same columns, and do not invent new metrics because the tool has more fields.

The weekly review still fits in half an hour: sort the open rows by close date, and talk about what slipped and what moved. Once a month, calculate attainment, win rate, deal size, and cycle length from those rows. When the list moves into a CRM, the dashboard replaces the cells. The questions stay the same.

Swift Insights

01 FAQ

Frequently asked questions

How do you track sales?

Record every opportunity in one system with a stage, an amount, and a close date. Read pipeline for the forecast, performance for quota, and activity for whether the work is happening. Review those numbers on a schedule and put them on a dashboard.

How do you track sales progress?

Progress is quota attainment for the period, set against the prior period, with win rate, pipeline coverage, and sales velocity beside it. A weekly review looks at which deals moved, which close dates slipped, and what pipeline was added. A monthly review looks at attainment, win rate, deal size, cycle length, and stage conversion.

What is sales performance tracking?

Sales performance tracking is the result against the number the business promised: quota attainment, win rate, and average deal size. It is separate from the open pipeline and from activity. Finance and sales management read it monthly.

How do you keep track of sales in a small business?

Start with one spreadsheet, one row per opportunity, and the columns the formulas need: stage, amount, dates, owner, and outcome. Keep won and lost rows, and calculate win rate from them. Move to a CRM such as HubSpot or Salesforce when a second person is selling or when copies of the file appear. The metrics do not change when the tool does.

What is real-time sales tracking?

Real-time sales tracking means the CRM is updated when the deal changes and the dashboard refreshes before the meeting. A daily refresh is enough for a weekly review. Power BI and Tableau can both take Salesforce or HubSpot data and refresh on that schedule.