Filling a seat is expensive; keeping it filled is cheap — which makes retention one of the most leveraged numbers in a childcare business. A family that withdraws doesn't just cost this month's tuition; it costs the whole runway of years that child would have stayed, plus the marketing and tour effort to replace them. This dashboard separates the withdrawals a center could have prevented from the ones it couldn't, and puts a dollar figure on what's leaving.
What this dashboard answers
What's our withdrawal rate, and how does it vary by center? Why are families leaving — relocation, cost, schedule, dissatisfaction, graduation? When in their tenure do they leave, and how much annual tuition does it represent? The attrition page shows active families, withdrawals, withdrawal and retention rates by site, and withdrawals by reason. The avoidable-loss page isolates avoidable withdrawals and lost annual tuition, shows churn by tenure band, and matrixes withdrawals and retention by site and age group.
The metrics that matter
Retention rate is the headline, but the insight is in the breakdown. Avoidable withdrawals — families leaving for cost, schedule, or dissatisfaction rather than a move or graduation — are the ones a center can actually act on; separating them from unavoidable losses tells you where intervention is worth it. Tenure band matters because early-tenure churn (families leaving in the first six months) usually signals an onboarding or fit problem, not an unavoidable life change. Lost annual tuition translates all of it into the dollars that make retention a budget priority.
Why the data is trapped
Withdrawal dates and reasons live in the enrollment record in Procare, Brightwheel, or HiMama/Lillio — but withdrawal reasons are often a free-text note, tenure has to be computed from enrollment dates, and the annual tuition of a departed family sits in billing. Tying reason to tenure to lost revenue, across centers, is a manual reconstruction. So most operators know their withdrawal count but not which losses were avoidable or what they cost — the analysis that would actually change behavior never gets built.
How to read it
Read avoidable withdrawals first — that's the actionable slice. A cluster of cost or schedule withdrawals at one center is a pricing or hours conversation; dissatisfaction withdrawals are a quality conversation. Then read churn by tenure band: heavy 0–6-month churn points to onboarding and early-experience fixes that pay off fast. Lost annual tuition ranks where the money is, so the biggest dollar leaks get attention first. The sample uses fully synthetic, anonymized family data — no real records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Active Families (Start) | Families enrolled at the start of the period — the retention denominator. |
| Withdrawals | Families who left during the period. |
| Withdrawal (Attrition) Rate | Withdrawals ÷ active families at start — the share of families who left. |
| Retention Rate | Retained ÷ active families at start — the share of families who stayed. |
| Avoidable Withdrawals | Withdrawals for cost, schedule, or dissatisfaction — the ones a center can influence. |
| Lost Annual Tuition | Annualized tuition for withdrawn families — the revenue walking out the door. |
Used by: Owner/operators and center directors
Frequently asked questions
What's the difference between avoidable and unavoidable withdrawals?
Unavoidable withdrawals are life events a center can't change — a family relocating, or a child graduating to Kindergarten. Avoidable withdrawals leave for reasons a center can influence: cost, schedule/hours, or dissatisfaction. Separating them tells you which churn is worth intervening on, instead of treating all departures the same.
Why does early-tenure churn matter most?
Families who withdraw in their first six months usually signal an onboarding, communication, or fit problem rather than an unavoidable life change — and they leave before the center recoups the cost of enrolling them. High 0–6-month churn is one of the most fixable and highest-payoff retention problems, which is why the report breaks withdrawal rate out by tenure band.
Can I build this on my own retention data?
Yes. Export enrollment and withdrawal dates with reasons and tuition rates from Procare, Brightwheel, or HiMama/Lillio and use this as a template — we model it into a Power BI report. The sample uses synthetic data, so there's no real family information here.
Build this report on your own data
Clone this Childcare centers template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →