Commercial dashboard: the owner's sales KPIs

Quick answer. A useful commercial dashboard tracks a few key indicators: revenue and its growth, margin by product or client, the conversion rate, the average basket, the sales cycle, the pipeline and the order book. The point is not to pile up figures, but to track the right ones, compared over time and to budget, in order to decide quickly.

Steering sales by feel is driving while looking in the mirror: you notice the drop once it has already happened. Conversely, an overloaded dashboard is as useless as no tracking, because it buries the signal under noise. A good commercial dashboard does not chase completeness: it selects a few indicators that truly speak of performance and, above all, of its levers. The distinction is decisive: a performance indicator looks at the past (revenue booked), a leverage indicator announces the future (the pipeline, the conversion rate). An owner who tracks only the first always steers too late.

The public bodies that support business owners, such as Bpifrance Création in its encyclopaedia of management dashboards, make the same point: a dashboard is worth only its regularity and the decision it triggers. Here is the grid we use in steering engagements, and how to read it.

The commercial dashboard turns sales activity into steering information. It answers simple but decisive questions: are sales growing, on which products, at what margin, with what success rate of commercial actions, and with what visibility on the months ahead.

Without these answers, the owner reacts after the fact, when revenue has already dropped and only painful levers remain: discounts, frozen hiring, strained cash. With a good dashboard, they see the slowdown in the pipeline and the conversion rate before it reaches revenue, which leaves time to act on prospecting or the offer.

The dashboard is therefore not there to measure everything, but to measure what drives commercial performance and what you can act on. An indicator you cannot link to a concrete action has no place on the page.

A few indicators suffice to cover the essentials of commercial performance. The table below groups them with the management question each one answers and the associated warning signal.

Two indicators deserve particular attention. Margin first: revenue that grows with a deteriorating margin is a warning sign, to link to the cost price and the contribution margin, because growth only creates value if it turns into profit. The pipeline next: it is the only truly predictive indicator. If it is shorter than your sales cycle, the dip is already programmed, even if the month's revenue still looks good.

A common mistake is to stack indicators without classifying them. Yet each KPI belongs to one of three families, and a balanced dashboard contains all three.

• Performance indicators measure the result achieved: revenue, margin, average basket. They are reliable but late.
• Leverage indicators measure the effort that will produce the result: number of quotes issued, conversion rate, number of meetings. You can act on them today.
• Predictive indicators measure what is already committed: weighted pipeline, order book, sales cycle. They give visibility.

A dashboard that contains only performance indicators informs you too late. One that mixes the three families gives you time to correct: you see the effort weaken (leverage), then the pipeline empty (prediction), well before revenue drops (performance).

An isolated indicator says nothing: it is the comparison that gives it meaning. A raw monthly revenue figure answers no question. The same figure compared with the previous month, the same month last year and the budget becomes a decision tool.

Three references should be set systematically. The comparison with the previous period reveals short-term momentum. The comparison with year N-1 neutralises seasonality, essential in cyclical activities. The comparison with the budget measures the gap to the target you set yourself. The conversion rate read over twelve rolling months shows whether commercial efficiency is improving or declining, where a one-off value says nothing.

These commercial data also feed governance reporting: they supply the board pack and, more broadly, the dialogue with partners or financiers about the company's trajectory.

Our view: a dashboard fits on one page and triggers an action#

In the steering engagements we run, the commercial dashboards that genuinely serve have three things in common. They fit on one page and read in a few minutes. They always place margin next to revenue, to bar the trap of unprofitable growth. And they contain at least one predictive indicator, pipeline or order book, without which you steer by looking behind.

Our advice fits in one sentence: five to eight truly actionable indicators, compared over time and to budget, commented in two lines. The comment matters as much as the figure, because it is what turns a statement into a decision. A stable dashboard, tracked monthly and discussed, is worth far more than a rich but episodic report. It is regularity, more than completeness, that makes the value of commercial steering. And that is exactly where the contribution of a management-minded accountant lies: not in producing figures, but in reading them and in the arbitrage they call for.

An owner shows us a year of strong growth, proud of revenue up by around 20%. He tracked only that line. By rebuilding a commercial dashboard with margin by product family, the picture reverses: the growth rested almost entirely on a low-margin entry-level range, sold with discounts to win volume, while the profitable products stagnated.

Revenue was rising, but operating profit was falling. The average basket was shrinking, the sales cycle was lengthening on the neglected key accounts, and the order book was concentrating on the least profitable products. Tracking margin next to revenue made it possible to redirect the commercial effort towards value-creating products, to revise the discount policy and to rebuild a balanced pipeline. The recovered growth was slower in appearance, but this time it generated profit. This is exactly the kind of arbitrage a well-built dashboard makes visible before cash flow recalls it the hard way.

In practice: building your commercial dashboard#

Here are the operational reflexes to build a dashboard that serves, rather than a document that sleeps.

• Start from the decision, not the data: list the three or four commercial decisions you make each month, then choose the indicators that inform them.
• Mix the three families: at least one performance indicator, one leverage indicator and one predictive indicator.
• Set the three references systematically: previous period, N-1, budget. Without them, the indicator decides nothing.
• Segment margin by product or client, never in aggregate: it is segmentation that reveals where value is created.
• Draw the data from a single, reliable source (CRM, invoicing, accounting) to avoid figures that contradict each other from one meeting to the next.
• Comment in two lines each month: what the figure shows, and the action decided. A dashboard with no decision is a dead dashboard.

A few pitfalls keep coming up in commercial dashboards, especially when they are built in a hurry.

• Confusing revenue and margin: unprofitable growth can destroy value while flattering the dashboard. Margin must always appear next to revenue.
• Having no predictive indicator: without a pipeline or order book, you discover the slowdown once it is already in revenue.
• Stacking indicators: beyond eight, the important signals drown and no one reads the document. Selection takes precedence over completeness.
• Measuring without comparing: an indicator with no history or budget allows no decision.
• Counting a sale too early: putting unqualified deals in the pipeline inflates a visibility that does not exist. Weight by realistic probability.
• Forgetting the payment lead time: strong commercial revenue that converts poorly into collections creates growth that consumes cash instead of producing it.

To make these analyses reliable and connect commercial tracking to the company's real profitability and tax position, it helps to rely on support in tax and management, and, in groups structured as a holding company, to consolidate the commercial reading of the subsidiaries so the whole is steered with a consistent grid.