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


