Metrics

How to Calculate Your True CAC (and Why Your Spreadsheet Lies)

Ask most marketers what their CAC is and they'll tell you their ad spend divided by their new customers. That's a start, but it's almost always incomplete. The parts it misses are the parts that change the answer most.

Understanding your true customer acquisition cost is one of the most important calculations in your business, because it sets the ceiling for what you can profitably spend to grow. Get it wrong and you'll either underspend (leaving growth on the table) or overspend (buying customers at a loss without realizing it).

The CAC formula

At its core, CAC is simple:

CAC = Total acquisition spend ÷ New customers acquired

The complexity is in what goes into each side of that equation.

What counts as acquisition spend

There are two common versions of CAC, and it's worth being clear which one you're using:

  • Paid CAC: Only direct ad spend is in the denominator. Meta spend + Google spend + any other paid media. This is the right number for evaluating the efficiency of your paid channels in isolation.
  • Fully-loaded CAC: Ad spend plus all other costs that support acquisition: agency or freelancer fees, your attribution and analytics tools, content production costs, and any portion of team time dedicated to acquisition. This is the honest number for understanding what it actually costs you to acquire a customer.

Neither is wrong. They just answer different questions. Use paid CAC to evaluate your media efficiency. Use fully-loaded CAC to understand the true unit economics of your business.

What counts as “new customers”

This should be new customers only: people who paid you for the first time in the period. Renewals, upsells, and returning buyers should not be counted. Including them inflates the denominator and makes your CAC look better than it is.

Why spreadsheets lie

Even with the right formula, spreadsheet-based CAC calculations fail in a few predictable ways:

Cost and customer counted in different periods

You spend on ads in January. Leads come in over several weeks. Some of them close in February. If you divide January spend by January new customers, you're mismatching the costs and the outcomes. The spend that produced February customers is being credited to January's count. For businesses with a sales cycle longer than a few days, this period mismatch can make CAC look wildly different month-to-month even if nothing has actually changed.

Partial costs

Ad spend is easy to measure because the platforms give you exact numbers. Agency fees, tool costs, and internal time are harder to track, so they often get left out. The result is a CAC that looks better than reality.

Sales attributed to the wrong source or to no source

If some of your new customers arrive with no source tracked (because a link wasn't tagged, or the UTM was lost during the sales process), you can't tell which spending produced them. When revenue shows up as “no source,” you can't accurately allocate it back to the campaign that drove it, which distorts every channel's CAC simultaneously.

Blended CAC vs paid CAC: a worked example

Take a hypothetical business in a given month:

  • Ad spend: $15,000
  • Agency fee: $3,000
  • Attribution tools: $500
  • New customers acquired: 50
  • Paid CAC: $15,000 ÷ 50 = $300
  • Fully-loaded CAC: $18,500 ÷ 50 = $370

The gap between $300 and $370 is the difference between what you paid the ad platforms and what you actually paid to acquire those customers. For a business where LTV is $900, the first number says you're at a 3:1 ratio and healthy. The second says you're at 2.4:1 and should be thinking about efficiency.

The LTV:CAC health check

LTV:CAC is the most common framework for evaluating whether your acquisition spend is sustainable. A commonly cited target is a 3:1 ratio: for every dollar you spend acquiring a customer, you expect to recover three dollars in lifetime value.

A ratio below 1:1 means you're acquiring customers at a loss. A ratio above 5:1 may indicate you're underspending and leaving growth on the table. The right number depends on your business model, margins, and payback period tolerance, but 3:1 is a solid starting benchmark for most direct-response businesses.

The key constraint: this ratio is only meaningful if your CAC and LTV are calculated consistently. LTV based on optimistic retention assumptions against a paid-only CAC will give you a number that looks healthy but doesn't reflect reality.

How to get it right

Accurate CAC requires three things working together:

  1. Complete cost tracking. Know every dollar that goes toward acquisition, not just ad spend. Even a rough estimate of agency and tool costs is better than ignoring them entirely.
  2. Consistent period matching. Either match spend to the customers it produced (cohort-based), or use a rolling average to smooth out the timing mismatch. Avoid month-to-month comparisons where the lag makes numbers swing artificially.
  3. One reconciled source of truth for customers. If you're pulling new customer counts from your payment processor, your CRM, and your ad platforms and getting three different numbers, you don't have a CAC problem. You have a data problem. You need one authoritative definition of “new customer acquired” and one place where that count is measured.

The hardest part of CAC isn't the math. It's agreeing on what counts as a new customer, which costs belong in the numerator, and where the data comes from. Settle those three things and the calculation is trivial.

Where Cavor fits in

Cavor ties ad spend, CRM lead data, and payment records together so you can track CAC against actual new customers, not platform-reported conversions, with the source of each customer visible throughout the funnel.