←BaldanAll skillsLet's talk
← Dashboards · 04 Customer analytics

Who is leaving, and why?

A retention team's dashboard on the IBM Telco sample: where churn concentrates, how long customers stay, what goes with leaving, and what an offer might change. Filter or click to dig in.

7,043 of 7,043 customers · IDs, gender and age left out

Customers

7,043

of 7,043

Left last month

1,869

churned

Churn rate

26.5%

overall 26.5%

Monthly revenue lost

$139.1k

31% of this group's bills

Tenure, left vs stayed

18 vs 38

months, average

Bill, left vs stayed

$74 vs $61

per month, average

How long customers stay · by contract

Kaplan–Meier survival: the share still a customer after each month, from tenure and who left

0%25%50%75%100%0122436486072Month-to-month: 70% still here after 12 months, 13% after 72One year: 99% still here after 12 months, 57% after 72Two year: 100% still here after 12 months, 94% after 72months as a customer →

What goes with leaving

Churn rate for each value of each feature, features with the biggest gaps first; dot size = customers. Click contract, internet or payment to filter.

0%20%40%60%Contractgap 40 ptsMonth-to-month: 43% of 3,875 leftMonth-to-month 43%One year: 11% of 1,473 leftTwo year: 3% of 1,695 leftTwo year 3%Internet Servicegap 34 ptsDSL: 19% of 2,421 leftFiber optic: 42% of 3,096 leftFiber optic 42%No: 7% of 1,526 leftNo 7%Online Securitygap 34 ptsNo: 42% of 3,498 leftNo 42%Yes: 15% of 2,019 leftNo internet: 7% of 1,526 leftNo internet 7%Tech Supportgap 34 ptsNo: 42% of 3,473 leftNo 42%Yes: 15% of 2,044 leftNo internet: 7% of 1,526 leftNo internet 7%Online Backupgap 33 ptsNo: 40% of 3,088 leftNo 40%Yes: 22% of 2,429 leftNo internet: 7% of 1,526 leftNo internet 7%Device Protectiongap 32 ptsNo: 39% of 3,095 leftNo 39%Yes: 23% of 2,422 leftNo internet: 7% of 1,526 leftNo internet 7%Payment Methodgap 30 ptsElectronic check: 45% of 2,365 leftElectronic check 45%Mailed check: 19% of 1,612 leftBank transfer: 17% of 1,544 leftCredit card: 15% of 1,522 leftCredit card 15%Streaming Moviesgap 26 ptsNo: 34% of 2,785 leftNo 34%Yes: 30% of 2,732 leftNo internet: 7% of 1,526 leftNo internet 7%Streaming TVgap 26 ptsNo: 34% of 2,810 leftNo 34%Yes: 30% of 2,707 leftNo internet: 7% of 1,526 leftNo internet 7%

Where churn concentrates

Churn rate by contract and tenure; customers in each cell. Click a cell to filter.

0–1213–2425–4849–72
Month-to-month
One year
Two year

Monthly bill

Share of stayers (grey) and leavers (red) at each bill level

$18$38$58$79$99monthly bill →

Revenue walking out

Monthly bills of customers who left, by contract and internet

Month-to-month · Fiber optic$100.5k
Month-to-month · DSL$18.4k
One year · Fiber optic$10.6k
One year · DSL$3.4k
Two year · Fiber optic$3.2k
Month-to-month · No$2.0k

Top cell: 72% of all lost monthly revenue.

Highest-risk segments

Combinations of contract, internet, payment and tenure with 40+ customers, by churn rate. Groups, never individuals.

ContractInternetPaymentTenureCustomersChurnLost / month
Month-to-monthFiber opticBank transfer0–12 months8782%$6.0k
Month-to-monthFiber opticElectronic check0–12 months63171%$37.2k
Month-to-monthFiber opticMailed check0–12 months12363%$6.2k
Month-to-monthFiber opticCredit card0–12 months7561%$3.9k
Month-to-monthFiber opticElectronic check13–24 months25559%$13.4k
Month-to-monthDSLElectronic check0–12 months28250%$6.3k
Month-to-monthFiber opticElectronic check25–48 months28649%$12.9k
Month-to-monthFiber opticCredit card13–24 months6245%$2.5k

What if we act?

The Telco project's logistic regression (ROC AUC 0.8347). Age is held fixed and never asked.

Chance this customer leaves

74%

Offer a one-year contract

74% → 57% (-17 pts)

Move them to automatic card payment

74% → 66% (-8 pts)

Add tech support

74% → 65% (-9 pts)

Add online security

74% → 63% (-11 pts)

A model of association, not a promise: offers can change who stays for other reasons too.

What the churn says

Written from the same numbers as the tiles, for the current filters

  • 26.5% of these 7,043 customers left last month, taking $139.1k of monthly bills with them (31%).
  • The biggest gap is contract: Month-to-month churns at 43%, Two year at 3%.
  • After a year, 70% of month-to-month customers are still here, against 100% on two-year contracts.
  • Leavers had been customers for 18 months on average (stayers 38) and paid more: $74 vs $61 a month.
  • Riskiest group: month-to-month, fiber optic, paying by bank transfer, 0–12 months: 82% of 87 left.

Behind the dashboard

The data

IBM Telco Customer Churn (sample data, fictional customers): 7,043 customers of a telecom company, with their services, contract, billing, tenure and whether they left within the last month.

What's left out

Customer IDs, gender, age (senior citizen) and household fields (partner, dependents) are dropped before the data reaches this page. Everything shown is something the company can act on.

Churn rate

Customers who left ÷ customers in the group. Revenue lost = their monthly bills.

Survival curves

Kaplan–Meier: each month, the share of customers still at risk who did not leave, multiplied up. Customers who stayed count until their current tenure.

What-if

The logistic regression from the Telco churn ML project, run in the browser. It shows association, not cause.

How the model was chosen and tested: Telco churn project.