Garvens Consulting

Trust the beard.

Salesforce Revenue Cloud

Calculate and Display Current, Potential, and Total Customer Value in Salesforce

· ·

Contents

  • 00:00 Comparing current, potential, and total customer value
  • 02:30 Create a source report for opportunities, grouped by account
  • 07:32 Add a donut chart to the source report
  • 09:52 Add the donut chart to the account record page
  • 13:40 Adjusting the source report to improve data visualization
  • 26:14 Create Current Customer Value, Potential Customer Value, and Total Customer Value roll-up summary fields on accounts
  • 32:08 Create a section on the account page layout to display customer value

Passing ARR / ACV and MRR / MCV to Opportunities with Salesforce CPQ Twin Fields

· ·

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

Calculate ARR / ACV and MRR / MCV in Salesforce CPQ

· ·

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 )

Creating Subscription (Recurring) Products in Salesforce CPQ

· ·

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