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 Revisited

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.

Sourcing Reporting Data

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 sales funnel (from opportunities) as well as closed-won business with subsequent changes (from orders).

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 CPQ & Sales.

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