Sales KPIs Template

This template imports fifteen KPIs that cover a sales operation end to end: the pipeline that feeds it (Opportunities, Prospect Meetings, Quotes), the results it produces (Number of Sales, Sales Revenue, Average Sale Revenue) and what the whole effort costs to run (Cost of Sales Force). Between those sit the revenue-mix KPIs, New Sales Revenue and Repeat Sales Revenue, which show whether growth is coming from new customers or the ones you already have.

The set is deliberately self-contained. Every ratio in it is built from counts that are also in it: Closing efficiency comes from Quotes and Number of Sales, Upselling Success Rate from Attempted 'Up Sales' and Successful 'Up sales', New Sales Percentage from the two revenue streams. When a percentage moves, the numbers behind it are already on the same dashboard, so you're never arguing about a rate you can't take apart. You can keep the ratios calculated automatically with formula KPIs instead of entering them by hand.

That structure is the argument for importing a set rather than picking KPIs one at a time. Sales Revenue on its own tells you what happened. Read beside Value of Quotes and Average Sale Revenue, it tells you what next month looks like, and whether it will come from more deals or bigger ones.

Sales managers work this set daily. Their question is blunt: are Quotes and Prospect Meetings running at a level that will make the revenue target, and is Closing efficiency holding while the team pushes for volume? Reps mostly watch their own slice, the activity counts and their personal close rate, especially where the numbers are displayed openly.

Owners and sales directors ask a different question of the same fifteen numbers: is the revenue worth what it costs? For them it's Cost of Sales Force against Sales Revenue, plus the new versus repeat mix, checked weekly rather than hourly. Finance tends to join that conversation once a quarter, and having the cost and the revenue on the same board keeps it short.

Import first, set targets second. Most of these KPIs need a baseline before a target means anything: nobody can tell you the right number of Prospect Meetings for your team, but your own last quarter can. Run the template for a month or two, then set activity targets that ask for a modest, believable lift on that baseline. Cost of Sales Force is the exception: it is set by your budget, not by a trend, so give it a figure on day one. For the ratios, direction beats absolutes. A target of "better than last quarter" on Closing efficiency survives contact with a real quarter far longer than a number picked off a chart, because everyone can see where it came from.

Once some history builds, Kip can suggest targets and indicative benchmarks. Those benchmarks are AI estimates rather than peer data, so treat them as a sanity check on your own numbers, not a replacement.