The RevRec Canvas
Book 44: Recurring revenue, ARR and MRR: customer movements, the rollforward and a bridge to revenue cover

Home › Reporting and analysis

Book 44 · Alteryx workflows for SAP RAR

Recurring revenue, ARR and MRR: customer movements, the rollforward and a bridge to revenue

Measure monthly and annual recurring revenue from RAR contracts, explain every movement customer by customer, and bridge the run rate to the revenue RAR actually posted.

  • Reporting and analysis
  • Intermediate
  • 98 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

MRR at every month end for 55 customers in two companies, every new customer, reactivation, expansion, contraction and churn named, ARR rolled forward, and MRR reconciled to the recurring revenue RAR posted, to the cent. A second workflow measures net and gross revenue retention and MRR by cohort, and a retention scenario adds four customer stories.

What you get

  • The ebook: a 98-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (44_ARR_MRR.yxmd, 44b_Cohorts_NRR.yxmd)
  • 1 extra scenario with their own data and answer keys
  • Synthetic sample data (10 files) and an answer key, so you can check every number
  • Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment

Contents

  1. Chapter 1What ARR and MRR measure
  2. Chapter 2The data
  3. Chapter 3Months and the MRR of a POB
  4. Chapter 4Customers and their movements
  5. Chapter 5The rollforward and ARR
  6. Chapter 6The bridge to revenue
  7. Chapter 7Exceptions
  8. Chapter 8Control and reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Cohorts and retention
  11. Chapter 11Four stories that move retention
  12. Chapter 12Exercises
  13. Appendix ATool-by-tool settings
  14. Appendix BOutput field dictionary
  15. Appendix CAnswers to the exercises

Look inside

Book 44: Recurring revenue, ARR and MRR: customer movements, the rollforward and a bridge to revenue table of contents
Contents
Book 44: Recurring revenue, ARR and MRR: customer movements, the rollforward and a bridge to revenue first page
First page