How to Combine Attendance and Sales Performance Into One Leaderboard Score
Most sales leaderboards rank people on one thing. Revenue, deals closed, calls made, pick your metric. That works fine until you've got a rep who's never late, always covers the open shift, and quietly helps the new hires find their feet, but sits somewhere in the middle of a pure sales ranking. Or you've got the opposite problem: a great closer who's barely around, and your coverage suffers for it.
If either of those sounds familiar, you've probably gone looking for a way to combine attendance and sales performance into one score. The idea is easy enough. Actually weighting the two fairly is where it gets messy.
Here's the formula, a full worked example, the mistakes that quietly wreck a composite score, and how to keep one running without rebuilding a spreadsheet every Monday.
Why teams want a single combined score
Sales-only leaderboards reward exactly one behavior: closing. For a pure hunter role, that's probably what you want. But plenty of teams don't work that way. On a sales team leaderboard covering retail floors, call centers, shift-based selling, or reps who are still ramping and building pipeline, showing up isn't a side metric. It's a real input to the number.
Flip it around and attendance-only tracking has the opposite flaw. It tells you who's present, not who's producing. You end up with two dashboards that each tell half a story, and a lot of manual squinting to figure out who your actual top contributors are.
A blended score solves this, as long as you build it properly. Just adding the two numbers together, which is what most people try first, doesn't work at all.
The core formula
Composite Score = (Normalized Sales Score × Weight A) + (Normalized Attendance Score × Weight B)
Weight A and Weight B add up to 100%.
The step almost everyone skips is normalization, and skipping it breaks everything downstream. Say you add a sales figure of $48,000 to an attendance rate of 95%. The sales number swamps the attendance number completely, because they're not measured in comparable units. Before any weighting can mean anything, both metrics need to sit on the same scale. Usually 0 to 100.
For sales:
Normalized Sales Score = (Rep's Sales ÷ Highest Sales on Team) × 100
For attendance:
Normalized Attendance Score = (Days Present ÷ Total Scheduled Days) × 100
Now both live on the same scale, and a 70/30 split actually behaves like a 70/30 split.
Picking your weights
There's no universally correct answer here. It depends on how much attendance genuinely drives results on your particular team. Three splits worth considering as a starting point:
80/20, sales-heavy. Attendance functions as a light tiebreaker. Good for outbound and hunter roles where output is what matters, but you still want a gentle nudge against no-shows.
60/40, presence-driven. Retail floors and call centers land here. If a rep isn't there, the calls don't get taken and the floor doesn't get covered, so presence is a genuine driver of the sales number rather than a compliance box.
50/50, onboarding and ramping. For new hires still building pipeline, consistent attendance is often the thing you're actively trying to build as a habit. Weighting it equally makes sense while they ramp.
Pick one, run it for a full period, then adjust. The weighting is a management decision more than a math one. Get the formula right first, then tune the split until the rankings match what you'd tell someone if they asked who your best performers really are.
A worked example
Here's a four-person team halfway through the month, scored with a 70/30 sales-to-attendance split.
| Rep | Sales ($) | Normalized Sales | Days Present / Scheduled | Normalized Attendance | Composite (70/30) |
|---|---|---|---|---|---|
| Dana | $42,000 | 100 | 18/20 | 90 | 97.0 |
| Marco | $39,500 | 94 | 20/20 | 100 | 95.8 |
| Priya | $31,000 | 74 | 20/20 | 100 | 81.8 |
| Leo | $28,000 | 67 | 14/20 | 70 | 67.9 |
Rank the same team on sales alone and the order doesn't change: Dana, Marco, Priya, Leo. But look at what happens to the gaps. Dana and Marco were $2,500 apart on raw sales. On the composite they're separated by 1.2 points, because Marco's perfect attendance nearly closes the distance. And Priya, who's mid-pack on revenue, holds a comfortable lead over Leo instead of watching him creep up on her.
That compression is usually the point. You're not trying to hand the top spot to whoever shows up most. You're trying to stop a strong closer's absence from going completely unnoticed, and to give a consistent rep credit for being consistent.
Run those same numbers at 50/50 and the order does start to shift. That's the lever you're pulling when you choose weights.
Mistakes that quietly break composite scores
Adding raw numbers without normalizing. By far the most common one. It makes attendance mathematically irrelevant, since sales figures tend to be hundreds of times larger. The leaderboard still produces a ranking, so nobody notices anything is wrong.
Leaning too hard on attendance. Push the weight too far and you start rewarding people for clocking in, which is the opposite of what a sales leaderboard is for. Your team will spot this faster than you think.
Forgetting to re-normalize. Add a new hire or shift the sales targets and "100" now means something different. Scores calculated against an old baseline slowly drift out of fairness, and it's hard to spot because the numbers still look reasonable.
Scoring once and leaving it. A composite from three months ago doesn't describe the team you have today. Reset and recalculate on a set cadence, weekly or monthly depending on how long your sales cycle runs.
Doing this without a spreadsheet
A spreadsheet is genuinely fine for version one. You'll get a working composite score in an afternoon.
It stops being fine around the point you want it updating live, showing on a screen the team can actually see, resetting on its own each period, and staying accurate as your normalization baseline moves. That's when you find yourself patching formulas every week instead of coaching anybody.
TrackScore handles the tedious parts. You set your sales and attendance inputs, it normalizes and weights them, and you get a live board you can put on a TV or share with a link. Period resets happen automatically, so the score never goes stale on you.
[Build a combined sales + attendance leaderboard →]
FAQ
What's a fair weight split between sales and attendance?
Depends entirely on how directly attendance affects sales in your setup. Start around 70/30 or 80/20 for hunter-style roles, closer to 50/50 for onboarding or shift-based teams. Run it for one full period, look at the rankings, and adjust if they don't match your gut sense of who's performing.
Can I change the weighting after the leaderboard is live?
Yes, and you probably should. Treat the first period as a calibration run. Just make the change between periods rather than partway through one, so nobody's comparing scores calculated two different ways.
Does this work if reps have different sales targets?
It does, with one change to the formula. Instead of normalizing against the highest sales figure on the team, normalize against each rep's own target. Swap "Highest Sales on Team" for "Rep's Individual Target" in the denominator and the score stays fair across people carrying different quotas.