+34649324221 · Today 09:00–14:00 · 15:30–20:00

How to Calculate Your True CAC by Joining Marketing and Sales Data

· By the from Analytics teamChat on WhatsApp

What CAC is

Customer acquisition cost (CAC) is what it costs you, on average, to win a new customer. The formula is simple: what you spent on marketing and sales in a period, divided by the new customers in that same period.

For example: if in a quarter you spend €30,000 across campaigns, tools and the part of your team devoted to acquisition, and you win 60 new customers, your CAC is €500. The hard part isn't the division. It's that the two numbers come from different places and rarely match.

Which costs to include

  • Media spend: Google Ads, Meta, LinkedIn and any paid campaign.
  • Tools: the CRM, marketing automation and whatever you use to acquire customers.
  • People: the share of your marketing and sales salaries spent winning new customers, not serving existing ones.
  • Agencies and external partners working on acquisition.

Many companies calculate with media spend only. That "campaign CAC" is useful for comparing channels, but it's far below the real cost and makes acquisition look cheaper than it is.

Why it doesn't add up: marketing and sales count differently

Spend lives in Google Ads and in accounting; leads in GA4 and your form tool; customers in the CRM or ERP. Each system counts its own way:

  • Marketing counts conversions in the ad platform; sales counts signed contracts.
  • The same customer may arrive through three channels before buying, and each platform claims the sale.
  • Dates don't line up: the click is in March, the lead in April and the signature in June.

That's why a reliable CAC comes from joining sources in one place, with an ID that follows the customer from first click to invoice. Without it, every department has its own CAC and none of them is the real one.

How to calculate it by channel, step by step

  1. 1
    Join spend and customers
    Bring spend from each platform (Google Ads, Meta…) and won customers from the CRM into one place. A data warehouse such as BigQuery is the usual choice.
  2. 2
    Connect the source
    Store in the CRM where each lead came from (UTMs or the Google Ads click ID) so every customer can be attributed to a channel.
  3. 3
    Choose an attribution model
    First touch, last touch or a split across channels. None is "correct": what matters is picking one, writing it down and always using the same one.
  4. 4
    Align the dates
    Decide whether a customer counts in the month of the first click or of the signature, and apply it the same way to spend and customers.
  5. 5
    Calculate and compare
    CAC by channel = channel spend ÷ customers attributed to the channel. Compare it with what a customer is worth.

CAC on its own doesn't tell you if you're doing well

A €500 CAC is excellent if each customer brings in €5,000 and a disaster if they bring in €300. That's why it's read alongside customer lifetime value (LTV): a common benchmark for recurring-service businesses is an LTV of at least three times CAC. And alongside the payback period: how many months it takes a customer to repay what it cost to win them.

Those three numbers together belong on your sales dashboard, calculated once and with the same definition for everyone.

CAC FAQs

Does CAC include salaries?

Full CAC does: the share of the team devoted to acquisition. The media-only version is useful for comparing channels, but it isn't the real cost.

How often should I calculate it?

Monthly to follow the trend and quarterly to make decisions, because with few customers per month the number swings a lot.

Can I calculate it in Power BI or Looker Studio?

Yes, as long as spend and customers are joined underneath with the same definitions. Without that, the dashboard just paints the mess.

What if every platform claims the same sale?

Use your own attribution model on the joined data instead of adding up what each platform reports.

BigQuery consultingBusiness intelligence consultingSales dashboard KPIs

Want your true CAC by channel?

On a 30-minute call we look at the data you have and what it would take to calculate it properly.

Book a 30-minute call
Reviews

What our clients say

★★★★★
«from Analytics consultants have been a great asset to us at H&M. They initially joined us to support our migration to GCP and have since helped various business teams not only migrate their reports, but also restructure their entire BI architecture, while being a front-runner in exploring how AI can be utilized within analytics.»
Bianca A.H&M
★★★★★
«Truly impressed with from analytics data visualization skills! Their professionalism and attention to detail not only met but exceeded my expectations. Working with them was a breeze, thanks to their proactive communication and politeness. Highly recommend!»
Facundo P.Puramedicina
★★★★★
«Thanks to from Analytics, we now have custom dashboards to monitor performance across all team divisions, from marketing and customer success to finance and business development. The customer success dashboard has been a complete game-changer, and our leadership team can now make informed decisions directly from clear visual data. We are forever grateful for from Analytics dashboards!»
Chryso S.Stronde