Automated Upsell, Cross Sell and New Sales calculations for subscription services in Salesforce

Upsell, Cross Sell, New Sales are one of the most important sales KPIs and are reported by virtually all businesses.

While these metrics are pretty straightforward for traditional “widget” sales, there are numerous considerations regarding their calculation for subscription services.

In this post, “widget sales” are “any-product, physical object” sales similar on-line shopping: a customer may place multiple orders, each with multiple items with various quantities and separate delivery dates.

The key difference between widget vs. subscription is that widget sales are transactional (in a sense that they are independent orders) while services have a life span and transactions happen during the entire life cycle of the service.

For example, a service can get ordered, upgraded (e.g., more user licenses), moved (e.g., to a different data center), renewed a few times and finally get canceled — all of this can happen over a few years’ time. In contrast, a “widget” order is typically delivered within days or weeks.

Other differences include:

• A need for separate calculations for recurring and non-recurring charges
• Quotes and orders potentially having a mixture of line item types (e.g., new service, upgrade, re-term, etc.)
• Quotes and orders spanning multiple services

All of these make Upsell, Cross Sell, New Sales calculations for subscription services more complex than for traditional “widgets”.

“Classic” definitions

Before diving into intricacies of subscription service management, let’s take a look at “classic” definitions of Upsell, Cross Sell and New Sales.

They may vary a bit depending on the source usually go along these lines:

New vs. existing account considerations

While Upsell, Cross Sell and New Sales definitions for subscription services vary slightly from business to business, they typically depend on some form of ‘new account’ identification.

Please refer to the following post for comprehensive information on fully automated ‘New Account / Logo’ identification strategies.

Line item types

While in widget sales each line item is for the most part a new product request (with optional add-ons, quantity, discount, etc.), subscription service quotes & orders allow multiple line item types.

Their names vary across industries (e.g., telecommunications industry refers to them as MACDs), but typically boils down the following set:

Definitions re-visited

Now that we’ve covered new account definition as well as order line item types for subscriptions, we can revisit the Upsell, Cross Sell, New Sales definitions for subscription services:

Putting it all together — a CPQ example

Nextian allows quotes with multiple line item types, each supporting MRC (Monthly Recurring Charge) and OTC (One-Time Charge):

With the following calculations defined as sums of MR Total and NR Total on individual line items:

^* Service Requests have only non-recurring charges
^** Cancellations are excluded altogether from new NRR / MRR calculations (they are included in lost revenue)

Calculations source

Widget sales (such as on-line shopping) have little distinction between quote and order.

With subscription services it’s different: a quote becomes an order that produces a service.

Nextian calculates New Sales, Cross-Sell and Upsell on quotes, and propagates numbers to opportunities via syncing quotes.

[Syncing] Quote → Opportunity

The screenshot below illustrates how this looks on an opportunity:

Since opportunities relate to orders, reporting is possible for both funnel as well as closed-won business.

Conclusions

Upsell, Cross Sell, New Sales are one of the most important sales KPIs. While their “classic” definitions are fairly straightforward, for subscription services they need to be re-defined to consider transactions happening during the entire service life cycle (upgrades, changes, replacement, re-rates and others).

It is possible to implement fully automated calculations of these KPIs in Salesforce with modifications of standard CRM objects (quotes, price books, etc.) or purchasing an off-the shelf CPQ package capable of quoting subscription services such as Nextian.

Nextian is a vendor of Quote-to-Cash (QTC) software for cloud and communications helping providers accelerate growth and increase customer lifetime value.

Contact us today to find out how we can help you!