// GuidesTemplate
Sales rep scorecard template (Excel/Sheets): 8 metrics, weights and a weekly rhythm (2026)
Short answer
A sales rep scorecard is one sheet per rep with eight metrics: four leading (first meetings booked, pipeline created, touches on open deals, deals past the stale line), three lagging (closed-won against plan, win rate, sales cycle days) and one you rate by hand (call quality). Weight them 50/40/10, score each row as actual divided by target capped at 120%, fill it every Monday in about 15 minutes, and read it with the rep in the weekly 1:1. Seven rows come from saved CRM reports that Salesforce and HubSpot can email you on a schedule; the call rating and the targets stay yours.
Which metrics belong on a sales rep scorecard? Eight, leading and lagging
Eight. Four leading metrics a rep can move this week, three lagging metrics that prove the leading ones are working, and one judgment you make by listening to a call. Use only calls recorded under your company's recording policy and the consent rules where your reps and buyers are. Leading metrics are inputs; they change week to week and are where you coach. Lagging metrics are results; they move over months and settle whether the coaching worked.
| Metric | Leading or lagging | What it tells you |
|---|---|---|
| First meetings booked | Leading | Whether new pipeline is being started. The earliest number that moves. |
| Pipeline created | Leading | Whether meetings become qualified opportunities of the right size. |
| Touches on open deals | Leading | Whether existing deals are being worked. Activity logged on open opportunities only, so volume on a cold list does not score. |
| Open deals past the stale line | Leading | No logged activity for 7, 14 or 21 days by sales-cycle length. Lower is better; the hygiene row. |
| Closed-won vs plan to date | Lagging | Attainment, pro-rated to the week of the quarter. The number the rep is paid on. |
| Win rate, rolling 90 days | Lagging | Whether qualification and execution hold up; needs five closed deals in the window. |
| Sales cycle days, median of won deals | Lagging | Whether deals move at the usual pace or get carried. |
| Call quality, 1 to 5 | Rated by you | The skill behind the numbers, from one call a week against a short rubric (discovery, objection handled, next step secured). |
The stale line follows the rule used across these guides, 7 days on a sales cycle under 30 days, 14 for 30 to 90 days and 21 for over 90; a rule of thumb, so adjust it to your data. The pipeline hygiene checklist has the report.
The sales rep scorecard template (Excel or Google Sheets layout)
One tab per rep, eight rows, seven columns. The first five columns are set once a quarter and copied to every tab; the last two change weekly. The numbers are illustrative; the targets come from the procedure below.
| Metric | Type | Source | Target | Weight | This week | Trend |
|---|---|---|---|---|---|---|
| First meetings booked | Leading | CRM meetings report | 6 a week | 15 | 5 | Below target, 3 weeks |
| Pipeline created | Leading | CRM opportunities, created date | $60k a week | 15 | $72k | Up |
| Touches on open deals | Leading | CRM activity on open deals | 60 a week | 10 | 48 | Down |
| Open deals past the stale line | Leading | CRM deal report, last activity | 2 or fewer | 10 | 4 | Up (worse) |
| Closed-won vs plan to date | Lagging | CRM closed-won | 100% | 20 | 84% | Flat |
| Win rate, rolling 90 days | Lagging | CRM closed deals | 25% | 10 | 28% | Up |
| Sales cycle days, median won | Lagging | CRM won deals | 45 or fewer | 10 | 51 | Flat |
| Call quality | Rated | One reviewed call | 4 of 5 | 10 | 3 | Flat |
Score each row as this week divided by target, capped at 120% so one big week cannot carry the card, times the weight. For the two rows where lower is better, stale deals and cycle days, divide target by actual. Add the eight rows. The rep above scores about 88 out of 100. Six rows sit below target (meetings, touches, stale deals, closed-won, cycle days, call quality) and two above it (pipeline created, capped at 120%, and win rate); the net is the missing 12 points.
The trend column needs history, and a spreadsheet only remembers what you save, so keep a second tab per rep, one row per week, filled before you overwrite the card.
| Week of | Meetings booked | Pipeline created | Touches | Stale deals | Score | Note |
|---|---|---|---|---|---|---|
| Sep 1 | 7 | $55k | 61 | 1 | 96 | Quarter start |
| Sep 8 | 6 | $58k | 58 | 2 | 93 | Two deals in legal |
| Sep 15 | 5 | $80k | 52 | 3 | 90 | Big new opportunity |
| Sep 22 | 5 | $72k | 48 | 4 | 88 | Third week under target; ask in the 1:1 |
Tip
How to read this card
Meetings sat under target for three weeks and touches fell every week while pipeline created went up, so the rep is chasing the big new opportunity and letting the rest go stale. Bring the trend tab to the 1:1 and ask "what happened these three weeks?" rather than "why are your numbers down?".
How should you weight a sales rep scorecard?
Put 50 points on the leading rows, 40 on the lagging rows and 10 on the rated row for an established rep. Shift to 70/20/10 for a rep in ramp, whose results cannot be judged yet, and toward 30/60/10 for a senior rep on a long cycle, whose inputs you already trust.
- No single row above 20 points. A row that can carry the card gets gamed, or hides the other seven.
- Cap every row at 120% of target, so one big week on pipeline created cannot erase four stale deals.
- Score lower-is-better rows as target divided by actual. Two stale deals against a target of two scores 100%; four scores 50%.
- Change weights once a quarter, with the reps, never mid-quarter. A weight moved after the fact reads as moving the goalposts.
Watch out
The results-only scorecard
A card that is all closed-won and win rate confirms in month three what you could have acted on in week two. Keep at least half the weight on leading rows.
How to set the targets (a 6-step procedure)
Set targets from your own reps' history and check them against the plan with arithmetic. A target copied from a template measures the template.
- Pull two quarters of history per rep from the CRM, by week, for the seven CRM rows.
- Work backward from the plan for the lagging rows, then forward into the leading rows. Say the quarterly quota is $180k, the average won deal $20k and the win rate 25%. That is 9 wins and 36 opportunities, so 3 new opportunities or $60k of pipeline a week over 12 working weeks, and 6 meetings a week if half of first meetings become opportunities. The arithmetic is the reason you give the rep.
- Check each leading target against the reps who hit plan last quarter. If the arithmetic says 6 meetings and your best reps book 4, the plan needs a conversation before the scorecard does.
- Set the touches target from won deals. Median logged touches per open deal per week, times the open deals a rep should carry. Put the stale-deal target at two or fewer.
- Ramp new reps on a schedule you write down. For example, 50% of target in month one, 75% in month two, 100% from month three.
- Copy the template per rep and walk each rep through their own numbers in the next 1:1. A target the rep has not seen is not a target.
Can the scorecard update itself from the CRM?
Mostly. Seven of the eight rows are CRM reports, and both Salesforce and HubSpot can email a saved report on a schedule, so the weekly fill is a paste.
| Row | Fills itself? | How |
|---|---|---|
| Meetings booked, pipeline created, closed-won, win rate, cycle days | Yes | One saved report per row, grouped by owner, scheduled weekly; paste the column in. |
| Touches on open deals | Yes, if reps log activity | Activity report filtered to open opportunities; calls still need logging. |
| Open deals past the stale line | Yes, with a filter | Deal report where the last activity date is older than the stale line. |
| Call quality | No | Your rating; a recorder can find the call. |
| Trend | Only with history | A report shows now; keep the weekly tab. |
| Targets and weights | No | Once a quarter, by hand, with the reps. |
In Salesforce, subscribe to a report and the refreshed results arrive by email on the schedule you set, with a formatted .xlsx attached if you choose (Subscribe to Reports in Lightning Experience). In HubSpot, a dashboard or report can be emailed on a daily, weekly or monthly schedule, with a data file for supported report types, to HubSpot users only (Share or export reports and dashboards).
How diffi helps
The sheet stays yours; diffi answers the questions the sheet raises. It connects Salesforce or HubSpot read-only and answers, in plain language, a rep's deal count, open pipeline, win rate, sales cycle days, deals created and closed, and activity count, with nightly snapshots, so "how has this changed over four weeks" has an answer without a history tab. Every rep also has a file with a summary, a timeline across the sources you connect, and active signals with their evidence, so when meetings are down you can read what happened that week before the 1:1. It does not compute activity drops against a rep's own baseline; the call rating and the targets stay yours. Book a demo to see it against your own CRM.
See it on your own teamHow often should you update and review the scorecard?
Fill it weekly, read it in the weekly 1:1 (the sales 1:1 template has the rest of the meeting), review targets monthly and weights quarterly. A week is the shortest period in which the leading rows mean anything, and a slipping row left for a month costs a quarter.
| Minutes | Step | Source |
|---|---|---|
| 5 | Paste the CRM columns into each rep's card | The scheduled report emails, seven rows |
| 5 | Add this week's row to each trend tab | The card, before you overwrite it |
| 5 | Mark the rows that moved | This week against the trend tab |
Monthly scorecard review (30 minutes, first week of the month)
- Compare each rep's month against their trend tab. Three weeks down on any leading row goes on the 1:1 agenda, whatever the total score says.
- Check that the lagging rows moved the way the leading rows predicted; meetings on target for eight weeks with no pipeline created means a wrong target or wrong meetings.
- Look for a row every rep misses (a target or process problem, yours to fix) and a row every rep beats (raise it or drop it).
Rules on recording, monitoring and employment differ by jurisdiction and this page is not legal advice; check with HR or an employment lawyer before it becomes policy.
Frequently asked questions
What is a sales scorecard?
A sales scorecard is a one-page view of a rep's performance against a fixed set of targets: a handful of metrics, each with a target, a weight, the current number and a trend, adding up to one score. It differs from a dashboard in that it shows only the metrics you agreed to manage, and from a leaderboard in that it measures each rep against their own targets rather than against each other.
What metrics should be on a sales rep scorecard?
Eight. First meetings booked, pipeline created, touches on open deals and open deals past the stale line are the leading rows. Closed-won against plan, win rate over the last 90 days and median sales cycle days are the lagging rows. The eighth is a call-quality rating you give by listening to one call a week. Every row except the rating comes from a CRM report.
What is the difference between leading and lagging indicators on a sales scorecard?
Leading indicators are inputs the rep controls this week, such as meetings booked and pipeline created; they predict results and move fast. Lagging indicators are the results, such as closed-won and win rate; they prove the inputs are working and move over months. Coach on the leading rows and judge on the lagging ones.
How do you weight a sales scorecard?
For an established rep, 50 points on the leading rows, 40 on the lagging rows and 10 on the manager-rated row, with no single row above 20 and every row capped at 120% of target. Shift toward the leading rows for a rep in ramp (70/20/10) and toward results for a senior rep on a long cycle (30/60/10). Change weights only at the quarter, and with the reps.
How often should a sales scorecard be updated?
Weekly. Fill it on Monday from the CRM reports, read it with each rep in the weekly 1:1, review targets in the first week of each month and weights once a quarter. Daily updates add noise, and monthly updates find problems a month late.
Can a sales scorecard update automatically from Salesforce or HubSpot?
Seven of the eight rows can. Both CRMs can email a saved report on a schedule (Salesforce report subscriptions, HubSpot recurring dashboard emails), so the weekly fill is a paste or a linked sheet. The call rating is yours, the trend needs a history tab because a report only shows now, and targets and weights are set by hand each quarter.
Should reps see their scorecard?
Yes, every week, with the targets and weights explained before the first one is scored. A scorecard reps cannot see reads as monitoring rather than management, and reps who can see theirs fix the leading rows themselves. Share each rep's card with that rep, in the 1:1 or privately, never the score on its own and never in a team channel.