Evaluate Stripe Capital Loan Performance
StripeData Analyst · Technical ScreenLast updated
This question evaluates a data analyst's competency in product analytics, metric design, cohort and segment analysis, and causal inference for a working-capital loan product.
You are a Data Analyst on the go-to-market analytics team for a payment platform similar to Stripe.
The company offers working-capital loans to merchants. A merchant receives cash up front, and repayment is automatically deducted as a percentage of the merchant's future payment-processing volume until principal plus interest or a fixed fee is repaid.
Answer the following:
- What metrics would you define to monitor whether this loan product is performing well?
- Suppose total revenue from the loan product has declined over the last quarter. How would you investigate the root cause?
- What segmentations, data checks, and causal analyses would you use to distinguish between product, risk, pricing, merchant-mix, and macroeconomic explanations?
- What recommendations might you make depending on the root cause?
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.