What are the common mistakes companies make when calculating CAC from CRM and ad platform data?
Quick Answer: The most common CAC mistake is treating CRM and ad platform numbers as if they represent the same customer journey, then dividing spend by an inflated or misattributed lead count. Companies routinely miss hidden costs, duplicate conversions, offline sales effort, and delayed revenue recognition, which makes CAC look artificially low and breaks channel-level decision making.
Detailed Explanation
Accurate CAC calculation requires a unified attribution framework, not a simple ratio pulled from two disconnected systems. Ad platforms often overstate performance because they count platform-attributed conversions, while CRMs can understate or distort acquisition costs when sales labor, software, creative, and follow-up time are excluded. The biggest errors come from mismatched attribution windows, duplicate records, incomplete source tracking, and using leads instead of closed-won customers as the denominator. If CRM lifecycle stages, ad spend timestamps, and revenue recognition are not normalized to a single source of truth, CAC becomes a reporting artifact rather than an operational metric.
Key Technical Drivers
- Use closed-won customers, not raw leads, as the CAC denominator, and reconcile CRM lifecycle stages against actual booked revenue to avoid false efficiency signals.
- Normalize attribution windows and source definitions across Google Ads, Meta, LinkedIn, and the CRM so the same conversion is not counted multiple times or assigned to the wrong channel.
- Include fully loaded acquisition costs—media, agency fees, sales salaries, commissions, tools, creative, and onboarding labor—so CAC reflects true unit economics instead of only ad spend.