Logo for the integration

How to Calculate Contract Value per Paying Customer in Google Sheets

Making the most of your Google Sheets data

What is Contract Value per Paying Customer?

Contract Value per Paying Customer (CVPC) is a metric that looks at the total value of all the contracts you have with your customers.

The metric is calculated by dividing the total contract value by the number of customers that have signed a contract with you.

Contract value can be calculated by multiplying the average contract value by the number of customers you have.

For example, if you have 100 customers and the average contract value is $100, the contract value per customer is $10,000.

This metric is a good way to determine the value of your customer base. It also shows how much you can expect to make from your customers in the future.

How do you calculate Contract Value per Paying Customer in Google Sheets?

It can be difficult to calculate Contract Value per Paying Customer directly inside of Google Sheets; that's where Causal comes in.

Causal is a modelling tool which lets you build models on top of your Google Sheets data. You simply connect Causal to your Google Sheets account, and then you can build formulae in Causal to calculate your Contract Value per Paying Customer.

What is Causal?

Causal lets you build models effortlessly and share them with interactive, visual dashboards that everyone will understand.

In Causal, you build your models out of variables, which you can then link together in simple plain-English formulae to calculate metrics like Contract Value per Paying Customer. This makes your models easy to understand and quick to build, so you can spend minutes, not days, on your models.

A comparison of formulae in Excel and Causal

When you're done, you can share the link to your model with stakeholders. They'll be able to view your model's outputs in a visual dashboard, rather than a jumble of tabs and complex formulae. The dashboards are interactive, letting viewers tweak your assumptions to see how they affect the model's outputs.

A gif showing how users can adjust model inputs, and how they're reflected in dashboards

Causal lets you add visuals in a single click, letting you plot out graphs and distributions for metrics like Contract Value per Paying Customer.

A gif showing how you can build visuals in Causal

Start building models with your 

Google Sheets

 data

Thanks! We'll be in touch soon.
Oops! Something went wrong while submitting the form.