Setup guide
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:
MRRcurrency 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.
Workflows FAQ
If you’d like your workflow to access a specific list you’ll need to make sure the workflow has access, just like if it was a workspace user. You can do this in the List access permissions settings.
Credits are the currency used to measure the resource consumption of your workflows. Most blocks consume a credit when run. Learn more by reading our Automations billing article.