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:

MetricDefinition
New SalesPurchase of a primary product
Cross SellPurchase of anything in conjunction with the primary product, but products are unrelated
UpsellPurchase that makes the primary product more expensive (upgrade, premium)

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:

Line Item TypeDescription
NewPurchase a brand-new service
CancelCancel an existing service (this is different than an order cancellation)
ReplaceCancel an existing service replacing it with a newly created one
Re-TermChange service term with an optional re-rate (also includes a renewal at new price and term)
Service RequestService work request resulting in a non-recurring service charge only

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:

MetricSubscription Services Definition
New SalesServices for new logo customers (first time sale to a new account)
Cross SellNew services for existing customers
UpsellService upgrades (including replacement with a new service) and re-rates
 
ImportantThe above definitions tend to be looser than their “widget” counterparts and may differ across businesses.

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):

Quote summary – new, replace, re-term and cancel line items on one quote
Quote summary – new, replace, re-term and cancel line items on one quote

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

Line Item TypeNew LogoExisting Business
NewNew Sales (MRR & NRR)Cross-Sales (MRR & NRR)
ReplaceUpsell (MRR & NRR)
Re-Term / Re-RateUpsell (MRR & NRR)
Service Request *Cross-Sales (NRR only) **
Cancel **

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

ImportantSince businesses use varying definitions of New SalesCross-Sell and Upsell, Nextian allows changing how they are calculated.

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:

New sales, cross-sell and upsell calculations
New sales, cross-sell and upsell calculations

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!

Thank you for contacting Nextian. Your request was successfully submitted, we will get back to you within two working days.

BY INDUSTRY

Cloud Infrastructure Providers

Cloud Software Companies

Managed Service Providers

Communications Service Providers

BY ROLE

CEO / Owner

CRO / VP Sales

CFO / VP Finance

COO / VP Operations

CPO / VP Product

CIO / VP IT

Product Management

Plan, launch and manage your product offerings throughout their entire lifecycle.

CPQ & Sales

Quickly create accurate quotes for complex products, subscriptions and add-ons

Order Management

Ensure faster, consistent order delivery with tasks, workflows and automation

Service Management, Support & Monitoring

Retain and upsell customers with comprehensive account intelligence, support, monitoring, analytics

Customer Portal

Empower your customers with 24/7 self-service, support and on-line ordering

NEXTIAN PLATFORM

Platform Overview

Billing Integration

Network Monitoring Integration

Reporting & Analytics