DatabasesConnect to any database and analyse your data instantly·FilesUpload CSV or Excel files and explore them with AI·ChatAsk questions in plain language — chat with your data·DashboardsBuild interactive dashboards from your queries in seconds·AILet AI write the SQL so you don't have to·ChartsVisualise trends with auto-generated charts and graphs·No-codeZero SQL knowledge needed — just ask in plain English·ShareShare live dashboards with your team in one click·InsightsSurface hidden patterns and outliers in your data automatically·ExportsDownload results as CSV, Excel, or PNG charts instantly·DatabasesConnect to any database and analyse your data instantly·FilesUpload CSV or Excel files and explore them with AI·ChatAsk questions in plain language — chat with your data·DashboardsBuild interactive dashboards from your queries in seconds·AILet AI write the SQL so you don't have to·ChartsVisualise trends with auto-generated charts and graphs·No-codeZero SQL knowledge needed — just ask in plain English·ShareShare live dashboards with your team in one click·InsightsSurface hidden patterns and outliers in your data automatically·ExportsDownload results as CSV, Excel, or PNG charts instantly·
AnalityQa
FeaturesBy rolePricingFree toolsBlog
Sign inGet started
Blog›Marketing / Finance

LTV and CAC numbers your CFO can actually trust

LTV and CAC are usually two numbers nobody can reconcile. AnalityQa AI joins your billing data and your ad spend, computes LTV per cohort, CAC per channel, and shows the payback curve — with the math you can audit.

Try AnalityQa AI AI free →See live examples
Laptop showing dashboard comparison

The problem

  • →LTV in the founder's deck is usually "average revenue × something" — an aggregate that hides the long tail of customers who churn fast.
  • →CAC is calculated by summing ad spend and dividing by new customers, but the spend across Google, Meta, LinkedIn, partner programs, and outbound never gets attributed consistently.
  • →Payback period — how long until a cohort's LTV covers its CAC — is rarely tracked, so the team can't tell if a channel is actually profitable.
  • →When LTV/CAC is reported per channel, it usually averages over all customers acquired through that channel without separating the small enterprise wins from the high-volume self-serve.

Why the usual approach breaks down

LTV needs a real survival model, not an average

Aggregate LTV (`average monthly revenue × 1/churn rate`) over-weights a few long-lived customers and ignores the cohort dynamics. A proper LTV is computed per cohort, with a survival curve that bounds expected duration. Few teams have the data discipline to do this consistently.

Channel attribution is usually broken

Marketing reports first-touch in one tool, last-touch in another, and self-reported channel from a signup question that 30% of users skip. Reconciling these into a single source of truth for CAC requires manual joins and judgment calls that produce different answers each quarter.

Spend doesn't equal CAC

Total ad spend is one thing. Fully-loaded acquisition cost — including SDR salaries, partner commissions, agency fees, free credits given to land deals — is another. Most internal CAC numbers omit at least one of these, so two reports of the same channel's CAC can differ by 40%.

Payback period is often skipped

An LTV/CAC ratio of 3:1 sounds healthy, but if the payback takes 24 months, the channel is starving cash flow. Computing payback requires modelling cumulative gross profit per cohort against the upfront CAC — which spans billing, accounting, and marketing data.

How AnalityQa AI AI solves it

Upload your data — or connect it live — and ask in plain English.

01

LTV per cohort with survival math

AnalityQa AI computes cohort-based LTV using your actual retention curve. Ask "What's the LTV of customers acquired in Q1 last year?" and get a number based on observed revenue plus a survival projection for what's still to come, with a confidence range. No more "ARPA divided by churn" estimates.

02

Fully-loaded CAC per channel

Connect Google Ads, Meta Ads, your CRM with self-reported source, and a CSV of fully-loaded costs (SDR salaries, agency fees, free credits). AnalityQa AI sums them by channel, divides by attributed new customers, and shows you the components so the CFO can audit where the number comes from.

03

Payback curves, not just ratios

Ask "Show me the payback curve for paid search vs organic for the past 4 cohorts." AnalityQa AI plots cumulative cohort gross margin minus initial CAC over time. The crossover point is the payback period. Channels that look great on LTV/CAC ratio sometimes have 30-month paybacks — the chart makes it obvious.

04

Slice by plan, segment, geography

After the channel view, drill in: "What's the LTV/CAC for Pro plan customers acquired through outbound vs self-serve?" The same definitions apply, the slice changes — no new queries to write.

05

Investigation when CAC spikes

When CAC rises unexpectedly, ask "Why did paid CAC spike 35% in March?" AnalityQa AI runs an investigation: ad spend changes, conversion rate changes, mix shifts in audience. Returns a written diagnosis with the contributing factors quantified.

You askedGenerated in 4.2s

"What's our cohort-based LTV for customers acquired in Q1 last year?"

Revenue

€1.42M+12.4%

Gross margin

58.2%+1.8pp

Burn rate

€84k/mo−6.1%

LTV summary card with confidence range

Last 12 mo

Bar chart: fully-loaded CAC by channel

Segment ASegment BSegment CSegment DSegment ESegment F

Payback curves: cumulative gross margin − CAC by month

A dashboard built in AnalityQa AI — from question to chart, no SQL.

Real examples

Paste your data. Ask. Ship.

You

What's our cohort-based LTV for customers acquired in Q1 last year?

AI

Q1 cohort LTV is $2,340 with a 90% confidence range of $2,100 to $2,580. Computation: $1,820 of revenue observed to date, plus $520 expected from the projected survival curve. The cohort has retained 64% at month 14.

LTV summary card with confidence range
You

CAC by channel for the past 6 months, including SDR loaded costs.

AI

Google Ads: $740 CAC (spend + agency fee, 122 customers). Outbound: $1,220 CAC (SDR salary + tooling + 18 won deals). Organic: $180 CAC (content team allocation, 84 customers). Partner: $90 CAC (rev share, 28 customers).

Bar chart: fully-loaded CAC by channel
You

Show me the payback curve for Google Ads, Outbound, and Organic over the past 4 quarterly cohorts.

AI

Organic pays back at month 5. Google Ads pays back at month 13. Outbound pays back at month 18 — but the LTV at month 36 is 2.4x Google Ads. Each channel's curve crosses zero at a different point — the CFO needs to see the time, not just the LTV/CAC ratio.

Payback curves: cumulative gross margin − CAC by month
You

What's the LTV/CAC ratio for Pro plan customers acquired through outbound?

AI

Pro+Outbound LTV is $11,400 (cohort-based). Pro+Outbound CAC is $2,800. Ratio 4.07. Same channel for Starter customers: ratio 1.4. The channel is profitable for Pro and unprofitable for Starter — the headline outbound LTV/CAC of 2.8 was an average that hid both.

Ratio breakdown table: channel × plan
You

Why did paid search CAC spike 35% in March?

AI

March CAC for Google Ads was $1,000 vs $740 average. Driver 1 (54% of the gap): cost-per-click up 22% on the top 5 keywords. Driver 2 (32%): conversion rate from click to signup down 14pts (regression in the landing page A/B test). Driver 3 (14%): channel mix shifted to higher-cost branded terms.

Investigation report with three driver panels

What teams get out of it

✓LTV is computed from cohort survival, not from aggregate ARPA divided by churn.
✓CAC includes the loaded costs every channel actually consumes — defensible to the CFO.
✓Payback period is on the same dashboard as the LTV/CAC ratio.
✓Channel decisions are made on per-plan economics, not per-channel averages.

Frequently asked questions

How does AnalityQa AI handle attribution between first-touch and last-touch?+

Both views are available. Tell the chat which one to use: "CAC by last-touch channel" or "CAC by first-touch channel." If you want a multi-touch model (linear, time-decay, position-based), describe it and AnalityQa AI will apply it to the connected data. The default is last-touch because that's the most common reporting convention.

Where do the loaded costs come from?+

From a CSV you upload (or a Google Sheet you connect) listing channel, month, and total fully-loaded cost. AnalityQa AI joins this against new customer counts from billing data to compute CAC. Most teams maintain this monthly anyway for finance — pointing it at AnalityQa AI takes one minute.

Can we use a different LTV horizon — 12 months instead of full lifetime?+

Yes. Specify in the prompt: "12-month LTV by cohort" or "24-month LTV by channel." Truncated LTV is often more defensible because it doesn't depend on the survival projection.

What about gross margin vs gross revenue in the LTV?+

Default is gross revenue. To use gross margin, provide your COGS percentage (or per-plan COGS in a CSV) and tell the chat: "LTV based on gross margin assuming 78% margin." The payback curves automatically use whichever you pick.

Can this handle annual contracts in CAC?+

Yes. An annual prepaid contract still represents one new customer for CAC purposes. The LTV side amortises the annual revenue across 12 months as you'd expect. Both sides of the ratio remain consistent.

Does it work for B2C as well as B2B?+

Yes. The math is the same — cohort LTV, channel CAC, payback. The interesting slices change (B2C: device, geography, demographic; B2B: company size, industry, plan) but the analytical pattern is identical.

Can we share this with investors as a live link?+

Yes. Pin the LTV/CAC dashboard and share the public URL. Investors see the live numbers without an AnalityQa AI account. The dashboard refreshes as new billing and ad-spend data come in.

Related guides

Marketing

Know exactly which channels are earning their budget

Marketing

Stop guessing which ads to cut and which to scale

SaaS / Finance

An MRR forecast you can defend in front of the board

Your data has answers. Start asking.

Upload a file or connect your database. Your first dashboard, in under 5 minutes.

Try AnalityQa AI AI free →

No credit card required

AnalityQa

The all-in-one workspace for data analysts and engineers.

Product

  • Features
  • Pricing
  • Blog
  • Free Tools

Company

  • About
  • Contact

Legal

  • Privacy
  • Terms

© 2026 AnalityQa AI. All rights reserved.

All systems operational