A waitlist is the clearest demand signal a childcare operator has — and the most wasted. Families wait longest for infant rooms, which are the most ratio-expensive to staff and the slowest to free up, so a long waitlist often means real, committed demand the center can't currently serve. This dashboard turns the waitlist into a capacity decision: where is demand stacking up, how committed is it, and which age group and site justify opening a new room.
What this dashboard answers
How many families are waiting, how many have paid a deposit, and how long have they waited? Which age groups and sites have the most pressure — the most waitlisted families per open seat? And what share of the waitlist actually converts to enrolled when a seat opens? The demand page shows active and deposit-paid counts, conversion, and active-waitlist-against-open-seats by site. The wait-time page surfaces average wait days by age group and the demand-pressure index that ranks where to expand.
The metrics that matter
Active waitlist count is raw demand; deposit-paid count is committed demand — families with money down are the ones who'll actually take a seat. Wait days measures how long that demand has been ignored, longest for infants. The demand pressure index — waitlisted families per open seat by age group — is the open-a-room number: a high index in infant rooms at one site is a concrete expansion case. Conversion rate keeps it honest, because a waitlist that never converts is a stale list, not demand.
Why the data is trapped
Waitlists live in a childcare CRM like LineLeader or in Procare, Kangarootime, or Famly — but per-center, and rarely cross-tabbed against open seats by age group. The single most useful view, waitlisted families per available seat across the portfolio, requires joining the waitlist to live capacity from the enrollment system, age group by age group, site by site. No built-in report does that join, so the expansion decision gets made on gut feel instead of pressure.
How to read it
Lead with the demand pressure index: the age group and site with the most waitlisted families per open seat is your strongest case to open a room. Confirm it with deposit-paid count — committed demand, not just names on a list — and with wait days, since families who've waited months will leave if ignored. A high active count with low conversion means the list is stale and should be re-contacted before it's treated as demand. The sample uses fully synthetic, anonymized data — no real family information.
Metrics it tracks
| Metric | What it means |
|---|---|
| Active Waitlist Count | Families currently on a waitlist across all centers. |
| Deposit-Paid Waitlist Count | Committed families holding a deposit — the high-intent share of the waitlist. |
| Total Waitlist Wait Days | Total days families have waited, paired with the active count for an average. |
| Waitlist Converted to Enrolled | Families who enrolled off the waitlist. |
| Waitlist Conversion Rate | Converted ÷ total waitlisted — the share of waitlisted families who enrolled. |
| Demand Pressure Index | Active waitlist ÷ open seats by age group — waitlisted families per available seat. |
Used by: Center directors and franchise-area developers planning capacity
Frequently asked questions
What is a childcare demand-pressure index?
It's the number of waitlisted families divided by open seats for an age group at a site — waitlisted families per available seat. A high index (many families, few seats) for, say, infant rooms at one center is a concrete, data-backed case for adding capacity or opening a new room there.
Why are infant waitlists usually the longest?
Infant rooms carry the tightest staff-to-child ratios (often 1:4), so they have the fewest seats and are the most expensive to staff, and seats free up slowly. That combination produces the longest waits — which is why weighting the report toward infants and tracking wait days by age group matters.
Can I build this on my own waitlist data?
Yes. Export your waitlist with age group, wait dates, and deposit status from LineLeader, Procare, Kangarootime, or Famly 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 →