Prompt
I'm building a subscription business and need CAC and payback by channel—what attribution setup makes sense?
Latest observation
For a subscription business, the “right” CAC and payback setup is usually a hybrid attribution model: use source-of-truth first-touch / last-touch for reporting, but use a simple, durable ruleset for CAC and payback decisions that maps spend to acquired customers and their realized gross profit over time.
What makes sense in practice
1) Track at least 3 layers of attribution
A. Acquisition source (for CAC by channel)
- Best for answering: “What channel brought this customer in?”
- Usually based on first-touch or last non-direct touch
- Examples: Paid Search, Paid Social, Organic, Affiliate, Partner, Referral, Outbound
B. Conversion influence (for marketing optimization)
- Best for answering: “Which channels assisted conversion?”
- Use a multi-touch model if you have enough data
- Good for internal insights, but not ideal as the only basis for CAC/payback because it can over-credit upper funnel
C. Revenue realization / cohort economics
- Best for answering: “When do we earn back the acquisition cost?”
- Build by customer cohort and channel
- Track gross margin, not just revenue, because subscription payback should reflect contribution economics
Recommended attribution setup for CAC and payback
If you want something robust and simple:
Use:
- First-touch channel for customer acquisition reporting
- Spend allocated by channel
- Cohort-based payback using realized gross profit over time
This is the most common and operationally useful setup for subscription businesses.
Why first-touch?
Because it’s stable and maps well to:
- CAC by acquisition channel
- cohort analysis
- payback period
- channel budgeting
Last-touch can be useful too, but it often overstates lower-funnel channels and understates demand gen.
How to calculate it
CAC by channel
For a given channel and time period:
CAC = Total channel spend / New customers acquired from that channel
Include:
- media spend
- agency fees
- contractor costs directly tied to that channel
- tooling tied to that channel
Exclude or separate:
- brand-wide overhead
- company-wide salaries unless you intentionally allocate them
- retention/customer success costs
Payback period by channel
For each acquisition cohort and channel:
Payback period = time until cumulative gross profit from customers acquired via that channel exceeds CAC
Gross profit should usually be:
- revenue
- minus COGS / fulfillment / payment processing
- optionally minus variable support if material
For subscriptions, payback is usually tracked in months:
- M1, M2, M3 cumulative gross margin
- compare against blended CAC for that channel/cohort
Best-practice structure
Use cohort-based reporting
Break customers into cohorts by:
- acquisition month
- acquisition channel
- maybe campaign if volume allows
Then for each cohort, track:
- new customers
- CAC
- ARPU / MRR
- churn / retention
- gross margin
- cumulative contribution margin
- payback month
This avoids misleading “point-in-time” CAC.
Attribution model by use case
Use first-touch for:
- CAC
- channel efficiency
- payback
- budget allocation
Use last-touch for:
- tactical campaign reporting
- landing page / keyword / ad-level optimization
Use multi-touch for:
- understanding assisted conversions
- content and nurture impact
- internal learning, not usually for finance-grade CAC
Important design choices
1) Define the acquisition event
Pick one:
- trial start
- signup
- paid subscription start
For subscription businesses, paid subscription start is usually best for finance-grade CAC, because it ties spend to actual customers, not just leads.
If you have a free trial model, you may also want:
- CAC to trial
- trial-to-paid conversion rate
- CAC to paid customer
2) Choose the attribution window
Common windows:
- 7-day click / 1-day view for paid media reporting
- longer windows for subscription businesses if consideration cycles are longer
But for finance reporting, consistency matters more than marketing-platform defaults.
3) Handle organic and brand carefully
Organic search, direct, and brand traffic often get messy. Decide:
- whether direct gets ignored in favor of prior non-direct touch
- how branded paid search is categorized
- whether organic is split into brand vs non-brand
4) Deduplicate across systems
Make sure one customer maps to one acquisition channel for CAC reporting, even if they had multiple touches.
What I’d recommend for most subscription businesses
Minimum viable setup
- Capture all UTMs and referrers
- Use first non-direct touch as the acquisition channel
- Attribute revenue to the customer cohort, not to every touch
- Build monthly cohort tables by channel
- Track gross margin-based payback
If you’re more mature
- Keep first-touch as the finance standard
- Add last-touch for optimization
- Add a multi-touch model for strategic analysis
- Reconcile paid media platform reporting to your internal source of truth
Common mistake to avoid
Don’t try to make one attribution model serve every purpose.
- Finance needs stable, conservative attribution
- Marketing needs responsive optimization data
- Leadership needs cohort economics
One model usually won’t satisfy all three.
Simple rule of thumb
If you need CAC and payback by channel, start with:
Channel = first non-direct acquisition source CAC = channel spend / new paid customers Payback = cumulative gross profit by cohort until CAC is recovered
That setup is usually:
- understandable
- repeatable
- good enough for budget decisions
- much less noisy than full multi-touch attribution
If you want, I can also give you:
- a sample data schema for this,
- a dashboard layout for CAC/payback by channel, or
- a decision tree for choosing first-touch vs last-touch vs multi-touch.