Skip to main content
All Questions

Find Customer Lifetime Value (LTV)

Medium
Unlock detailed company stats for this questionUpgrade

You are given the following tables:

attribution table:

session_idmarketing_channelpurchase_value
stringstringfloat

user_sessions table:

session_idad_click_timestampuser_id
stringdatetimestring

Find the customer lifetime value (LTV) for each user and order the results from most valuable customer to least valuable. Your output should contain the following columns: user_id, LTV

Related questions

Design an MVP for Booking's homepage to improve customer lifetime value.Find Top Customer by YearDesign a lifetime value (LTV) prediction system.

Related courses

Course

Data Analyst Interview Prep

Ace your data analyst interviews—whether you're targeting product, marketing, or business analyst roles. Tackle real take-home case studies, sharpen your technical and dashboarding skills, and get strategies from interviewers at top tech companies and startups.

Course

Data Science Interview Prep

Land your dream data science role at Google, Amazon, Microsoft, Meta, Apple, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.