Sales analytics for small and medium businesses: which metrics to check every week, where to get the data, how to find the cause when sales drop, and how to review the numbers in half an hour.
KelyanMedia editorial team · Updated November 13, 2026

You do not need dozens of reports to manage sales. A few metrics are enough, as long as they are calculated the same way every week and compared with previous periods.
Below is a minimum set of numbers and a routine for turning them into decisions.
In short: what you need to know
- MinimumRevenue, number of sales, average order value, lead-to-sale conversion and margin.
- The main ruleCompare not with expectations but with last week and the same period last year.
- ResultEvery review ends with one or two actions for the next week.
Which metrics to check every week
Revenue shows the result, and the other metrics explain what it is made of.
| Indicator | How to measure | What to do if it drops |
|---|---|---|
| Leads | All inquiries for the period: calls, messages, forms | Check ads and other acquisition channels |
| Lead-to-sale conversion | Sales divided by leads | Listen to calls, check response speed and prices |
| Average order value | Revenue divided by the number of sales | Check upsells, discounts, product range |
| Revenue | Total of all sales for the period | Find which of the three metrics pulled it down |
| Margin | Revenue minus cost of goods, as an amount and as a percentage | Check purchase prices and discounts |
← Swipe to scroll the table →
Revenue equals leads multiplied by conversion and average order value. So any change in revenue can be broken down into these three parts to see exactly where the problem is.
Where to get the data and how to build the report
The report only works if data gets into it the same way and on time.
- Decide where every lead is recorded: a CRM, a bot or at least a shared spreadsheet. Leads in managers' personal messengers do not make it into the report.
- Agree on what counts as a sale: payment, a signed contract or shipment.
- Record the lead source: ads, website, social media, referral.
- Build a weekly table: weeks in rows, metrics from the table above in columns.
- Add columns showing the change from the previous week and from the same period last year, if you have the data.
A spreadsheet is enough to start with. You need a CRM when the number of leads grows and managers can no longer log them by hand. Profit and expenses are easier to track in a separate report: we explain how to build one in our article on business income and expenses.
If sales drop: where to look for the cause
First find which metric changed, and only then look for a solution.
| What changed | Common causes | What to check |
|---|---|---|
| Fewer leads | Ads stopped, seasonality, a broken form on the website | Ad accounts, sending a test lead, last year |
| Leads are coming in, but sales are down | Slow responses, a new manager, prices above the market | Response time, call recordings, competitor prices |
| Same number of sales, lower revenue | Discounts, customers buy cheaper products | Sales mix by product |
| Same revenue, less profit | Cost of goods or advertising spend went up | Purchase prices, cost per lead |
← Swipe to scroll the table →
A hypothetical example: the number of leads stayed the same, but sales fell by a third. So the problem is not the ads but how leads are handled, and raising the ad budget makes no sense.
A 30-minute weekly sales review
A short regular review is more useful than a big quarterly report.
- 5 minutes: compare the numbers with last week and last year;
- 10 minutes: find the metric that changed the most and its cause using the table above;
- 10 minutes: discuss with your manager or marketer what to change;
- 5 minutes: write down one or two actions for the week and who is responsible.
A week later, start the review by checking whether the actions were done and whether the numbers changed.
Learn about full-service digital marketing →Important
The set of metrics depends on the type of business: retail adds stock levels and turnover, services add staff utilization. This material reflects practice as of the update date.
FAQ
Do you need a CRM for sales analytics?
How often should you check the metrics?
What should you compare against if your business is new?
Next steps
You need more leads: see full-service digital marketing.
Leads get lost between channels: learn about business optimization and CRM.
Still have questions: call +998 33 339 33 34.
Discuss sales growth →
