I will do customer cohort retention, rfm segmentation and churn analysis
Data Analyst and Business Analyst, SQL, Python, Power BI
About this Gig
Find out which customers come back, which ones you are losing, and where to focus your marketing budget.
Using your order data, I build monthly cohort retention curves, segment customers by recency, frequency and monetary value (RFM) and, in Premium, estimate lifetime value per segment and the main drivers of churn. Every analysis ends with plain-language recommendations, not just charts.
You get:
- A short report with the key findings up front
- A customer segment list (CSV) you can upload to your email or ads tool
- The Python and SQL code, so the analysis can be repeated next quarter
Before the analysis I clean the data (test orders, refunds, duplicates) and reconcile totals with your source, so the numbers match your shop.
Background: behavioral segmentation and churn analysis in Python at Foundry, 10+ years in data and business analysis.
The images show a case study built on synthetic data.
FAQ
Which platforms do you work with?
Any export with customer ID, order date and order value: Shopify, WooCommerce, a CRM or a SQL database.
Do you need personal data?
No. Anonymized customer IDs are enough; please remove names and emails.
How much history do I need?
12 months or more is ideal, 6 months is the minimum for useful cohorts.
Will you keep my data?
No. I work on your export only for this order and delete it after delivery.

