← All briefs
OperationsLow Privacy

Facility Utilization Heatmap

Room-by-room, hour-by-hour utilization with a cost-per-hour overlay. Reframe 'we need more space.'

Room-by-room, hour-by-hour utilization with a cost-per-hour overlay. Reframe "we need more space" into "we need different scheduling."

CategoryOperations
Church-health domainOperations & Governance
Data-privacy tierLow — room names, times, event titles (strip sensitive titles)
Mastery-ladder targetLevel 4 · Context
Build stackGoogle Calendar API + Planning Center Calendar API → room×hour grid + cost overlay

The problem

Church buildings are among the most under-used real estate. Tim Cool of Smart Church Solutions puts it bluntly: "Next to the NFL, churches are the worst user of real estate… built to be underutilized." A widely cited figure is that about 75% of churches use their facilities only ~25–30% of a typical week. The building is the largest line item after staff, yet most rooms sit empty most of the week — and the instinctive response to a crunch is "we need to build," when the real answer is often "we need to schedule differently."

What good looks like

A room-by-room, hour-by-hour heatmap built from Google Calendar + Planning Center bookings, with a cost-per-hour overlay (allocate mortgage + utilities + cleaning per room), flagging rooms idle 90%+ of the week. The output reframes the conversation in dollars: "Room B is used 6% of available hours at $X per used hour — consolidate or repurpose."

Market scan

ToolFitPricing (verify)
Planning Center CalendarRoom/resource scheduling; booking-centric reportingÀ-la-carte
SkeddaSpace-booking software$249–349/mo
FMXFacilities + scheduling + work ordersQuote-based ~$20–100/user/mo
eSPACE (Smart Church Solutions)Church event scheduler + facility stewardship~$60/mo to custom
ConnecteamStaff scheduling/ops (adjacent)Free up to 10; $29–35/mo for 30

The gap: these tools book rooms; none natively shows a utilization heatmap with a cost-per-hour overlay that converts idle space into dollars and auto-flags under-used rooms. That financial framing — tying empty rooms to allocated facility cost — is the DIY differentiator.

Data privacy & security

  • Lowest-sensitivity build in the set: room names, times, event titles. No giving data.
  • Watch one thing: event titles can reveal sensitive groups (recovery, counseling). Strip or aggregate titles to room-level usage before display or any LLM use.
  • Standard auth still applies.

How to build it

  1. Read bookings via the Google Calendar API and the Planning Center Calendar API.
  2. Normalize to a room × hour grid.
  3. Enter a per-room cost basis (square-foot share of annual facility cost ÷ available hours).
  4. Render the heatmap (hours × rooms).
  5. Compute utilization % and cost-per-used-hour; flag rooms under a threshold.
  6. Add an AI-written recommendation line per under-used room (on stripped, room-level data only).

Rollout plan

  • Q1: Get all room bookings into Planning Center Calendar (or a single calendar). Pull four weeks of data.
  • Q2: Build the heatmap and enter the cost basis.
  • Q3: Take the cost-per-used-hour findings to the budget/facilities conversation.

Effort & cost

  • Build: ~20–35 hours — the smallest build in the set; the grid and cost math are straightforward, the heatmap viz is the main UI work.
  • Run: under ~$30/mo; the Google Calendar API is free.

Sources

  • Smart Church Solutions (facility stewardship) — https://www.smartchurchsolutions.com/resources/blog/underutilized-technology-is-poor-stewardship/
  • Church facility utilization — https://www.religiousproductnews.com/church-facilities-designing-multipurpose-spaces-for-worship-community-beyond/
  • Skedda pricing — https://www.skedda.com/pricing
  • FMX (religious) — https://www.gofmx.com/solutions/industries/religious/
  • eSPACE — https://www.smartchurchsolutions.com/

Honesty flag: the precise "~10–30%" eSPACE-attributed utilization percentage is unverified; the "worst user of real estate" framing and the ~25–30% figure are the citable versions.