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

why?

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

how?

  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

why?

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

how?

  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

why?

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.

how?

  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

why?

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.

how?

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!

why?

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.

how?

  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

why?

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.

how?

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

why?

“Turn a goal into a habit”

how?

 

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!

 

www.datasights.co