How to calculate Lifetime value in Airtable

Make the most of your Airtable data

What is Lifetime value ?

Lifetime value is the present value of the futureĀ net profitĀ from the customer over the duration of the relationship. It helps determine the long-term value of the customer and how much net value you generate per customer after accounting for customer acquisition costs (CAC). For instance if you are selling monthly licences common definition of your lifetime value would be average contract duration * monthly fees

What is Airtable ?

Airtable is a platform for building collaborative applications. It is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet that integrates nicely with all your favorite apps and services

How to calculate Lifetime value in Airtable ?

It can be difficult to calculate Lifetime value directly inside of Airtable; that's where Whaly comes in.

Whaly helps you build models on top of Airtable and many other solutions. You simply connect Whaly to your Airtable account, and then you can create your formula in Whaly to calculate your Lifetime value.

How does Whaly work ?

Access all your data
No more manual import or stale data. Whaly automatically updates your data and is integrated to the tool you use to give you the most flexibility.
Build metrics like a pro
Use our state of the art studio to access your data, prepare your reports by cleaning and formatting your data. Combine your different sources to explore your data in a way you never had before.
Build your metrics
Visualize your data
Whaly offers best in class data visualization capabilities.
Visualize your data
Edouard Mascre
We leveraged Whaly on the Sales team to build and share dashboards with ton of partners without having to continuously update things on many spreadsheets. It also gives us deeper insights on sales activity. The dashboards built can be shared with everyone in the company. Whaly saves us hours of data wrangling every day.
Edouard MascrƩ
Co-Founder @ Pennylane
Benjamin Cambier
Mansa grew really fast in the past months and we were in urge of more precise metrics, especially for acquisition and deals analysis. Our engineering team was already swamped so we started our data analysis with Whaly. We compute our CAC per acquisition channel and understood at what stage the pipeline is under performing in minutes.
Benjamin CAMBIER
Co-Founder @ Mansa