Welcome to our best practices & KPI’s to get you a Sales dashboard that will drive results


“Your dashboards need to achieve 2 things; be useful & drive engagement. When your staff look at them everyday, give feedback & adjust them, THAT is when they will drive results continuously.”

1. Set Base & Stretch Goals


1. Firstly it’s best practice to set goals with your team and more importantly keep reviewing them as the months go by
2. Base goals keep your goals achievable & usually, a sales commission is based on these
3. Stretch goals inspire us to think big and remind us to focus on the big picture


  1. We usually put these goals into googlesheets, this means they can be shared and updated by the entire team whenever they need to be
  2. We pull these goals into the datalake where your entire businesses data sits
  3. Combine them in KPI Cards or Visuals like the below or tables or whatever makes sense to you and your team


Sales Dsahboard tips 1

Base vs Stretch Goals

2. Don’t clutter the dashboard, it’s an operations dashboard, only show what you want to focus on


You want your team to know what you want them to focus on


  1. This is an operations not an analytical or vanity dashboard, don’t put lots of charts and graphs on
  2. Pin just a few numbers and gauges from the underlying report onto your dashboard
  3. Remember you can change what goes on a dashboard based on a new direction or team feedback


3. Keep it realistic & keep refining if you want to drive engagement


You want your staff looking at this at least every other day. If the dashboard you have created has targets that become unrealistic or a bunch of crap that’s not relevant, it’s going to fail.


  1. Review regularly
  2. Ensure staff are encouraged to give feedback
  3. Ensure you use a tool that is flexible and allows you to adjust KPI’s / metrics / layouts / areas of focus over time.

4. Splits Sales Orders & Invoiced Sales


All sales are not born equal. Invoiced usually is tied to cashflow, Sales Orders usually tied to commission, there is no hard and fast rule here. Some businesses treat Authorised Quotes as Sales Orders some exclude Disbursements from sales. It completely comes down to your business and it’s a process that evolves over time.


Either split the Metrics between 2 dashboards or label them as such. No rocket science here.

Sales vs Invoiced Dashboards

Sales Orders and Invoiced Sales split between two dashboards


5. Automate fully, update at least hourly, look Ma no hands!


If it’s manual…

  • It’s not going to create the team competition we are after
  • It’s not going to get done when someone goes on holiday
  • It’s going to contain errors
  • It’s going to suck. Don’t get me wrong, it’s important to do an initial manual version whilst testing it out amongst your staff and assessing feasibility, but the end game is a no hand situation.


  1. Choose systems that have API’s or abilities to expose date
  2. Choose a best of breed data solutions provider like us 😉

Look Ma No Hands


6. Sales vs Should Be Targets KPI


This is the one number you want your staff to focus on, if it’s red, have chats about how to fix it. If it’s green, have chats about how to hit the incentive targets.


Sales Vs Should Be Target

The one number you want your staff to focus on

Sales vs Should be calcuation

Sales vs Should be calculations


7. Daily average required target KPI


“Turn a goal into a habit”



Required Avg Daily Sales


Avg Daily Sales Required Calculations

I hope you have enjoyed this post as much as we have enjoyed creating these dashboards with our clients and garnering suchknowledge knoweldge along the way!