How to Calculate Customer Acquisition Cost in Google Sheets

Making the most of your Google Sheets data

What is Customer Acquisition Cost?

Customer Acquisition Cost (CAC) is the total cost it takes to acquire a new customer. CAC is calculated by dividing the total cost of acquiring a new customer by the number of new customers acquired during that time period.

CAC is a broad metric that is used to determine how much it costs your company to acquire a new customer. This metric is used to determine whether or not your company is spending too much money on acquiring new customers.

CAC is calculated on a per-customer basis, and is usually calculated on a monthly basis.

How do you calculate Customer Acquisition Cost in Google Sheets?

It can be difficult to calculate Customer Acquisition Cost 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 Customer Acquisition Cost.

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 Customer Acquisition Cost. 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 Customer Acquisition Cost.

A gif showing how you can build visuals in Causal

Get started today with Causal

Start building your own Customer Acquisition Cost models, and connect them to your Google Sheets data.