PG
Case 02 · Predictive · Performance

Sales Rep Scoring Model

A standardized, goal-relative performance scoring model that lets leaders compare sales reps fairly across departments and years — refined across four iterations of direct leader feedback, with annual and quarterly views and percentile-based pattern overlays.

PythonTableauSQL
01 / 04
Why it mattered

Why it mattered

Raw revenue isn't a fair way to compare sales reps. Reps carry different goals, roles, departments, tenures, and opportunity sets — a strong producer against a stretch goal and a strong producer against a more conservative goal aren't the same story. Leaders needed a defensible, goal-relative way to rank performance, anchor coaching, and surface intervention candidates without falling back on anecdote or absolute-dollar leaderboards.

02 / 04
What I built

Built on four pillars

A standardized, goal-relative performance scoring model that lets leaders compare reps fairly across departments and years. Refined across four iterations on direct leader feedback, with annual and quarterly views and percentile-based pattern overlays.

01

Standardized goal-relative score

A fiscal-year performance score per rep, per department, that measures performance against monthly goals rather than absolute dollars — putting smaller-goal and larger-goal reps on the same scale.

02

Four-component balance

Designed to reflect how leaders already evaluate informally: production magnitude relative to goal, monthly hit/miss consistency, sustained pace through rolling windows, and overall revenue-to-goal efficiency. Each component shows up explicitly so leaders can see which behavior is strong and which is the gap.

03

Fairness adjustments after leader feedback

Refined across four iterations following a leadership read-out. Bucket vesting (gradual production credit through the fiscal year) protects in-year scoring from being dominated by a single strong early month. A Months Eligible adjustment partially regresses thin partial-year records toward a baseline so they can't outweigh fully observed reps. The minimum eligibility floor for the main ranked population was raised to keep comparisons evidence-deep.

04

Quarterly diagnostics + star profiles

A quarterly trend layer surfaces short-term spikes, dips, and trajectory changes that an annual score smooths over. Percentile-based star profiles describe the type of performance behind a score — steady performer, high-volatility producer, late-quarter closer — without changing rank order.

At a glance

The shape of the work

  • 4 iterations refined on direct leader feedback
  • 2 scoring time horizons — annual (rankable) and quarterly (diagnostic)
  • 7+ documented leader use cases — coaching, intervention, recognition, performance review, promotion support, goal calibration, current-rep management
03 / 04
How leaders use it

How leaders use it

Anchors coaching, recognition, performance reviews, and goal-calibration conversations — and surfaces in-year trajectory changes an annual score would smooth over.

  • CoachingAnchors 1:1 conversations on the specific component that's strong or the specific gap to close.
  • InterventionQuarterly score flags in-year declines an annual score would mask.
  • RecognitionSurfaces consistently strong performers across departments using the rankable fiscal score.
  • Promotion and performance review supportCombines fiscal score, quarterly trend, and star profile for a fuller picture than any single number.
  • Trend monitoringTracks directional change through the year.
  • Goal calibrationScore patterns by department surface where goal-setting may be miscalibrated.

Not a compensation formula. Not a black-box AI model. Not a replacement for manager judgment. Not a standalone basis for termination or promotion. Not a raw revenue leaderboard. It is a structured decision-support tool that pairs with leader judgment.

04 / 04
What this unlocks

What this unlocks

With a defensible, structured score in place, the same framework supports embedded use across 1:1s, performance reviews, and management rhythms — plus category-based ratings on top of the rank order, tighter live integration with the production Tableau views, and a base for evaluating goal-setting calibration across departments without rebuilding the underlying logic.

Stack

Built with

PythonTableauSQL