The Perfect Sales Dashboard Should Have These 12 Sales Metrics
Determine What’s Important
Some sales require phone calls others need in-person meetings. Closing a $1 million deal takes far more nurturing than smaller accounts. With that in mind, a sales manager may see “Won Deals Leader Board” on their dashboard, but perhaps “Team Metrics Based on Total Pipeline” is more relevant.
To learn what information should be in your dashboard, consider these questions:
- Which data points show up most often in your reports?
- In sales team meetings and one-on-one salesperson reviews, are there metrics that are regularly reviewed or are seen as more important than others?
- What have you determined as your Key Performance Indicators (KPIs)?
- Do you have multiple sales teams, such as inside sales and field sales?
As you do your research, ensure that your dashboard includes actionable metrics. It’s likely you already know what sales metrics need to be included in your dashboard, but be sure to take your reports into consideration. Your dashboard will most likely change over time, so make sure your platform gives you the option to adjust as necessary without getting IT involved.
Build Your Dashboard
Vehicles don’t have the speedometer hidden in a corner of the dashboard. Nor is the gas gauge just a simple light that comes on only when you’re on empty. The layout of your sales dashboard should be just as well planned.
Ensure that you can quickly make changes to how metrics appear on your dashboard so that the most important details stay above the fold and are most visible. This goes for both your desktop and mobile dashboards. You need to be in control, and if that’s not easily managed within your sales platform, take the time to learn how to manipulate the way that data is displayed.
- Who needs to see this information?
- What purpose does it serve?
- How often will it be looked at?
- How much data should you include?
- Over what time period?
- Displayed on which type of chart to be most effective?
Charts can include dials, leaderboards, bar graphs, historical trend graphs, pie charts, funnels, plotted points, and more. Your goal is to display relevant information in a way that’s quickly understood—and, using your CRM, making sure your dashboard is always up-to-the-minute accurate (which is especially important when a salesperson is outside the office and views their mobile dashboard).
The Metrics You Need to Keep an Eye On
Dashboards are most effective when they give you a big-picture overview while ensuring you know the details, too. Salespeople and sales managers have to juggle a number of facets in the big picture, including:
- Individual salesperson performance
- Pipeline performance
- Your company’s competition
- Product performance
With that in mind (and after burying the lede), the perfect sales dashboard should have some combination of these metrics.
1. Leads by Source
Gain an understanding of where your customers are coming from (e.g., conferences, website demo sign-ups, referrals). This data helps you classify which leads to contact first and focus on the most profitable sources. It also allows you to see if you need to diversify your lead sources so you’re not wholly reliant on one or two resources.
See what stage each open opportunity is in and how close they are to finalizing. Use this information to tailor your conversations based on where leads are in the purchase process, as well as know when to teach versus pitch.
3. Sales Cycle
The average duration or time (typically in days) it takes your team to win a deal. If you take this average and compare it to the age of each opportunity, you can see if your current opportunities are moving through the funnel as expected.
4. Closed Opportunities
Quickly see how much revenue your sales have generated. This metric is especially important if your sales quota is based on revenue, and it can help you keep an eye on commission goals.
5. New Business vs. Upsell
According to Marketing Metrics, it’s about 50 percent easier to sell to existing customers than it is to sell to new customers. In fact, some companies “use upsells to drive a much higher percentage of their new Average Contract Value (ACV) . . . In fact, companies in the $40–75MM revenue range attribute twice as much new revenue to upsells as the median company.”
As a salesperson, you need to balance new business with upsells. This metric keeps you on track.
6. Win/Loss Rate
One of your most basic metrics as a salesperson, this number is the percent of opportunities proposed or quoted that you won. Lower-than-average win rates indicate the need for research: Are leads getting stuck in your funnel at the same place? Perhaps your pitch needs to be adjusted for when you speak to lukewarm. Find out what an acceptable percentage is in your industry and work to hit it on a consistent basis.
7. Product Gaps
This metric helps you see how your offerings are actually performing in sales versus how they were predicted (or idealized) to sell. When there’s a gap, more product research needs to be done to find out why—and you, as a salesperson, can lead the way.
8. Open Opportunities
These opportunities are your bread and butter and tie into your win/loss rate. Use this to track your leads, delegate when you have too many, and grow your pipeline when you want to increase the number of open opportunities you have.
9. Open Activities (calls, demos, visits)
Consider these your to-do list. Your open activities are the tasks you need to take care of to stay proactive in your sales efforts. It’s good to have open activities, but if you have too many, check your schedule to see where your time could be used more effectively.
10. Open Cases
Cases are generally opened when a customer initiates contact. These and open activities should be treated as time-sensitive. Take care to close these cases quickly, as that may help improve customer retention.
11. Opportunities Past Due
Especially for salespeople with too much on their plates (which isn’t uncommon), past due opportunities happen. Your goal is to keep this to a minimum. Again, if this metric grows faster than you’d prefer, consider delegating to others in your office. You can also monitor your funnel to learn why these opportunities haven’t closed and find a way to make it easier for leads to convert.
12. Sales by Closed Date
“The timing of a deal is just as important as its value, if not more so: Sales reps have monthly and quarterly quotas, sales VPs have company-wide revenue targets, and CEOs expect ‘hockey stick’ growth as soon as possible.” Closed dates help with forecasting and may help you find trends and gauge how long most customers take to convert.
Your Dashboard Helps Manage Your Sales
Most salespeople will benefit from keeping an eye on the metrics listed. The key to a successful sales dashboard, however, is to look at your reports, your personal sales goals, and what your company needs from you in order to determine which metrics are most important for your current needs.
The easiest way to stay organized and proactive in this hypercompetitive industry is with a sales dashboard. Consider these metrics, investigate what data is most important for your success, then build your dashboard. As you work through your pipeline, both at your desk and on your mobile devices, your dashboard will help you close deals faster.