The Best Sales Reports Answer Key Questions – The 7 Levels of Reports
Begin with the end in mind. How many times have we heard that?
Since I have been busy updating our reporting model for InsideSales.com and tying it to our new 7 Tier Consulting Model I have thought deeply and discussed reporting with many of our team and our customers. The question is “which reports are really needed for the sales and marketing teams?”
In our industry you can do one of about four things to design reports:
- Think about the logical categories in your software; like Leads, Accounts, Deals, Cases, etc.
- Copy what everyone else is doing.
- Respond to what your customers ask for.
- Ask what questions your customers are needing answers to.
Which method would you choose?
If you Think about the categories in your software and write reports that work with each category you tend to focus on the product and the features of your product.
If you Copy what everyone else is doing you only do as well as as their best thinking and research and the entire industry seems to get tunnel vision. (We shy away from this because we learned a long time ago to Zig when everyone else Zags.)
If you Respond to what your customers ask for you tend to go by the prevailing wisdom. This may be a safe bet. But what is the result if your customers are typically looking to you for best practices? If you respond to them when they are really looking to you, this produces a circular loop of mediocrity. In highly developed industries (of which we are not), the customer is much more educated on what they want and this works much better.
We have tried all of these methods… and each one has proven to miss the mark.
It is best to ask the customer the questions they are trying to solve, design a report that clearly answers as many of those questions as possible in one simple place.
What customers are really needing is answers to their questions:
1- Which lead source actually closes the most revenue?
2- Which campaign is converting the most leads?
3- Which sales reps is most/least effective?
4- Are my leads getting contacted?
5- Why don’t my sales close?
6- Why do my sales close?
7- Do my leads trend up?
8- Do I make money?
What are your key questions?
After careful analysis and lots of thought I have come to the conclusion that there are about 7 levels of reporting structure and value. This model is quickly becoming part of our new book and more important the consulting model that will follow thereafter.
Level 1- Metrics: This is a simple number. 7 calls.
Level 2- Rates: This is a simple number over time. 7 calls in an hour. This is the only way to actually compare people over time and especially helpful in comparing full time to part time reps where they work differing hours in a day.
Level 3- Ratios: This is a Rate over a Rate, like Contacts over Dials during the same period of time is a Contact Ratio.
Level 4- Trends: This is a Rate or Ratio over time. Like Dials per hour for each day in a month, or revenue per week for each week in a quarter.
Level 5- Dispositions/Surveys: This is the only report that answers the key question of ‘Why?’ something happens. If you follow up with every prospect that does not close and ask why they don’t, you will gain invaluable data to help you change your offering, approach, price, term, etc., based on their combined answers.
Level 6- ROI (Return on Investment): This is the number that owners and management really want. This is cost compared to revenue. Each dollar in buys how many dollars out? This is most valuable for leads, sales people, offers, and marketing content because it focusses on what is most effective. This report is very hard to get in real time when their is still time to make a difference.
Level 7- Console/Dashboard: These are Rates, Ratios, Trends, Dispositions, or ROI in real time; while you can still do something about them.
1- Strong companies invest in Level 3 reports or higher.
2- Managers or Executives think the holy grail are Trends and ROI reports in real time consoles or dashboards so they can do their jobs better and gain visibility over what their people are doing. Wise companies give these consoles and real time dashboards to the front line sales rep so they can actually make changes during their day.
Update: InsideSales.com recently launched a solution that answers Question No. 4: Are your leads getting contacted? Response Indicator is a secret shopper service for web leads. It tells you how fast your sales reps respond to your leads and if they ever respond at all. You might be surprised by the results.
Top 30 Articles on www.KenKrogue.com (with total views) and a Summary of Ken’s Forbes Articles
- What is Inside Sales? Our Definition of Inside Sales | Ken Krogue – 90,920 Views
- Inside Sales Best Practices – 42,361 Views
- 31 Linkedin tips – How-to-use-Linkedin-Best-Practices for B2B Prospecting – 19,284 Views
- Inside Sales Tips by Ken Krogue – 14,997 Views
- Good to Great by Jim Collins – Ken’s Notes Summary – 9,758 Views
- About Ken Krogue – 7,439 Views
- Inside Sales is Top Method of Lead Generation – 6,439 Views
- My Final Comment on my “Death of SEO” column on Forbes – 6,411 Views
- Prediction – SEO will be Dead in 2 Years – 5,740 Views
- Inside Sales Training – 5,237 Views
- Inside Sales Best Practices: 7 Ways to Increase Contact Ratios – 5,202 Views
- Ken’s Forbes Articles – 4,960 Views
- Is Leaving a Voicemail Worthwhile? – 3,862 Views
- Inside Sales Best Practices: Gathering Direct Dial Phone Numbers – 3,624 Views
- KPI – Key Performance Indicators – 3,713 Views
- Inside Sales versus Outside Sales – 3.505 Views
- Harvard Business Review says Sales is No Longer About Relationships – 3,048 Views
- Behind the Cloud – Ken’s Notes – 2,745 Views
- Climb the Trust Ladder to Increase Results in Prospecting – W/ VIDEO! – 2,744 Views
- Inside Sales Tips – Skip to the Beep – 2,678 Views
- Lead Generation Strategies: When to Call, When Not to Call? – 2,232 Views
- Inside Sales Tips – No Vacations Last Week of the Month – 2,000 Views
- Inside Sales Tips – Specialize – 1,842 Views
- Ken Krogue’s Forbes Top 25 Most Popular Articles – 1,788 Views
- Ken Krogue – About Chauncey Riddle (My Mentor) – 1,396 Views
- Inside Sales Tips – Interest is The Counterfeit of Need – 1,375 Views
- 6 Reasons Salesforce Users Need Hosted Dialer Technology - 1,276 Views
- What is Lead Response Management – 1,204 Views
- Ken’s Rules: The Business Card Rule – 1,252 Views
- Inside Sales tips: Should Sales Reps be Held to Schedules? – 1,223 Views