Overview
This template does the maths for you to get the most up-to-date data on your customers’ value. The purpose of this workflow isn’t just about the numbers, but the insight it provides to maximize retention.
Prerequisites
We have put together a list of prerequisites that are recommended for this workflow. This will be different depending on your usage, but you can use it for reference.
A Workspaces object chosen that includes:
MRR
currency attribute
How to use this template
Once opened, you will see a series of connecting blocks.
The Attribute Updated block will be activated every time you update the status attribute of the records in your Workspaces object. To make sure this is set up correctly, we will need to select the Workspaces object and the attribute used to track an account’s MRR contribution.
The Formula block detects the MRR update and does a calculation for the LTV. To get an accurate LTV projection, multiply the
{New Value}
(updated MRR) by your Average Customer Lifespan in months.The Update Record block automatically updates your customer’s projected LTV with the result from the calculation.