← All templatesReporting
Customer Acquisition Tracker Template
Track every new customer by source, cohort, and CAC — and see exactly which channels are scalable.
What's inside
- Customer-level acquisition log
- Source attribution columns
- Cohort retention table
- CAC by channel tracker
- Payback period per cohort
- Quality score per channel
- Monthly summary dashboard
How to use it
- 1Log every new customer's source on day 1 — ask them, don't guess. 'How did you hear about us?' is the single highest-value question in customer onboarding.
- 2Track cohort retention monthly. Cohorts reveal channel quality far better than CAC alone.
- 3Use the quality score to decide where to scale. High retention + low CAC = pour fuel.
Why this template works
CAC alone is misleading. A channel can deliver $20 CAC but if those customers churn in 30 days, you're losing money. This template ties acquisition to retention — the real measure of channel quality.
Related templates
More in Reporting.
Reporting
Monthly Marketing Report Template
One-page monthly marketing report that gets read by busy founders and leadership — KPIs, wins, misses, next steps.
Get template →ReportingSocial Media Analytics Dashboard Template
Weekly social media dashboard tracking the 6 metrics that actually matter — across Instagram, TikTok, LinkedIn, and Facebook.
Get template →ReportingROI Tracking Spreadsheet Template
Campaign-by-campaign ROI tracker that calculates true return — including labor, software, and opportunity cost.
Get template →