Blog

Contents

• 00:00 Introduction
• 06:02 Dissecting quote lines to see ARR / ACV and MRR / MCV
• 08:36 Creating rollup summary fields for ARR / ACV and MRR / MCV on quotes
• 12:13 Creating twin fields to map quote line data to opportunity products and opportunities
• 21:31 Creating a recurring revenue and non-recurring revenue section on opportunities
• 22:44 Testing twin field mapping of ARR / ACV and MRR / MCV
• 24:05 Updating page layouts to improve user interface and user experience
• 25:39 Using twin fields on other Salesforce CPQ objects

Contents

• 00:00 Introduction
• 09:54 Creating a Quote and Setting Up Fields
• 10:15 Understanding Recurring and Non-Recurring Revenue
• 13:29 Quote Data Model and Calculation Sequence
• 18:56 Setting Up Price Rules for ARR / ACV / MRR / MCV Calculation
• 50:44 Testing and Validating ARR / ACV / MRR / MCV Calculations

Definitions

MRR = Monthly Recurring Revenue

MCV = Monthly Contract Value

ARR = Annual Recurring Revenue

ACV = Annual Contract Value

NRR = Non-Recurring Revenue

Monthly Recurring Revenue (MRR) / Monthly Contract Value (MCV) Formula

IF( TEXT( SBQQ__SubscriptionPricing__c ) = "" ,
0 ,
IF( SBQQ__ProrateMultiplier__c <> 0 ,
SBQQ__NetTotal__c / ( SBQQ__ProrateMultiplier__c * SBQQ__DefaultSubscriptionTerm__c ) ,
SBQQ__NetTotal__c
)
)

Annual Recurring Revenue (ARR) / Annual Contract Value (ACV) Formula

IF( TEXT( SBQQ__SubscriptionPricing__c ) = "" ,
0 ,
IF( SBQQ__ProrateMultiplier__c <> 0 ,
12 * SBQQ__NetTotal__c / ( SBQQ__ProrateMultiplier__c * SBQQ__DefaultSubscriptionTerm__c ) ,
SBQQ__NetTotal__c
)
)

Non-Recurring Revenue Formula

IF( ISPICKVAL( SBQQ__SubscriptionPricing__c , '' ), SBQQ__NetTotal__c , 0 )

Panelists

John Garvens Owner & Principal Architect Garvens Consulting Garvens Consulting on YouTube

Content

• 00:00 Introduction
• 03:48 Quote Subscription Term vs. Quote End Date
• 10:44 Using Subscription Term over End Date
• 12:29 Configuring Salesforce CPQ for subscription pricing and proration
• 15:50 Changing the order of fields that display in the Quote Line Editor
• 25:15 Revenue Lifecycle Management (RLM) Overview
• 33:38 How do I know which field sets I am using?
• 36:55 A quick rant about user experience in Salesforce CPQ
• 40:13 Creating new field sets specific to your business using “Special Fields”
• 44:44 How to become a Salesforce CPQ superhero

Contents

• 00:00 How does the Number field on product feature and product option records work?
• 04:28 How should I order product features and product options?
• 07:31 How do the Min Quantity and Max Quantity fields on product options work?
• 09:31 Configuring Min Quantity and Max Quantity for the peanut butter and jelly sandwich
• 13:36 Testing peanut butter and jelly sandwich quantity configurations
• 17:19 Adding new products for PB&J club memberships and support
• 21:28 Configuring subscription products in Salesforce CPQ
• 25:33 Creating a product feature for new subscription products
• 29:41 Creating product options for the new subscription products
• 33:25 Troubleshooting a “CPQ nuance” related to product option auto-selection
• 35:08 Pre-selecting product options to simplify product configuration
• 39:48 Determining which product options should and should not be pre-selected
• 43:12 Optimizing bundle configuration to create a better user experience