Higher sales do not automatically mean better sales performance.
Revenue can increase while return rates rise, average order value falls, one channel becomes too dominant, or the sales team misses its targets. Looking only at total sales can hide those problems.
Sales KPIs help you understand not only how much you sold, but also how sales are changing, where results are coming from, how efficiently customers convert, and where performance may need attention.
In this guide, you will learn how to calculate and interpret nine practical sales KPIs for small businesses, retail stores, ecommerce businesses, and sales teams.
You will also find a free Sales KPI Excel template to track monthly sales, target attainment, growth, average order value, units per transaction, returns, store performance, and sales rep performance.
Quick answer: You do not need to track every possible sales metric. Start with a small group of KPIs connected to the decisions you actually make. For many small businesses, that means monitoring sales growth, target attainment, conversion, average order value, units per transaction, channel performance, sales rep performance, repeat purchases, and returns.
Table of Contents
- Sales KPIs at a Glance
- What Are Sales KPIs?
- Which Sales KPIs Should You Track?
- 9 Sales KPIs With Formulas and Examples
- How to Review Sales KPIs Without Overcomplicating Your Dashboard
- Free Sales KPI Excel Template
- Common Sales KPI Mistakes
- Frequently Asked Questions About Sales KPIs
- Methodology and References
Sales KPIs at a Glance
| Sales KPI | What It Helps You Understand | Basic Formula |
|---|---|---|
| Sales Growth Rate | Whether sales are increasing or decreasing over time | (Current Sales − Previous Sales) ÷ Previous Sales × 100 |
| Sales Target Attainment | Whether actual sales are meeting the target | Net Sales ÷ Sales Target × 100 |
| Conversion Rate / Win Rate | How efficiently opportunities become purchases or won deals | Depends on the business model |
| Average Order Value | Average revenue generated per order | Net Sales ÷ Orders |
| Units per Transaction | Average number of units sold per order | Units Sold ÷ Orders |
| Sales per Rep | How sales are distributed across the sales team | Rep Sales or Sales ÷ Active Reps |
| Channel Contribution | How much each channel contributes to total sales | Channel Sales ÷ Total Sales × 100 |
| Repeat Purchase Rate | How many eligible customers buy again | Repeat Customers ÷ Eligible Customers × 100 |
| Return Rate | Share of sold units that are returned | Units Returned ÷ Units Sold × 100 |
These metrics should not be interpreted independently. A stronger result in one KPI can sometimes create a problem in another.
For example, a promotion may increase sales and orders while reducing average order value or increasing returns.
What Are Sales KPIs?
Sales KPIs are measurable indicators used to evaluate whether commercial activity is producing the results a business expects.
They can help answer questions such as:
- Are sales growing?
- Are we reaching our monthly sales target?
- Are enough opportunities becoming purchases?
- Are customers spending more or less per order?
- Which channels generate the most sales?
- Are individual sales reps improving?
- Are customers buying again?
- Are returns increasing after sales grow?
The purpose of a KPI is not simply to create a report. A useful KPI should help you identify whether something changed, where the change happened, and what deserves investigation.
If you want to explore performance measurement beyond sales, visit our Metrics & KPIs section.
Sales Metrics vs. Sales KPIs
A sales metric is any measurable sales-related value.
- number of orders;
- number of units sold;
- number of opportunities;
- total sales;
- number of returns.
A KPI is a metric that is important enough to influence a decision or business objective.
For a retailer, Units per Transaction may be important. For a B2B company, Win Rate or Average Deal Size may be more useful.
The metric only becomes valuable when it helps you decide what to do next.
Which Sales KPIs Should You Track?
There is no universal list of sales KPIs that every business should use. The right indicators depend on how the business sells, how long the sales cycle is, and which decisions management needs to make.
Retail Stores
Retail businesses often benefit from monitoring:
- Net Sales;
- Sales Growth;
- Sales Target Attainment;
- Average Order Value;
- Units per Transaction;
- Sales by Store;
- Sales by Category;
- Sales per Rep;
- Return Rate.
A store may increase sales because more customers are buying, because each order is larger, or because shoppers are purchasing more units. Those are different situations and may require different actions.
Ecommerce Businesses
An ecommerce business may prioritize:
- Conversion Rate;
- Average Order Value;
- Sales Growth;
- Sales by Channel;
- Repeat Purchase Rate;
- Return or Refund Rate.
Conversion deserves more detailed analysis online because the final purchase rate may hide where shoppers abandon the buying process.
B2B and Service Businesses
B2B or consultative sales teams may focus more on:
- Sales Target Attainment;
- Win Rate;
- Sales per Rep;
- Average Deal Size;
- Pipeline Value;
- Sales Cycle Length;
- Customer Retention.
The important point is not to force a retail KPI into a B2B process—or the opposite. The denominator, sales cycle, customer behavior, and decision process are different.
9 Sales KPIs With Formulas and Examples
To make the examples easier to follow, imagine a fictional small business called Northstar Goods.
During April, the business recorded:
- Net Sales: $120,000
- March Net Sales: $108,000
- April Sales Target: $115,000
- Orders: 2,400
- Units Sold: 3,840
- Units Returned: 96
The business sells through physical stores and ecommerce. We will use these figures throughout the examples when appropriate.
1. Sales Growth Rate
Sales Growth Rate measures how much sales increased or decreased compared with another period.
Formula:
Sales Growth Rate = (Current Period Sales − Previous Period Sales) ÷ Previous Period Sales × 100
Example:
- March sales: $108,000
- April sales: $120,000
($120,000 − $108,000) ÷ $108,000 × 100 = 11.1% sales growth.
An 11.1% increase tells you that sales improved compared with the previous month. It does not explain why.
Growth could come from more customers, higher prices, more orders, larger orders, a new sales channel, seasonal demand, or promotions.
That is why Sales Growth should be reviewed together with metrics such as AOV, UPT, conversion, and channel performance.
Also avoid comparing periods that are not reasonably comparable. December versus January, for example, may reflect seasonality more than true operational improvement.
2. Sales Target Attainment
Sales Target Attainment compares actual sales with the target set for the period.
Formula:
Sales Target Attainment = Net Sales ÷ Sales Target × 100
Example:
- Net Sales: $120,000
- Sales Target: $115,000
$120,000 ÷ $115,000 × 100 = 104.3%.
The company exceeded its monthly target by approximately 4.3%.
A result above 100% means actual sales exceeded the target. A result below 100% means the business did not fully reach it.
If attainment is low, investigate whether the target was realistic, traffic or leads declined, conversion weakened, some stores or reps underperformed, demand changed, or stock availability affected sales.
A target is useful only when it is based on a reasonable planning process.
3. Conversion Rate or Win Rate
Conversion measures how efficiently opportunities become purchases. The correct formula depends on the sales process.
Ecommerce Conversion Rate
For ecommerce, one common approach is:
Ecommerce Conversion Rate = Purchases ÷ Sessions × 100
Suppose Northstar Goods generated:
- 30,000 ecommerce sessions;
- 900 purchases.
900 ÷ 30,000 × 100 = 3.0% ecommerce conversion rate.
The percentage tells you the final result, but not where customers were lost. That requires analyzing the stages before the purchase.
For that type of diagnosis, see our ecommerce conversion funnel guide.
B2B Win Rate
For a B2B sales process, a more useful formula may be:
Win Rate = Won Opportunities ÷ Closed Opportunities × 100
If a sales team closes 50 opportunities during a period and wins 15:
15 ÷ 50 × 100 = 30% win rate.
Do not compare conversion rates that use different denominators. Purchases ÷ sessions, customers ÷ leads, and won deals ÷ closed opportunities measure different processes.
Always document what the denominator represents.
4. Average Order Value (AOV)
Average Order Value measures how much revenue the business generates per order on average.
Average Order Value = Net Sales ÷ Number of Orders
Example:
- Net Sales: $120,000
- Orders: 2,400
$120,000 ÷ 2,400 = $50 Average Order Value.
AOV can increase because customers buy more expensive products, add complementary products, qualify for a minimum-order incentive, choose larger packages, or respond to product recommendations.
But a higher AOV is not automatically better if it depends on discounts or promotions that reduce margin.
For B2B businesses, the comparable concept is often Average Deal Size rather than Average Order Value.
5. Units per Transaction (UPT)
Units per Transaction measures how many units are sold per order on average. It is especially useful in retail.
UPT = Units Sold ÷ Orders
Example:
- Units Sold: 3,840
- Orders: 2,400
3,840 ÷ 2,400 = 1.6 units per transaction.
If UPT increases while AOV also increases, customers may be purchasing more items and spending more per order.
But if UPT rises while AOV falls, the business may be selling more low-priced products or using discounts.
UPT can help evaluate cross-selling, bundles, product recommendations, merchandising, and sales rep behavior.
6. Sales per Rep
Sales per Rep helps evaluate how sales are distributed across the commercial team.
You can analyze this KPI in two ways.
Individual Sales Rep Performance
| Sales Rep | Net Sales |
|---|---|
| Rep A | $28,000 |
| Rep B | $22,000 |
| Rep C | $18,000 |
| Rep D | $12,000 |
The difference tells you where results vary. It does not automatically tell you why.
Differences may reflect territory, customer portfolio, shift, product mix, lead quality, experience, or available inventory.
Average Sales per Rep
If $80,000 of sales were directly attributed to four active sales reps:
Average Sales per Rep = Sales Attributed to Reps ÷ Active Sales Reps
$80,000 ÷ 4 = $20,000 per rep.
Do not create a ranking and stop there. Combine Sales per Rep with target attainment, conversion or win rate, AOV or deal size, and return rate.
A rep may generate high sales but also produce unusually high returns. That is a different situation from high sales with strong post-purchase quality.
7. Sales by Channel or Product Category
Total sales can hide concentration. A business may appear to be growing while becoming increasingly dependent on one channel, one store, or one product category.
Channel contribution formula:
Channel Contribution = Channel Net Sales ÷ Total Net Sales × 100
Suppose Northstar Goods generated:
- Retail Stores: $70,000
- Ecommerce: $50,000
- Total: $120,000
Ecommerce contribution:
$50,000 ÷ $120,000 × 100 = 41.7%.
Retail contribution:
$70,000 ÷ $120,000 × 100 = 58.3%.
A channel with more sales is not automatically the best channel. Also review margin, acquisition cost, returns, fulfillment cost, customer quality, and repeat purchase behavior.
If social platforms are becoming part of your selling process, our Social Commerce guide explains how to connect content, product interest, purchasing behavior, and sales measurement.
8. Repeat Purchase Rate
Repeat Purchase Rate measures how many eligible customers buy again during a defined period.
Repeat Purchase Rate = Repeat Customers ÷ Eligible Customers × 100
Suppose 1,600 customers were eligible to make another purchase and 480 purchased again.
480 ÷ 1,600 × 100 = 30% repeat purchase rate.
This KPI requires a clear definition of an eligible customer.
A customer who bought a product designed to last several years may not reasonably be expected to buy again next month. A customer who purchases consumable products may have a very different repeat cycle.
Therefore, define the customer cohort, measurement period, and expected repurchase cycle before comparing results.
A declining Repeat Purchase Rate may be associated with product satisfaction, service problems, competitors, changes in customer needs, poor post-purchase experience, or weak retention activity.
If retention is strategically important, see our guide on how to create a loyalty program for a small business.
9. Return Rate
Return Rate shows how many sold units are returned by customers.
Return Rate = Units Returned ÷ Units Sold × 100
Example:
- Units Sold: 3,840
- Units Returned: 96
96 ÷ 3,840 × 100 = 2.5% Return Rate.
The percentage alone does not tell you the cause.
Review return reasons such as:
- incorrect product information;
- size or fit;
- quality problems;
- damage;
- wrong item shipped;
- unmet expectations;
- customer ordering errors.
Also compare returns by product, category, channel, store, or sales rep.
A business can increase sales while reducing sales quality if returns rise faster than revenue.
Understanding the behavior behind the number may require more than transactional data. Our guide to consumer buying behavior explains how to connect observable customer actions with deeper investigation.
How to Review Sales KPIs Without Overcomplicating Your Dashboard
A sales dashboard becomes less useful when it contains too many numbers without a clear decision attached to them.
A simpler review process is often more effective.
Step 1: Start With the Result
Ask:
Did sales improve, decline, or stay stable?
Review Net Sales and Sales Growth.
Step 2: Compare the Result With the Target
Check Sales Target Attainment. This tells you whether performance matched the plan.
Step 3: Identify What Changed
Look at the metrics that may explain the result:
- Orders;
- Conversion or Win Rate;
- AOV;
- UPT;
- Sales per Rep;
- Sales by Channel.
Step 4: Check Sales Quality
Review Repeat Purchase Rate, Return Rate, and margin when available.
More sales with more returns may require a different decision than more sales with stable returns.
Step 5: Investigate the Largest Meaningful Change
Do not try to improve every KPI at the same time.
Measure → identify the change → locate where it happened → investigate why → take one action → measure again.
That is the point of the KPI system.
Free Sales KPI Excel Template
To help you apply these concepts without building a spreadsheet from scratch, we created a free Sales KPI Excel Template.
The workbook is designed for basic-to-intermediate monthly sales analysis.
What the Template Calculates
- Net Sales;
- Monthly Sales Target;
- Sales Target Attainment;
- Sales Growth;
- Average Order Value;
- Units per Transaction;
- Return Rate;
- Store / Location performance;
- Sales Rep performance.
You can also enter optional dimensions such as:
- Channel;
- City;
- Store / Location;
- Category;
- Sales Rep.
The workbook includes a monthly summary, monthly sales trend, store detail, sales rep detail, and data-quality alerts.
Data-Quality Controls
The template can identify problems such as:
- required fields missing;
- invalid numeric values;
- returns higher than units sold;
- sales records with inconsistent order or unit information;
- duplicate analysis combinations;
- incomplete return data.
Records that require review are excluded from the consolidated sales KPIs until corrected.
What the Free Template Does Not Calculate
The workbook does not calculate:
- ecommerce conversion rate;
- B2B win rate;
- customer acquisition cost;
- repeat purchase rate;
- pipeline value;
- average sales cycle;
- customer lifetime value.
These KPIs require additional data that is not included in the basic workbook.
This is intentional. The template focuses on a manageable group of sales metrics that many small businesses can maintain without a CRM or complex reporting system.
Common Sales KPI Mistakes
Tracking Too Many Metrics
More metrics do not automatically produce better decisions.
Start with the KPIs connected to your actual commercial priorities.
Looking Only at Revenue
Revenue tells you the result, but not how the result was produced.
Combine sales with measures such as conversion, AOV, UPT, returns, channels, and repeat behavior.
Using Inconsistent Definitions
Do not calculate a metric differently from one month to another.
For example, if Net Sales excludes a certain type of discount in April but includes it in May, the comparison becomes less reliable.
Comparing Incompatible Periods
Seasonality, promotions, store openings, inventory shortages, and major campaigns can distort month-to-month comparisons.
Use comparable periods when possible.
Treating Benchmarks as Universal Targets
An external benchmark can provide context, but it does not automatically define what a healthy result should be for your business.
Your product, channel, customer, price, geography, and sales process matter.
Failing to Investigate the Cause
A KPI tells you where a change is visible. It does not prove why the change happened.
Use the metric to form a question, then investigate the process behind the number.
Frequently Asked Questions About Sales KPIs
What are the most important sales KPIs?
There is no single set that applies to every business. For a small retail or ecommerce business, a practical starting group may include Sales Growth, Sales Target Attainment, Conversion Rate, Average Order Value, Units per Transaction, Channel Performance, Repeat Purchase Rate, and Return Rate.
A B2B team may replace some of those with Win Rate, Average Deal Size, Pipeline Value, and Sales Cycle Length.
How many sales KPIs should a small business track?
Start with a small number that can support actual decisions.
Five useful KPIs reviewed consistently are usually more valuable than twenty metrics that nobody investigates.
Add another KPI when it answers a specific management question.
What is the difference between a sales metric and a sales KPI?
A sales metric is any measurable sales value. A sales KPI is a metric considered important enough to monitor because it is connected to a business objective or decision.
Orders are a metric. Orders may become a KPI if increasing transaction volume is a strategic priority.
How often should sales KPIs be reviewed?
The appropriate frequency depends on the metric and sales cycle.
Operational metrics may be reviewed daily or weekly, while trends, target attainment, channel performance, and retention may be more useful in monthly reviews.
Use a frequency that allows the business to react without overreacting to normal short-term variation.
What is the difference between Average Order Value and Average Deal Size?
Average Order Value is commonly used in retail and ecommerce:
Average Order Value = Net Sales ÷ Orders
Average Deal Size is commonly used in B2B selling:
Average Deal Size = Value of Won Deals ÷ Number of Won Deals
They answer similar questions but apply to different sales processes.
Can I track sales KPIs in Excel?
Yes. Excel can work well for a small business when the data volume is manageable and the definitions are consistent.
As the business grows, a CRM, ecommerce analytics platform, POS system, BI tool, or automated reporting process may become more appropriate.
Methodology and References
The terminology and formulas in this guide were reviewed against established sales and ecommerce measurement approaches.
- Google Analytics — Measure Ecommerce: ecommerce events including product views, cart activity, checkout, purchases, refunds, transaction value, and item-level data.
- Salesforce — Sales Performance: sales performance concepts including closed-won sales, win rate, average deal size, and sales-cycle measures.
The objective of this guide is not to prescribe a universal target for each KPI. It is to help you build a simple measurement system that answers three practical questions:
What changed? Where did it change? What should you investigate next?
Discover more from
Subscribe to get the latest posts sent to your email.
