By Fatskills Exam Guides Team — the exam nerds behind 28,500+ quizzes and 2.1M practice questions across 500+ global exams.
Customer Lifetime Value (LTV) is the total profit you expect to earn from a single customer over the whole time they stay with you. Customer Acquisition Cost (CAC) is what you spend to win that customer in the first place. The LTV ÷ CAC ratio tells you whether you’re making money on each new buyer. Real‑world example: A SaaS company runs a LinkedIn‑ads lead‑gen campaign, spends $1,200 to acquire 10 trial users (CAC = $120 each). Those users stay an average of 18 months, paying $50/mo, so each generates $900 LTV. The LTV/CAC = 7.5 → highly profitable.
=SUMPRODUCT(revenue_range, retention_rate_range)
=SUM(Spend_Range) / COUNTUNIQUE(New_Customers_Range)
=AVERAGE(Revenue_Per_Customer) * (1 / Churn_Rate)
ARPU / Monthly_Churn
LTV / CAC
Mistake: Using total ad spend without filtering out “brand‑only” clicks that don’t drive new customers. Correction: Filter GA4 to only include first‑time users (new_user = true) before attributing spend to CAC.
Mistake: Assuming a single purchase equals the full LTV for one‑time buyers. Correction: For e‑commerce, calculate average order value (AOV) × repeat purchase rate × average purchase frequency, not just the first order.
Mistake: Ignoring churn when estimating LTV for subscriptions. Correction: Use the churn‑based formula LTV = ARPU / Monthly_Churn (or annualized) to capture future revenue loss.
LTV = ARPU / Monthly_Churn
Mistake: Relying on last‑click attribution in GA4, which over‑credits the final touch. Correction: Switch to “Data‑Driven” attribution in GA4 or run a multi‑touch model in BigQuery for a more realistic CAC.
Mistake: Updating CAC but forgetting to refresh the LTV model, leading to stale ratios. Correction: Automate the spreadsheet with daily pulls from your ad platform and CRM (Zapier → Google Sheets) so the ratio is always current.
If your CPC is $2, your conversion rate is 5 %, and the average order value is $80, what is your CAC? Answer: $2 ÷ 0.05 = $40 CAC. (CPC ÷ CVR = cost per acquisition; $40 < $80 LTV → profitable.)
Your SaaS product has an ARPU of $45/mo and a monthly churn of 4 %. What is the LTV? Answer: LTV = $45 / 0.04 = $1,125. (ARPU divided by churn gives the expected revenue over the customer’s lifetime.)
A campaign generated $12,000 in revenue and cost $3,000. What is the ROAS and is it acceptable for an e‑commerce brand? Answer: ROAS = $12,000 / $3,000 = 4 × (400 %). This meets the typical e‑commerce benchmark of ≥ 4×.
Join 4M+ learners. Unlock unlimited quizzes, wrong-answer tracking, flashcards + reminders, study guides, and 1-on-1 challenges.