+44 203 280 3665

Recent research by GSP with one of our customers showed a 65% difference in the average closed won opportunity size.

That’s a huge variation.

All salespeople are working comparable territories. Selling the same products to similar customers.

So the variation represents a potential weakness in the sales process of some salespeople. And that’s a major opportunity.

So here’s a summary of the investigation.

Average Closed Won Opportunity Size

The first step was to create an Average Closed Won Opportunity Size report.

Tip: To do this, start by creating a matrix report. Assign Opportunity Owner to the left column. Place Close Date (grouped by month or quarter) across the top. Then add the Amount field to the main body, summarized by Average.

To register for a free dashboard that includes the Average Closed Won Opportunity Size report complete the form at the foot of this blog post.

Here’s what the resulting salesforce dashboard chart looks like.

This dashboard chart shows average size of closed won opportunities in salesforce.

And here’s the underlying report.

This salesforce report shows the average size of closed won deals.

The report shows that Dave’s average closed won deal size is $58K. This compares to $35K for John. That’s a 65% difference.

Average Closed Won Opportunity Size Compared to Total Sales

Let’s put some context on the figures. A large average deal size is no good if total sales are low.

Here’s the comparison.

Closed won opportunity revenue per salesperson.

Now we can see that Dave not only has the highest average closed won opportunity size. He’s also the top sales person. To find out the full story on this, read the blog Dave Apthorp: The Best and the Worst Salesperson.

John is the lowest performing salesperson and has the lowest average closed won opportunity size.

The overall sales performance of Sarah and Shaun is roughly in line with average deal size.

12 Must Have Charts For Your Salesforce Dashboard

Download the FREE eBook today from our website

Get it now!

Average Number of Products per Opportunity

We spoke to the team manager, Colin Parish. Colin speculated that the average closed won opportunity size is closely correlated with the number of products sold on each opportunity.

In particular, Colin believed that the high performers sold more optional products.

Let’s see if he’s right.

The chart shows the proportion of the average opportunity size in terms of Core and Optional products.

Salesforce dashboard chart that shows the contribution of optional products to the average closed won opportunity size.

The split between Core and Optional is made using a custom field with these picklist values on the Product.

We can see that a significant proportion (over 35%) of Dave’s average deal size is made up of Optional products. In other words, Dave is doing a great job of adding ancillary products and services to his opportunities. That’s boosting his average closed won opportunity size.

Sarah is ranked third in terms of average closed won opportunity size and second in overall sales. Yet we can see the small contribution – less than 5% – that optional products make to her deals. Coaching Sarah in this area is likely to produce a direct increase in deal size and revenue.

“Sarah has one key challenge – she needs to add more optional products to her opportunities. She’s spending two days with Dave Apthorp, learning from his expertise.”

The chart is less conclusive for John and Shaun. They have some way to go to achieve the same ratio as Dave. But perhaps there are other factors also at play? Let’s examine that in a moment.

One final point on adding optional products before we move on.

Many salespeople find it difficult using the standard user interface in salesforce to find the right products to add to opportunities. It’s a common problem. Take a look at the product selection wizard to make it easy to identify and add products to opportunities.

Price Discount Impact on Average Opportunity Size

John sure is the leader on one dashboard chart. He gives away a higher proportion of revenue in discounts than anyone else!

salesforce dashboard chart that shows the amount of discount given away by each sales rep.

Dave and Sarah give away the least amount of discount in percentage terms. If Sarah can up her game in terms of the number of optional products per opportunity she’ll be at Dave’s level of sales performance.

Shaun and John can improve in terms of both optional products and discount giveaways. Colin is spending time with both, coaching and supporting them to improve their overall sales performance.

One final thing on price discounts. We recently interviewed pricing expert Tony Hodgson. for ideas on how to avoid giving away excessive margin through discounts.

“Most companies can increase profit by between 2 and 4 percent by doing nothing other than getting a grip on price discounts.” Tony Hodgson, Pricing Solutions.

Here are the 10 tips for controlling price discounts that Tony gave us. Colin is already implementing most of them!

Lessons learned

Here are the five lessons Colin says he has learned from looking at average closed won opportunity size.

How many can be applied to your business?

  1. Average closed won opportunity size is an essential sales metric that gives powerful insight.
  2. The metric can’t be used in isolation. Other reports add meaning to the figures.
  3. Tagging products Core and Optional is a really useful way of understanding how effective sales people are at up-selling.
  4. It’s important to measure price discount giveaways. The 10 pricing tips is a great resource for managing discount amounts.
  5. Have a range of sales metrics about closed won opportunity size gives managers the essential information they need. With these metrics, rep-specific coaching, training and support interventions can be made.

When all is said and done, there are only three ways to increase sales revenue. Increase the size of the pipeline, improve opportunity conversion rates, and increase average closed won opportunity size.

Go out and boost your revenue 🙂

Complete the form below to obtain a FREE SALESFORCE DASHBOARD that includes the opportunity conversion rates shown in this blog post.

Related Blog Posts

12 Must-Have Salesforce Dashboard Charts | With Video And Examples

3 Killer Pipeline Quality Metrics To Highlight When To Be Sceptical

How to use opportunity conversion reports for superior results

5 Easy Tips That Will Make Opportunity Probability Your Trusted Friend