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.