Hire Kwame Mensah, Data Analyst

- Current: 1 · Describe
- 2 · Pay
- 3 · Questions
- 4 · Delivery
- 5 · Rate
Step 1: Describe your job
- Answer one question from a CSVYou get: The answer to one question from your data, with the numbers behind it · ⏱ 2 hrs$50
- Total, fixed$50
The length of your brief never changes the price. Only the packages above do, and each one is listed.
Total $50
- • Answer one question from a CSV: $50
- One question answered from one dataset
- 2 revisions included
- Size limit: up to 100,000 rows
- Counts as a separate task: a second question, or an ongoing dashboard
🚫 Can't log into your analytics or Shopify. Send an export (CSV).
Example deliverable: Why did subscription churn jump in Q2?
Example of work, not a client review scenario: Founder of a subscription snack-box company · what a finished job from Kwame looks like · turnaround 2 hrs
Package: Answer one question from a CSV · $50 · 2 hrs
Short answer: churn is mostly the March cohort. About 80% sure.
THE QUESTION
Why did monthly churn go from 7% to 11% in Q2?
THE ONE CHART
Chart title: "Q2 cancellations by signup month: is it everyone, or one group?"
A bar chart, signup month on the x axis, cancellation rate in their second month on the y axis.
| Signup month | Subscribers | Cancelled by month 2 |
|---|---|---|
| January | 1,210 | 14% |
| February | 1,090 | 15% |
| March | 2,880 | 38% |
| April | 1,150 | 16% |
- Signup month
- January
- Subscribers
- 1,210
- Cancelled by month 2
- 14%
- Signup month
- February
- Subscribers
- 1,090
- Cancelled by month 2
- 15%
- Signup month
- March
- Subscribers
- 2,880
- Cancelled by month 2
- 38%
- Signup month
- April
- Subscribers
- 1,150
- Cancelled by month 2
- 16%
March is the outlier. Everything else is normal.
WHY MARCH
March signups were 2.5 times normal. 71% of them used the code SNACK50, which gave 50% off the first box. People who used SNACK50 cancelled at 44%. March signups without it cancelled at 17%, close to normal.
So it's not the product. It's who the discount brought in.
THE CHECKS I RAN
- Did box contents change in Q2? One snack was swapped. Cancellations didn't rise after the swap date. Ruled out.
- Did the price change? No.
- Did shipping get slower? Average delivery went up by 0.3 days. Too small to explain this.
HOW SURE I AM
About 80%. The 20% is that I can't see why people cancelled. If you have cancel-reason survey answers, send them and I'll confirm.
WHAT TO DO
Stop treating 11% as your real churn. Without the March SNACK50 group, Q2 churn is 7.6%. If you run SNACK50 again, cap it or pair it with a 3-month commitment.
Data's yours. — Kwame