Sales leaderboard template: columns, formulas, resets

Build a leaderboard from three decisions: which columns appear, which formula produces the rank, and how often the board resets. Get the columns wrong and reps cannot tell what to do next. Get the formula wrong and the same person wins every month, which is the most common reason gamification programmes are quietly switched off. Get the reset wrong and the board either churns too fast to mean anything or goes stale before the cycle closes. This template gives a default for each, plus a worked eight-rep board ranked four different ways. It assumes you already have a points model — if not, the scoring model template builds one.

The columns

Six columns is the working maximum. On a wall screen it is five, because rank and rep name eat the width.

Four things stay off the board. Commission or earnings figures, because a leaderboard is a public artefact and pay is not. Quota attainment for anyone on a formal performance plan, because publishing it converts a management process into a spectacle. Any activity that is not in the scoring model, because unscored columns train people to optimise things the model does not value. And bottom-position highlighting of any kind — no red rows, no "needs improvement" band. Rank order already communicates the bad news; decorating it is what makes reps ask for the board to come down.

Four ranking formulas

Absolute points

score = Σ (activity count × point weight)

The default, and the right answer only when patch quality, inbound routing and tenure are genuinely even across the team. Test it before committing: rank your last three months by absolute points and check whether the top three seats change. If the same three names hold, the board is a record, not a contest.

Percentage to target

score = points ÷ individual period target × 100

Handles uneven patches and mixed quotas. The cost is that the board is only as defensible as the target-setting process — if reps believe quotas are arbitrary, this formula moves the argument rather than settling it. Publish the targets alongside the board.

Tenure bands

Rank within cohorts rather than across the whole team, using absolute points inside each band. Typical bands are 0–6 months, 7–18 months and 19+ months. Three bands beats two because a rep in month seven and a rep in month seventeen are not comparable either. Each band gets its own visible top position, so there are three winners a month instead of one.

Improvement index

score = current period points ÷ rep's own trailing 3-period average × 100

The only formula where a new rep and a top biller compete on equal terms, because each is measured against themselves. It rewards trajectory, so it is the strongest choice for mixed-tenure teams and the weakest for a pure revenue push — a rep can top an improvement board while producing the least. Run it as a secondary board rather than the primary one.

The same team, ranked four ways

Eight reps, one month, scored on the same model. Targets are individual. Baseline is each rep's trailing three-month average score.

The resulting orders:

Same data, four different stories. Absolute points tells the two-year reps they are winning, which they already knew. Improvement surfaces Aisha, Elena and Nadia — the three people whose behaviour actually changed this month — and correctly flags Tom, who dropped against both his target and his own baseline while still sitting fifth on the absolute board. That Tom signal is the one worth having, and the absolute board hides it entirely.

The practical setup is a primary board on percentage to target and a secondary board on improvement, both visible. Sales Gamification runs multiple boards concurrently, and the fairness calibration pass inspects tenure and territory spread on your own data to recommend which formula the primary board should use.

Reset cadence

Match the reset to the sales cycle, not to the calendar you happen to report on. The rule of thumb: a rep should be able to influence their rank inside a single reset period.

Two supporting rules. Keep an all-time or rolling-12-month board alongside the resetting one, so long-run performance is not erased every period — the reset controls competition, the persistent board controls recognition. And never reset mid-competition; if a contest spans a reset boundary, the contest keeps its own frozen scoreboard, defined in the competition rules document.

Refresh, display and placement

Refresh on CRM sync rather than on a fixed timer, so a rep who logs a demo sees the board move within minutes. Latency is what makes a leaderboard feel live; a board updated overnight is a report.

For wall-mounted TV boards, cut to five columns and no more than twelve rows, rotate between the primary board and one competition board on a 20-second cycle, and size type for reading at four metres. For the in-app board keep the full six columns and let reps expand their own row for the complete component breakdown.

Pair the board with event notifications rather than relying on people to look at it. A rank change or a closed deal posting into Slack or Microsoft Teams does more for engagement than any board design decision, because it reaches the rep where they already are. The full setup, including CRM field mapping for Salesforce, takes about four minutes through Blueprint — start a 14-day trial, no card required.

FAQ

How many columns should a sales leaderboard have?

Six at most in-app: rank, rep, score, movement since last refresh, the two largest score components, and progress to target. On a wall-mounted screen, five, because rank and name consume the width and anything smaller is unreadable at distance. Extra columns reduce the board's usefulness rather than adding to it, because reps stop reading past the third column.

What is the fairest way to rank a sales leaderboard?

There is no single answer, but improvement against each rep's own trailing baseline is the only formula where a two-month rep and a three-year rep compete on equal terms. Percentage to individual target is the best primary formula for most teams. Absolute points is fair only when territories, inbound routing and tenure are genuinely even — test it by checking whether the top three seats changed over the last three months.

How often should a sales leaderboard reset?

Weekly for cycles under 14 days, fortnightly for 14 to 45 days, monthly for anything longer. The test is whether a rep can influence their rank within one reset period. Keep a rolling 12-month board running alongside the resetting one so long-run performance is recognised rather than erased, and never reset in the middle of a running competition.

Should a leaderboard show every rep or only the top performers?

Show every rep, and avoid highlighting the bottom in any way — no red rows, no separate "needs improvement" section. Truncating to a top five tells everyone below it that the board is not for them, which removes the feedback loop from the people who most need it. Rank order communicates position adequately without additional decoration.

Can one team run more than one leaderboard at once?

Yes, and most teams should. A common pairing is a primary board on percentage to target and a secondary board on improvement against baseline, so the board rewards both output and trajectory. Add a third only if it measures something the first two do not — three boards measuring near-identical things splits attention without adding information.