I will do customer cohort retention, rfm segmentation and churn analysis

Germany

I speak Spanish, English, German

Data Analyst and Business Analyst, SQL, Python, Power BI

I'm a data and business analyst based in Berlin with 10+ years in banking, automotive e-commerce (Auto1 Group), marketing analytics and insurance. I turn messy data into clear answers: Looker Studio a...
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.

Technology:

Excel

•

Google Sheets

•

Jupyter Notebook

•

Power BI

•

Tableau

Analysis type:

Quantitative analysis

•

Descriptive analysis

Expertise:

Business Insights

•

Churn & retention

•

Statistics

Programming language:

Python

•

SQL