Skip to main content

How I Built a One-Page Weekly Scorecard for Sales Reps

When the CEO of the food company where I worked asked for a way to evaluate our salespeople, I ended up leading the project. What we built was a one-page weekly scorecard for every sales rep, combining hard numbers with the judgment of the people who worked alongside them. This is how it was put together, what it was used for, and what I'd keep in mind if you're building something similar.

Where did the sales evaluation system come from?

It started with an instruction from the CEO. The assignment landed on me as someone who already worked on sales planning and sales management, and I took the lead on developing it.

I'd already spent years in the part of Korean sales that isn't selling: the planning, the reporting, the numbers behind the people in the field. Evaluating salespeople fits right into that territory, and it's harder than it looks, because a sales rep's results depend on things the rep doesn't control, like territory, customers and timing.

What did the scorecard measure?

We set it up around KPIs tracked on two clocks, weekly and monthly. The weekly view kept a rep's recent activity in front of them and their manager. The monthly view gave the bigger picture.

The scorecard didn't stop at numbers. It combined two kinds of evaluation:

  • Quantitative: the KPIs themselves.
  • Qualitative: assessments from the rep's team leader and from colleagues.

The quantitative part ran weekly and monthly. Peer assessments were collected quarterly, since asking colleagues to evaluate each other every week would turn it into a chore.

Why combine numbers with peer and manager reviews?

Here is the general case for it, separate from our particular system. A number can tell you what happened, but it rarely tells you why. Someone can hit a target by borrowing from next quarter, or miss one while building a customer relationship that pays off later. A team leader and teammates see how a person works, and that context helps explain the figures. The risk of relying on judgment alone is bias and favoritism, which is why you want the numbers next to it, not instead of it.

Why one page per salesperson?

Each rep got a one-page report every week. One page is a deliberate limit. A report that runs to ten pages gets skimmed, and a rep can't act on ten pages of data. One page forces a decision about which numbers actually matter, and it gives the rep and the manager a single shared sheet to talk from.

What was the evaluation used for?

The purpose was practical on both ends. Top performers were recognized and rewarded. Those at the bottom were coached. I think that second half is the part people skip when they build these systems. A scorecard that only ranks people feels like a verdict. One that leads to coaching gives the ranking a reason to exist.

What tools did we use to build it?

It began in Excel and Python. From there it moved to Power BI, and by the time I left the company, the Power BI version was actually in operation. A web-based version was also planned, but that part stayed a plan.

If you're starting from nothing, I'd say the order matters less than people think. Get the logic right in a spreadsheet first. Moving it to a dashboard tool is the easy step once everyone agrees on what the numbers mean.

What to check before you build a sales scorecard

  • Can you explain every KPI on it in one sentence, and does the rep agree it reflects their work?
  • Does the report fit on a single page that a busy person will actually read?
  • Do the qualitative reviews run on a slower cycle than the numbers, so they don't become a weekly burden?
  • Is there a clear next step for the best performers and for the weakest ones?

If I had to boil the whole project down to one idea, it's that an evaluation is only worth building if the person being evaluated gets something back from it. 

Labels:

Comments

Post a Comment

Popular posts from this blog

The First Three Months Aren't About the Job

  The First Three Months Aren't About the Job Every desk looks like this before it's yours. I have started at six companies. Doosan, a furniture company, LG, the same furniture company again, ten years in food, and finally the fitness equipment company where I finished. Six first days. Six first three months. You would think it gets easier. It doesn't, not really. The company changes, the desk changes, but the first three months are always about the same thing, and it is never the job. What you actually learn Nobody hands you a manual for this, because it isn't written down anywhere. You learn it by watching. Who you're going to be working with. When people actually leave, as opposed to when the official hours say they leave. Who eats lunch with whom, and whether that is fixed or whether it moves around. The lunch thing sounds small until you are standing in it. Someone senior asks if you want to join them for your first lunch, and of course you say yes, because say...
Post a Comment
Read more

The Buldak Boom, Seen From a Rival's Desk

The Buldak Boom, Seen From a Rival's Desk For about ten years I worked at a Korean company that made soy sauce and fermented pastes. Not the glamorous end of the food business. Nobody has ever filmed a challenge video about soy sauce. But the industry here is small, and people talk. Lunch is where you find out what is really going on at the other companies. Who is hiring. Who stopped paying bonuses. Who is quietly in trouble. Some of the people I worked with had come to us from Samyang Foods. "That place is finished" That was the general view, and it wasn't gossip. It was a reasonable read of the situation. Samyang made the first instant ramyeon in Korea. At one point they had something close to seventy percent of the market, which is a number that sounds made up now. Then came the 1989 industrial tallow scandal. They were cleared in court eventually, but the case dragged on for nearly six years, and by the time it ended their share had fallen into the teens. It never...
Post a Comment
Read more

I Went to Collect a Debt and Came Back Having Paid for Dinner

  I Went to Collect a Debt and Came Back Having Paid for Dinner First, let me fix something, because Korean dramas have given people a strange idea about this. Nobody is driving around the country collecting cash. Payment terms are in the contract, the money comes by bank transfer, and in a normal month nothing happens at all. Same as anywhere. Two things are different here, though. One is a piece of paper. The other is which person gets sent when the money doesn't come. A piece of paper that is not money yet Korean companies pay each other with something called eoeum . In English it gets translated as a promissory note, which is correct and also tells you almost nothing. It is not a cheque. A cheque is money now. This is a written promise that the money will exist on a date printed on the paper, usually sixty or ninety days later. Your customer hands it to you. Your books say the sale is collected. You drive back to the office holding a piece of paper that will be worth its face v...
Post a Comment
Read more