Sales KPI Dashboard for a Small Team: What to Track Weekly

Choose numbers that tell you what will happen and what did happen. Group them like this:

Pipeline panel (what's coming):

• New qualified pipeline created this week and this month.
• Total open pipeline and coverage against the remaining target.
• Deals past their expected close date.

Conversion panel (what's working):

• Stage-to-stage conversion, especially from first meeting to qualified.
• Win rate on closed opportunities, new business and expansion separately.
• Average sales cycle length.

Activity and results panel (what people did):

• Meetings held with qualified buyers, not total calls.
• Closed-won revenue against the plan, and average deal size.

The average B2B new-logo win rate is 19 percent¹, and the average new-business cycle is 91 days². Use those as loose context, then compare your own numbers against your own history.

Put results at the top and causes below them. A weekly review should read from left to right: are we on target, where is the pipeline heading and what did the team do?

1. Top row: closed-won against plan and current coverage.
2. Middle row: pipeline created, stage conversion and deals stuck in stage.
3. Bottom row: meetings held and follow-ups overdue, per rep.

Limit the dashboard to one screen. Add a filter for rep and for segment, but keep the default view at the team level. If a number never prompts a question in the meeting, remove it.

Definitions are the difference between a dashboard people trust and one they argue about. Write each in one line and keep the list next to the dashboard:

• Qualified opportunity: the criteria that a deal must meet before it counts, such as a confirmed problem, a named decision maker and a next meeting.
• Win rate: closed-won divided by closed-won plus closed-lost in the period, not by all open deals.
• Cycle length: days from opportunity creation to close date for won deals.
• Deal size: average contract value of closed-won deals, with the median beside it.
• Meeting held: a scheduled meeting that took place with someone on your target list.

For example, if one rep counts a quick check-in as a meeting and another doesn't, their activity numbers can't be compared. Agree on the rule and apply it to history too.

A number only helps if it leads to an action. Pair each with a default response:

• Pipeline created falls: review outreach volume and target list quality this week, since it takes a full cycle to fix.
• Stage conversion drops at one stage: listen to three recent calls at that stage and look for a pattern.
• Deals stuck past expected close: set a next step with a date or close them out.
• Win rate falls: check whether qualification loosened or a competitor appeared.
• Meetings held falls: look at calendar blocks and the prospect list before blaming effort.

Activity counts can mislead by themselves. A rep making many calls with no conversations isn't doing well, so read them alongside outcomes, as discussed in rep activity metrics vs outcome KPIs.

Small teams often copy dashboards from larger companies and end up tracking numbers they can't act on. Leave these for later:

• Forecast accuracy by rep. With a handful of deals a quarter, one slip swings the percentage wildly. Track whether the total forecast landed instead.
• Multi-touch attribution. First source and revenue by source answer most of the questions a small team has.
• Quota attainment distributions. These are meaningful with many reps, not two or three.
• Ratios between many stages. Track the one or two stages where deals actually stall.
• Individual talk time and email counts. They're easy to game and rarely explain results by themselves.

You can add them when there's enough volume to make the numbers steady and someone with time to act on them.

Most small-team CRMs can produce these reports without extra software. Pipedrive can build funnel reports, pipeline views and rep activity summaries, and Close can show call and email activity next to opportunity data. Start by building the top row, get it accurate, then add the rest.

Data quality decides whether any of it works. Required fields on the opportunity (amount, expected close date, stage, source) prevent gaps, and a monthly cleanup of stale deals keeps the pipeline honest. If you're still choosing a CRM, Close vs Pipedrive vs HubSpot compares them, and the sales playbook template helps you define the stages that the dashboard depends on.