A commercial dashboard is a management tool used by companies to monitor and analyze the performance of their commercial activities. It provides a concise, visual overview of key performance indicators linked to commercial and financial objectives. It enables decision-makers to make informed decisions in real time, based on up-to-date data.
But creating effective dashboards can be time-consuming and complicated. That's why, at Sidely, we believe it's best to design simple sales dashboards, so as to optimize sales reporting and improve business management.
We'll explain how in this article.
A sales dashboard is a tool for visualizing and monitoring the sales performance of a company (macro scale), or a team (micro scale). It generally presents key performance indicators (KPIs) such as new sales, sales figures or percentage of objectives achieved, providing an overall view of sales activity and the monitoring of objectives.
This "sales dashboard" takes the form of a number of easy-to-understand tables, usually accompanied by graphs. The main aim is to help decision-makers - and sometimes salespeople - make strategic decisions based on concrete data on sales activities.
The form and structure of the data may correspond to a template established by the company, which then compiles tables from different departments in a harmonized way. Sales follow-up software (CRM ) often simplifies - or even automates - the creation and completion of reporting tables.
In all cases, sales dashboards are essential tools that help align sales efforts with the company's strategic objectives, optimize individual and collective performance, and make the right decisions on the basis of concrete data. They are therefore genuine monitoring tools, which need to be updated in real time or at regular intervals to reflect the latest data.
Various people need to create sales dashboards, whether to monitor their own objectives, those of their team(s), or to report back to their +1 hierarchical level.
The most frequent users of these dashboards are sales directors, sales managers, and the salespeople themselves, whether sedentary (telemarketers) or nomadic (itinerant).
The following table shows the main objectives pursued by each of these roles.
Here are the different elements of a sales dashboard.
These are the essential metrics for tracking sales performance. These KPIs can vary according to the company, its industry, and above all the type of team involved: sedentary or itinerant salespeople, pre-sales or sales support teams, customer retention, and so on.
However, there are a number of key indicators that all companies need to keep an eye on. Here is a non-exhaustive list:
There are many key indicators to track, depending on your objectives. As we'll see below, to simplify the analysis, we recommend identifying a few key indicators and focusing on what matters most.
Data is often presented in graphical or tabular form for quick and easy understanding. Curve graphs, bar charts, pie charts and pivot tables are commonly used to illustrate trends and comparisons.
Sales dashboards generally include indicators that enable performance to be compared with the past, and thus track progress towards set objectives. This helps determine whether the company is on track to meet its sales targets.
As well as providing raw data, business dashboards often offer analysis and insights into trends and correlations between different KPIs. This helps decision-makers understand the underlying causes of performance and identify opportunities for improvement.
The salesperson or manager can provide contextual elements themselves. If you've chosen a simple dashboard format with just a few figures, your analysis can be added to the reporting email you send to your management or your recap presentation. In either case, focus on the essentials and keep it concise. Executives are used to dashboards and don't have time to read novels!
Presenting a large number of indicators on a report tends to make it more complicated to read and interpret.
To simplify performance analysis, you can divide results tracking by type of operation, selecting a few key indicators for each.
Here are a few examples of indicators to track for each type of assignment.
Let's take a look at a simple method for building your own sales performance tracking tool.
Start by focusing on the company's main objectives, such as increasing sales or the number of customers, lowering the cost of acquisition, optimizing the acquisition cycle and so on.
For example, a company wishing to shorten its sales cycle could track the following indicators:
Check the feasibility of reporting and the reliability of the data to be used. To do this, you'll need to ensure that the data is up-to-date and unbiased. Then, try to automate everything that can be automated, and if necessary, supplement with manual actions to fill in any missing information.
A dashboard must provide a clear and immediate overview. That's why it's essential to keep a summary page that your management can understand and interpret in a matter of seconds.
If required, add tabs to your table to retrieve more in-depth information, such as results by sales rep, by region, or even secondary indicators. Some companies also choose to keep a monthly history of reports, with one month per tab.
With modern CRM, it's easy enough to try out different shapes, especially when the software lets you create drag & drop dashboards!
A quality department can be set up. This can be aimed at ensuring that the CRM, or any other tool from which reporting data is extracted, is filled in correctly; in this case, the crm manager can be entrusted with this task. In other cases, it's the sales dashboard itself that can be checked for content and form: verification of formulas, accuracy of data, consistency of results, relevance of KPIs monitored...
Drawing up and sending out a dashboard must be followed by consistent action: it is advisable to hold ritual sales meetings that take into account the metrics established by the reporting. These rituals may be short-lived, but they are fundamental to sales animation, as they enable salespeople to feel involved in the strategy and to take ownership of their objectives.
To keep things simple and effective, organize your tracking tools logically and avoid confusing your rituals.
That's why it's important not to confuse the sales dashboard with two other commonly used sales tools.
For example, the sales dashboard does not replace the declaration of the forecast. The "prévi" is a ritual that enables salespeople to tell their managers what they have in thepipeline at the beginning of the month. This short ceremony enables salespeople to remain clear and transparent about their progress to date in relation to the sales objectives for the current period, and the manager to get an idea of the starting situation. At the end of the month, comparing results with forecasts enables us to analyze what has happened over the period in question, and to implement reactive actions.
Start-up brands sometimes set up a sales prospecting dashboard in Excel or Google Sheets. These situations are temporary, as companies sooner or later realize that they need a sales CRM to facilitate - and sometimes automate - the generation of sales reports, and eliminate many of the errors associated with manual data entry.
Not all sales teams are alike. Neither are all dashboards. Good reporting doesn't just mean tracking the same indicators as your neighbor: it must reflect the realities on the ground in your sector. Do you sell to supermarkets, drugstores or convenience stores? Your challenges are not the same, nor are your distribution channels. So before building your sales dashboard, take the time to identify the right indicators for your industry.
Here are some suggested sales indicators to include in your dashboard, network by network.
Here is an example of the different metrics to track for a brand present in mass distribution:
👉 The aim: guarantee your shelf presence, boost sell-in and analyze the impact of your sales actions.
If you'd like to find out more, we've written an article on the 5 KPIs you need to track in supermarkets.
Here is an example of the different metrics to track for a brand present in chr :
👉 The aim: to maximize repeat orders and field coverage.
Here is an example of the different metrics to be tracked for a brand present in out-of-home catering:
👉 The aim: to manage network performance and secure recurring volumes.
Here is an example of the different metrics to track for a brand present in parapharmacy and pharmacy networks:
👉 The aim: to guarantee product visibility and boost advice at the counter.
Insurance is not a distribution network, but an industry in its own right, with its own commercial codes. To effectively manage your sales force, you need to track indicators that are aligned with your long cycles, your conversion challenges and your loyalty objectives.
Here is an example of the different metrics an insurer can track:
👉 The aim: to structure sales performance and boost conversion.
These indicators are just a starting point. Ideally, you should customize your dashboard according to your business challenges. And if you need a simple, mobile and ready-to-use tool, we're here to help. Request your demo here !