PayPal
Analytics Reporting Track · Medium · 25 min
First Purchase Revenue by Signup Month
Revenue planning wants to understand how much first-time purchase revenue is coming from each merchant signup cohort. Return signup_month and the total value...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a PayPal-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
Revenue planning wants to understand how much first-time purchase revenue is coming from each merchant signup cohort. Return signup_month and the total value of each merchant's first purchase, rounded to two decimals. Sort by signup_month.
merchant_signups
| merchant_id | signup_date |
|---|---|
| 1 | 2024-01-05 |
| 2 | 2024-01-21 |
| 3 | 2024-02-10 |
| 4 | 2024-02-25 |
merchant_purchases
| purchase_id | merchant_id | purchase_date | amount | 2 |
|---|---|---|---|---|
| 101 | 1 | 2024-01-12 | 200.00 | |
| 102 | 1 | 2024-02-01 | 250.00 | |
| 103 | 2 | 2024-02-03 | 180.00 | |
| 104 | 3 | 2024-02-16 | 300.00 | |
| 105 | 4 | 2024-03-01 | 90.00 | |
| 106 | 4 | 2024-03-07 | 150.00 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.