# Sales Dashboard Metrics: What to Track, How to Calculate It and How to Build a Sales Report People Trust

> Which sales dashboard metrics matter? See target, pipeline, customer and cash metrics with formulas and data sources, then build the report in 7 steps.

Source: https://digitalbridge.com.tr/en/blog/sales-dashboard-metrics.html
Publisher: Digital Bridge Teknoloji (https://digitalbridge.com.tr)
Topic: Data & Analytics
Published: 2026-10-20 · Updated: 2026-10-22

Sales dashboard metrics are the handful of figures that tell a sales team, every week, where it stands against target, whether there is enough pipeline to hit the next one, which customers are growing or drifting away, and whether sales are turning into cash. To build one, decide who reads it and for which decision, fix 8–12 metrics with written formulas, pull the data automatically from CRM and ERP, and make the report the agenda of the weekly sales meeting.

## What actually happens in the Monday sales meeting

The sales manager brings an ERP invoice export, each rep their own spreadsheet, finance the receivables ledger. The first half hour goes on agreeing what "sales this month" means: one figure includes VAT, another hasn't netted off returns, a third converts foreign-currency invoices at the invoice-date rate rather than today's. By the time the numbers are settled, there is no time left for which deals are stuck and how the month will close.

The problem is rarely a lack of charts. Sales data lives in at least three places: opportunities and quotes in the [CRM](https://digitalbridge.com.tr/en/software-solutions/crm-customer-relationship-management.html), orders and invoices in the ERP, and collections in accounting. Until those sources are joined on a shared customer code and shared definitions, every report carries the interpretation of whoever built it.

This article deals specifically with the sales team's report, not with executive dashboards in general. We cover general panel design — one screen, drill-down, threshold colours — in our guide to [building a management dashboard](https://digitalbridge.com.tr/en/blog/bi-dashboard-kpis.html), and how to define pipeline stages in our [CRM and sales pipeline guide](https://digitalbridge.com.tr/en/blog/crm-sales-pipeline-guide.html).

## The cost of a sales report nobody trusts

In Turkey, where we work, TurkStat's [ICT Usage Survey in Enterprises 2025](https://veriportali.tuik.gov.tr/tr/press/54012) found that only 12.0% of enterprises with 10 or more employees used CRM software and just 6.5% used business intelligence (BI) software. Among firms with 10–49 employees the figures drop to 9.9% and 4.9%, which suggests that in most small companies the sales report is probably still stitched together by hand.

The biggest cost of a hand-built report is doubt:

> In a survey of 565 data and analytics professionals by Drexel University's LeBow College of Business and Precisely, 76% named data-driven decision-making as a top goal of their data programmes, yet 67% said they don't fully trust the data their organisation uses. ([Drexel LeBow & Precisely, 2025 Outlook: Data Integrity Trends and Insights](https://www.lebow.drexel.edu/sites/default/files/2024-09/drexel-lebow-precisel-data-integrity-trends-insights-2025-outlook.pdf))

Poor data also has a direct price. Data quality expert Thomas C. Redman estimates the cost of bad data at 15% to 25% of revenue for most companies ([MIT Sloan Management Review, "Seizing Opportunity in Data Quality", 2017](https://sloanreview.mit.edu/article/seizing-opportunity-in-data-quality/)). In sales, that estimate shows up as duplicate customer records that split a customer's revenue in two, stale pipeline stages that inflate the forecast, and overdue invoices noticed too late.

## Which sales dashboard metrics belong on the screen?

A good sales dashboard answers four questions: where you stand against target, whether there is enough pipeline for the next period, which customers are growing and which are quietly leaving, and whether revenue is actually arriving as cash. The table sets out the core metrics, their formulas and data sources.

| Metric | Calculation | Question it answers | Data source | Refresh |
|---|---|---|---|---|
| Net sales vs target | (Invoiced amount − returns − discounts, excl. VAT) ÷ period target | How far along are we? | ERP, e-invoice records | Daily |
| Gross margin | (Net sales − cost of goods sold) ÷ net sales | Is the revenue profitable? | ERP | Weekly |
| Pipeline value | Open opportunities, weighted by stage probability | How much work lies ahead? | CRM | Weekly |
| Pipeline coverage ratio | Unweighted total of open deals expected to close in the period ÷ remaining target | Is there enough pipeline to hit target? | CRM + target sheet | Weekly |
| Win rate | Deals won ÷ deals closed (won + lost) | How many quotes become orders? | CRM | Monthly |
| Sales cycle length | Average days from opportunity creation to close-won | How long does a sale take? | CRM | Monthly |
| Average deal size | Value won ÷ number of deals won | What size of deal do we win? | CRM | Monthly |
| Customer concentration | Top 10 customers' share of revenue | Are we dependent on a few accounts? | ERP | Monthly |
| Overdue receivables | Overdue open balance, split by days past due | Are sales turning into cash? | Accounting / ERP | Weekly |

Don't look for a universal "right" pipeline coverage ratio. The coverage you need follows from your own win rate: if you win roughly a quarter of the value you close, you need open pipeline worth about four times the remaining target. For the fields worth capturing at the quotation stage, see our guide to [sales quote tracking](https://digitalbridge.com.tr/en/blog/sales-quote-tracking.html).

Not all nine metrics need to share one screen. Deciding which become company-level KPIs and which stay as supporting metrics for the sales team is a separate exercise, described in [how to set KPIs](https://digitalbridge.com.tr/en/blog/how-to-set-kpis.html).

## Building a sales report in seven steps

1. **Name the reader and the decision.** The managing director wants the month-end forecast, the sales manager wants stalled deals, and each rep wants their own list. For every view, write one sentence answering "what will the person reading this decide?"
2. **Give every metric a definition card.** Is revenue net of VAT? On which date are returns deducted? Which exchange rate converts foreign-currency invoices? At what stage is a deal "won"? The formula, source field, owner and threshold should all be written down.
3. **Join the shared keys.** A customer in the CRM must match the ERP account under the same code, and product groups and sales regions should come from a single master list. Customer-level reporting is unreliable until duplicate customer records are cleaned up.
4. **Automate the data feed.** Set up nightly or hourly transfers from the source systems. Combining ERP and CRM in a [data warehouse](https://digitalbridge.com.tr/en/data-analytics/data-warehouse.html) means past periods are recalculated under the same rules too.
5. **Build the table first, the charts second.** Run the new figures alongside the old spreadsheet for a period or two and check they agree. The panel doesn't go live until every difference is explained.
6. **Separate views by audience.** Produce the executive summary, team view and rep view from one data model; reps see only their own customers.
7. **Tie the report to the meeting.** Run the weekly sales meeting from the dashboard, and assign an owner and an action to every metric that breaches its threshold. Any metric nobody uses for a quarter comes off the screen.

### Three views for three audiences

| View | Headline metrics | Time horizon | Level of detail |
|---|---|---|---|
| Managing director | Net sales vs target, gross margin, period-end forecast, overdue receivables | Month and quarter | Region and product group |
| Sales manager | Pipeline coverage, win rate, stalled deals, target by rep | Week and month | Rep and deal |
| Sales rep | Personal target, open quotes, overdue follow-ups, sales by customer | Day and week | Customer and quote |

## Common mistakes in sales reporting

**Tracking revenue alone.** Revenue is a lagging indicator; once the month has closed there is nothing left to change. Without leading indicators such as pipeline coverage and win rate, the report only describes the past.

**Never auditing CRM stages.** Deals sitting in "in discussion" for months inflate the pipeline and distort the forecast. Even a simple rule that flags any deal without activity for a set period makes the forecast more realistic; we cover cleaning up duplicates in our article on [data quality and duplicate records](https://digitalbridge.com.tr/en/blog/data-quality-duplicates.html).

**Missing the customers you are losing.** Total revenue can grow while a few long-standing customers quietly order less. Tracking order frequency by customer surfaces that decline early, as explained in our guide to [B2B customer churn analysis](https://digitalbridge.com.tr/en/blog/customer-churn-analysis-b2b.html). Satisfaction that order data cannot show is better tracked with a [Net Promoter Score survey](https://digitalbridge.com.tr/en/blog/net-promoter-score-nps-guide.html).

**Over-engineering for real time.** For most sales reporting, a daily refresh is enough. Making every metric update by the second raises costs without improving decisions; we discuss which data genuinely needs to be live in [real-time reporting](https://digitalbridge.com.tr/en/blog/real-time-reporting.html).

## How we build sales dashboards at Digital Bridge

We start with an inventory of the reports you already produce, not with chart design:

- **Discovery and requirements.** Together with sales, finance and management we gather every sales report currently in circulation and identify where the same metric is calculated differently. The output is a definition card for each metric and a list showing which system feeds it.
- **Source integration.** We link invoice, returns and customer account data from your [ERP system](https://digitalbridge.com.tr/en/software-solutions/erp-enterprise-resource-planning.html) to opportunity and quote data in the CRM through a shared customer code. Where a system has no ready-made connector, we build an [API integration](https://digitalbridge.com.tr/en/software-solutions/api-integration.html). For companies that invoice through Turkey's state e-invoicing system (e-Fatura), those records can also be used to verify net sales.
- **Pilot.** We first build the sales panel for a single team or product group and compare it with the old report for a period or two. Once the differences are closed, we open the views to the whole team.
- **Roll-out and permissions.** On a [BI dashboard](https://digitalbridge.com.tr/en/data-analytics/bi-dashboard.html) we generate executive, manager and rep views from the same data model, and make sure each user sees only the regions and customers they are authorised for.

If you don't yet have a CRM, we treat the dashboard project and the set-up of opportunity and quote records as one piece of work, because pipeline metrics can only be calculated where deals are recorded. We set out a staged migration plan in our guide to [moving from Excel reports to BI](https://digitalbridge.com.tr/en/blog/from-excel-reports-to-bi.html). Once your sales history is in good shape, the same data also makes a solid foundation for [AI demand forecasting](https://digitalbridge.com.tr/en/blog/ai-demand-forecasting.html).

If part of your online sales runs on our own e-commerce platform, [SmartSales](https://digitalbridge.com.tr/en/smart360/smartsales.html), the store's Sales, Orders, Products, Customers and Channels reports can be exported and joined to the same data model. Because SmartSales calculates profitability from net-of-VAT sales minus purchase price, shipping cost, marketplace commission and payment provider fees, online channel profitability arrives as a ready-made input. If [SmartOperator](https://digitalbridge.com.tr/en/smart360/smartoperator.html) runs on your website, its count of conversations that reached the checkout page and its conversion funnel show how many chats got as far as the purchase step.

## Next step

Try a simple exercise this week: write down, on a single page, which file and which definition each figure in your last sales meeting came from. If you find two different numbers for the same metric, a definition card is your first job. To review your sales report with us and scope a pilot, [get in touch](https://digitalbridge.com.tr/en/contact.html). You will find more guides on reporting and data in our [Data & Analytics](https://digitalbridge.com.tr/en/blog/topic/veri.html) section.

## Frequently Asked Questions

### What is the difference between a sales report and a sales dashboard?

A sales report summarises a period's results, usually as a fixed table that is often compiled by hand. A sales dashboard pulls the same metrics automatically from source systems, keeps them current and lets users drill down and filter by person or region. A good dashboard removes the monthly compilation work, but the metric definitions must be identical in both.

### How many metrics should a sales dashboard have?

For an executive view, six to ten metrics are usually enough; more than that makes the screen hard to read. Sales manager and rep views can carry more detailed lists. What matters is that each metric is tied to a decision and has a written formula. Any metric that has not informed a single decision in a quarter should be removed.

### How is the pipeline coverage ratio calculated?

Divide the total unweighted value of open opportunities expected to close within the period by the sales target still to be achieved. The ratio you need varies between companies and follows from your own win rate. If you win roughly a quarter of the value you close, for example, you need open pipeline worth about four times the remaining target to have a realistic chance of reaching it.

### Can you build a sales dashboard without a CRM?

Outcome metrics such as revenue, margin, customer concentration and receivables can be built from ERP and accounting data alone. Leading indicators such as pipeline value, win rate and sales cycle length, however, need opportunities and quotes recorded with dates. That record can live in a CRM or a simple quote tracking system, provided it is kept up to date consistently.

### How often should a sales report be updated?

For most businesses, a daily refresh is enough for net sales and open orders. Pipeline and receivables figures should be current before each weekly sales meeting. Slower-moving indicators such as win rate, sales cycle length and customer concentration are more meaningful when reviewed monthly; checking them too often mostly generates false alarms.

### Do sales dashboard metrics differ by industry?

The core metrics are much the same across industries; what changes is their weighting and definitions. In project and quote-led selling, win rate and sales cycle length matter most. Where sales go through dealers or distributors, revenue and order frequency by dealer take centre stage, while manufacturers with repeat orders tend to watch customer concentration and overdue receivables more closely. Write your definition cards around your own sales model.

### What drives the cost of building a sales dashboard?

The main cost factors are the number of source systems to connect, whether those systems have ready-made connectors, how much data cleansing is needed, the number of views and users, and the complexity of the permission rules. Duplicate customer records and inconsistent product codes often take more effort than chart design, which is why starting with a pilot for a single team keeps the cost predictable.