article |
October 9, 2011
Using Sales Analysis to Power Territory Performance
By:
True measures of Sales Force Effectiveness are oftentimes difficult to gauge, as they rely on many different components and independent interactions occurring simultaneously. Sales leaders are challenged with watching the right metrics at the right time. Knowing impact and change over time allows you to make the right time-sensitive numbers to hit your number.
In particular, the VP of Sales often has difficulty in accurately measuring a salesperson’s territorial achievement. A new web-based tool makes great strides in addressing this issue.
Gapminder, an application owned by Google and available in Google spreadsheets, greatly enhances your ability to determine the high and low performers across a variety of metrics. Following the 2006 acquisition of Trendalyzer from the Gapminder Foundation, these advanced analytics tools are available to anyone willing to setup a Gmail account. The tool is used by simply creating a Google Spreadsheet and inserting a Motion Chart. Perhaps the best part of this analytics tool is the fact that it is free!
An example below illustrates the power of this technique over static and stagnant Excel spreadsheets.
Territory Performance Analysis from 2009 – 2010
Gapminder allows the user to actually watch the movement of up to four variables simultaneously. Important sales performance metrics like revenue, profitability, quota achievement, territory potential, and market penetration are easily monitored at the same time. The following is a brief description of the screenshot as well as the levers in the tool:
Interpreting Results:
When assessing performance, look at the length and the slope of each territory line (representing 2009 – 2010 performance). The steeper the slope, the greater the quota improvement on a Year-over-Year basis. The longer the line, the greater the revenue improvement. Additionally, an increase in bubble size denotes an improvement in profitability.
In this case, a cursory review leads you to the following observations:
The Gapminder Trendalyzer tool in Google Spreadsheets is a powerful sales analysis technique which allows you to observe your sales team performance for up to four metrics throughout the year. If you haven’t tried using this tool yet, I highly suggest giving it a try and let us know if you need any help getting started. If you have used it, please let us know in the comments below how you have used it and how your experiences have been with it.
On today’s special edition of the Revenue Growth Help Desk, we celebrate Women’s History...
You survived the rollercoaster of 2020. Now, you have 2021 ahead. It’s a new year, a fresh sta...
At this point in 2020, all your competitors have undergone some variation of a “digital transf...
Sales leaders are all inundated with a significant amount of data. The ability to draw insights from...
As a sales leader, it is necessary to understand the performance levers which impact your bottom lin...
Over the past several months, SBI’s latest research has unpacked how market-leading CEOs have ...
While the world innovated rapidly and continually adopts many advanced technologies, the sales envir...
Imagine the following: As you scroll through social media, you come across an ad. Not just any ad th...
SBI TV episodes bring you Sales and Marketing insights from B2B industry thought leaders and growth experts, on topics like product, pricing, customer experience and success, and go to market. Catch up on new and previous episodes here.