As a sales leader, you might be wondering what to do with all that data in your CRM.
How do you use it to improve results? And how do you motivate your teams?
This is the ultimate guide to sales dashboards. You’ll learn exactly how to use sales insights to hit quotas, make your sales teams wildly productive and keep your entire organization informed.
Table of Contents:
Sales dashboards are a method of measuring sales performance from a birds-eye view. They help measure key metrics, individual team members and sales activities. Data is collected from various sources and displayed in a dashboard to generate actionable insights, fast.
Account executives and sales development reps (SDRs) love sales dashboards. They help measure activities and keep them on track of quotas.
You’ll also need sales management dashboards to keep track of how well your teams are performing. Metrics, activities and KPIs will vary depending on incentives and other factors.
As a sales manager, it’s up to you to make sure they’re empowered with the right tools and an understanding of their most important metrics. As Keren Rosenfeld, Marketing Director at SimilarTech says:
“Not all metrics are important to track and depending on your business some will be more important than the others. That being said, there are several that every startup should track.”
The rest of this guide is dedicated to figuring what these metrics are, how to collect data and the tools to build informative dashboards (we’ve even included 7 Excel sales dashboards you can grab and use to put your new skills to the test).
To build a dashboard, you need metrics.
And to know which metrics to measure, you need well-defined goals.
True-north metrics help everyone in your sales organization understand what they’re working towards.
It doesn’t matter how large your teams are, or the roles within them. Everyone must be working towards this common goal.
You can have a true-north metric for each stage of the sales cycle. This illustration from Tivoli Partners perfectly outlines customer lifecycle stages and the level of engagement required at each of them:
While this covers the entire customer experience, it’s perfect for demonstrating how different goals will align at different stages of the sales cycle.
True-north metrics are a combination of the following:
Revenue is often the most obvious choice. New business = business growth, right?
This makes sense, but it doesn’t always translate into the most actionable KPI. Other metrics may lead to a bigger impact, depending on ticket size and complexity of your offering.
These other metrics can include:
These are metrics that everyone in your sales organization must charge around.
However, they’re not to be followed at all costs. When challenges arise, you may want to shift your focus until the problem is solved.
With your true-north metric defined, it’s time to choose the KPIs your teams will be measured against. Typically, these metrics are split into two different categories:
Results-based KPIs focus on the output of sales activities.
In other words, they measure the overall performance of your sales teams based on the results they generate.
Key metrics will vary based on job title and goals. For sales managers, the top KPIs to measure usually include:
Your team should also have its own set of metrics.
These dashboards help boost team morale and lead to more productive sales meetings. Team-based sales metrics include:
Finally, account executives and SDRs must measure their own results-based metrics on a daily and weekly basis. These include:
Your chosen KPIs will depend on the structure of your sales organization. Later, we’ll talk about the benefits of providing reps access to your management numbers.
So, now you know what your sales teams are contributing to the organization as a whole.
It’s time to figure out how they’re doing it.
With activity-based metrics, you can refine your processes based on the inputs required of your teams in order to reach quota.
For example, you may see a drop in closed deals correlate with a reduced follow-up rate. With this insight in hand, you can work to increase or optimize follow-up activities to solve this issue.
Activity-based metrics include:
While these will help you improve your overall processes, do not mistake quantity for quality.
Before working on increasing or reallocating activities, qualify the leads in your pipeline. Figure out if you’re having conversations with the right people.
You now know which metrics you and your teams should be monitoring.
The next step is to collect the data you’ll visualize on your dashboards.
This requires some auditing. Your organization is likely using several platforms for various tasks. Some may be integrated together, while others sit in silos.
Before you can bring all this sales data into one place, you must first figure out where it’s being stored. This requires going up, down and across the chain:
Instead of scrambling and trying to get information from these people, run workshops to communicate what you need from each stakeholder. This may require three different sessions:
When running your initial workshops, make sure everyone understands what you’re trying to achieve.
Here’s a great way to articulate your goals:
“Our objective is to figure out where exactly our sales data is being held at all stages of the buying cycle.
This includes marketing systems, CRMs, spreadsheets and any business intelligence platforms that these feed into.
The goal is to create accurate reports to help improve sales performance and increase revenue. Without this data, we won’t know how we can do better.”
Mentioning the impact on revenue will get boardroom buy-in fairly quickly.
During the workshop, explain what the end goal is and what you need from each stakeholder. Follow this structure:
Give everyone a checklist of what to do next. Encourage them to go up and down the chain in their own teams and departments. Provide a template (spreadsheet format works best) for them to fill out and send to you. Include columns such as name, website, contact fields (e.g. first name, job role) and the systems they integrate into:
Platforms and systems to audit include:
Once you’ve mapped out the sources of all your sales data, it’s time to bring it together.
The best dashboard platforms do two things very well:
This means you don’t need to invest in another third party tool to organize your data. The best dashboard platforms take care of these integrations for you.
Before we talk about dashboard design principles, let’s check out some of your dashboard software options during this consideration phase:
Geckoboard, is one of the leading dashboard platforms. They integrate with most major data sources, and integrates with Zapier for any that are missed.
Originally designed for television displays, Geckoboard is perfect for keeping teams on the same page. Notable features include:
Geckoboard starts at $25 /MO. A 30 day free trial is available.
UnifiedVU’s product focuses on bringing data from several isolated sources together. This is perfect for collecting several forms of customer data into one place:
As you can see, you get a complete view of your organization’s interactions with each lead, customer and opportunity.
UnifiedVU starts at $15 a month.
Plecto’s visual dashboard offering is geared towards managing and motivating team members. Use their platform to focus on individual KPI categories.
On top of standard dashboard features, Plecto also comes with some cool gamification features. Here’s how it looks in practice:
As you can see, you can track everyone’s progress across your sales organization and the teams within it. Use this feature to spark some healthy competition, and reward the teams who hit quota first.
Plecto starts at $17 (per user) a month. A 14 day free trial is available.
Once you’ve evaluated which tool to use for your sales dashboards, it’s time to design them.
You don’t need any design skills in order to do this. Which is why dashboard platforms are so appealing.
When creating your sales dashboards, aim for clarity. They should convey insights in an instant without the need to hunt for them.
Clear, understandable dashboards have these attributes in common:
With these principles in mind, let’s look at some dashboard design principles you should follow when creating your own.
Each dashboard will take your salespeople down a path. And those paths will lead to habits.
Therefore, it’s important to maintain a level of consistency in how your dashboards are presented and accessed:
Some dashboard platforms provide little flexibility on these design elements, which will make consistency easier. With more flexibility comes a bigger risk of miscommunication, so be wary when designing things from scratch.
I’m not suggesting you start throwing out all your belongings. But I am endorsing you to be selective with your choice of dashboard metrics.
As a rule of thumb, include a maximum of 6 to 10 data points. In the SaaS dashboard below, there are only ten top-level business metrics being used:
It can be tempting to throw all of your numbers into one place. But this can lead to messy dashboards that are difficult to understand. Strive for clarity.
Many dashboard platforms allow you to include filters. For example, instead of showing sales figures for every region, include a filter that allows you to output the data for those specific areas.
This approach saves on visual real estate, while creating rich and interactive dashboards.
When creating a data-driven layout, it’s important to use some kind of logic when grouping metrics together.
When creating sales dashboards, I recommend the following structure:
This model looks like an upside down pyramid: business objectives at the top, operational and granular metrics at the bottom.
Whatever model you use, ensure it’s consistent across all of your dashboards.
As important as the way you lay out your insights is the method of visualizing them.
What do I mean by this?
A pie chart may work for one metric, while a pivot table will visualize another in a clearer manner.
Let’s run through the most common data visualizations that you’ll use when designing your dashboards:
1. Line charts: A popular choice when visualizing trends and comparing them to other metrics and filters (e.g. timeframes).
2. Pie charts: Quickly communicate the “share” that each value makes up of a specific category or metric (e.g. how many opportunities each sales rep generated from the total).
3. Bar charts: Many data-driven experts believe pie charts to be difficult to visualize comparative data, and suggest bar charts instead. They work in a similar manner, but are more linear:
4. Pivot table: While they’re not always nice to look at, pivot tables are perfect when laying out exact numbers across categories and values.
5. Indicators: Provide an instant snapshot of how well a specific metric is performing e.g. number of deals vs. monthly quota. Here’s an example of a gauge indicator:
You now know exactly how to build sales dashboards for you and your teams.
If you’re looking for some inspiration, I’ve collected 4 dashboards you can swipe and apply to your own organization today.
No matter which metrics you’re measuring, you should be able to create these using your chosen sales dashboard platform:
As a sales manager, it’s your job to guide your team. But that’s only possible if you know how well they’re performing:
In the example above, you can see how well your reps are performing, the amount of revenue generated and how many deals are sitting within each stage of the pipeline.
Use this dashboard to focus on the right activities and motivate your team.
Along with the team performance, you should have a dashboard to provide you with a daily snapshot of results-based numbers:
As you can see, this dashboard from InsightSquared gives you an accurate view of progress, as well as how close you are to reaching your goals.
Again, you can use this as part of your team meetings to help motivate teams. Use this to show them the impact they’re making.
Your sales reps should have their own daily view of how they’re performing. As discussed earlier, they should be monitoring both results-oriented and activity-based metrics:
Here, reps have a complete view of the number of deals they’ve generated as well as the total value.
But the main difference to sales manager dashboards is the primary focus on sales activities. This is what drives results for reps on a daily basis, which is what they focus on.
Finally, the boardroom needs a complete view on how the sales organization is performing and how you’re contributing to business results.
In this example, you can share your monthly and quarterly performance with your CEO, as well as comparisons against forecasts:
The dashboard examples above are designed to provide the right KPIs to the people that need it the most.
Your reps need access to activity-based metrics to help them gauge their progress. While directors need to see contribution to the bottom line.
This comes back down to necessity. Focus only on the metrics that make an impact to each group.
We’ve covered some sophisticated solutions to sales dashboards in this guide.
But what if you’re not ready to invest in dashboard software just yet?
We’ve got you covered.
First, let’s talk about Excel. Spreadsheets can be a great starting point to help small business owners track sales -- from managing and modeling data to visualizing data into graphs:
For a “microsales” operation, this can be a quick and easy solution to your CRM (as long as you’re abiding by data protection laws in your region). However, the amount of data you manage can quickly spiral out of control.
If you’re serious about growing your team and your business — implement a CRM and upload your data as soon as possible.
The longer you leave it, the harder it is to get that data into your chosen CRM platform.
With that in mind, here are 7 free Excel dashboard templates you can use to track and analyze your sales:
Unless you plan to set a low growth ceiling for your business, you’ll eventually need a CRM.
Do you expect to have the same number of sales personnel two or three years from now? If not, then a smart CRM will simplify your life and make it easier to achieve your sales goals.
An Excel sales dashboard is a good start, but if you’re serious about selling, you need to level-up.
So, use a good sales template for now. But be sure to transition to a CRM before you reach the tipping point.
Remember, the smaller and simpler your dataset is, the smoother the transition.
Managing and motivating your sales team is one of the biggest benefits of having a sales dashboard.
But you’re probably asking; “how can I use this data to effectively guide my team to a higher level of performance?”
Here, I’ll outline 5 ways you can use your dashboards to help your reps get better results and progress their careers.
We’ve talked a lot about using dashboards to identify leaky holes in sales processes.
But what about the things that are going well?
Rahul Alim from Custom Creatives says numbers should do the talking:
“I like to show my team how close or far we are from weekly, monthly, and quarterly goals. If we are behind, we do a big push. If we are ahead, we want to crush it and get way far ahead. The motivation lies in the outcome of what we do.”
Check the overall performance of your teams. Look for things to celebrate, such as:
This insight is all available within your performance dashboards. Look for areas that can be celebrated, both for individuals and as a team.
Earlier, I shared how gamification can create a competitive spirit among sales teams.
Take this one step further and create incentivized sales competitions.
Here are a few creative ideas to get you started:
Come up with your own ideas by tapping into psychological triggers. Try and create competitive scenarios that encourage teamwork, not cutthroat backstabbing.
Not all goals should be set in stone.
Sure, quota is there for a reason. But challenges will always come up in different shapes and sizes.
Dashboards can indicate points of friction, leaky holes in the pipeline and areas that need improvement.
When these problems arise, it’s important to address them.
Because fixing them will help you reach quota.
Look at it this way: your revenue target is the goal, sales activities are the path and those challenges are the obstacle.
For example, response rates have started significantly dropping from your sales emails. Here’s how I would tackle this challenge:
Look at these as experiments. What will happen to outcome x if we do activity a instead of activity b? Apply any successful experiments to your future processes.
It’s important to get your sales reps on board with every decision you make. Sure, you can explain your reasoning to make a case, and that may work…
...but nothing beats backing it up with data.
“Not everyone will always agree with you, but they’re much more likely to respect the decision if they understand the thought process behind it.”
Back your decisions up with data and demonstrate that your intentions are in the right place. This shows you’re using objective facts to drive your decision making, not gut feeling or a sense of entitlement.
This tip is counter-intuitive to the ‘share only what is necessary’ rule.
But there are benefits in sharing your high-level “management” numbers with your reps.
Some sales reps are high performers because they’re always looking to improve. This often leads to experimentation and trying out new things
By sharing high-level metrics, they can see things from a 360 perspective. Allow them to use these numbers to come up with ideas on how they can make their own jobs easier and more effective.
Of course, this requires some humility. Some sales managers may scoff at the idea of letting reps “tell them how to do their job…”
Leave your ego at the door and focus on serving your reps. Let them make a dent in the organization and further their career. That’s what great leaders do.
You now have a complete toolkit to create sales dashboards that motivate your team and get results.
When you’re done following this process, you should have clear processes in place that help you refine your activities and generate better results.
Now, I’d love to hear from you. How are you currently measuring team performance? How do you plan on using what you’ve learned here today? Share your thoughts in the comments below.If you haven’t already, be sure to download and use Pipedrive’s free Excel sales dashboard.
Start or continue the conversation with like-minded sales and marketing professionals on our Community.Join our Community
How to calculate incremental sales and what it means for your business
Marketing is all about supporting and improving sales outcomes. By measuring incremental sales, marketing teams, sales managers and business owners can better understand the success of their promotional activity and direct future investment accordingly.
How to calculate sales volume variance and why it’s important
How can you calculate sales volume variance and what does it mean to your business? In this guide we explain what factors can impact sales volume variance and the formulae you need to measure it.
A Guide to Email Marketing Regulations: Consent and GDPR
If you’re an email marketer, you need to get verifiable consent from your email users. In the EU (or marketing to the EU), you need to follow GDPR. Read our guide to make sure you know the rules and regulations.