SoFiMediumMetrics00:00

Welcome to your interview for the Data Scientist role at SoFi.
The question is on your right: Calculate LTV for New SoFi Invest Members. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen. You have three graded attempts to score 7/10 or better.
SoFi Invest, a leading investment platform, aims to enhance its customer acquisition strategy by understanding the lifetime value (LTV) of new members. Recently, marketing campaigns have successfully increased new user sign-ups by 30%, but the company needs to assess the financial impact of these new members over time.
| Data Source | Description | Granularity |
|---|---|---|
| user_profiles | Member demographics including sign-up date, referral source, and account type | Per user |
| transaction_history | Records of all trades and investment actions taken by users | Per transaction |
| revenue_data | Revenue generated from fees, commissions, and interest from investments | Monthly per user |
| engagement_metrics | User activity data, including login frequency and feature usage | Daily per user |