Why do 93% of e-commerce customers never return after their first order? I spent weeks inside 100,000 real transactions to find out.
Every e-commerce company talks about customer acquisition. The real money is in the second purchase — and 93% of customers on Olist's platform never made one.
That's not a marketing problem. It's a data problem. And data problems need data solutions. I built this platform to find the root cause — and predict who's going to leave before they do.
Dataset: Olist Brazilian E-Commerce · 99,441 real orders · 2016–2018
raw and analytics. Batch-insert pipeline loads all 99K rows with full logging and error handling.Any data scientist should immediately be suspicious of near-perfect metrics on a real-world dataset. I was.
The diagnosis: recency_days was both defining the churn label (recency > 180 = churned) AND used as a feature. The model was memorising a threshold, not learning customer behaviour.
The fix wasn't a hyperparameter tweak. It required rethinking the entire ML frame — new label definition, new feature set, rebuilt from scratch. That's what real data science looks like.
freight_value is the #1 churn predictor — not delivery speed, not review score. Customers who pay disproportionately high freight relative to order value never come back.
This is "surprise cost shock" — the customer feels deceived. The product was R$50, the delivery was R$25. They don't complain. They just don't return.
Business implication: A free-shipping threshold above R$150 would directly attack the #1 churn driver — no loyalty programme needed.