Museum Operations Hub

What this app does

Museum Operations Hub gives cultural venue teams a single app to replace scattered spreadsheets and email threads. Staff get a polished command center with real-time KPIs, an attendance trend chart, under-discovered exhibit highlights, and upcoming programs — all on the first screen.

Key features

Exhibits catalog with engagement metrics

Browse and filter the full collection. Each exhibit card shows visitor views, average engagement time, and a discovery score that flags exhibits the public isn't finding yet — so your team can act before interest drops further.

AI-powered program recommendation

On any exhibit's detail page, staff can request an AI recommendation: the system reads the exhibit's category, period, audience engagement data, and the current upcoming program schedule, then returns a recommended program pairing (or a new program concept) with title, target audience, best timing, a rationale, and three concrete next steps. If the venue's AI credits run low, a plain-English message explains how to top them up from the Glide dashboard.

Programs board with capacity and fill tracking

A board view of all upcoming, full, and past programs — each card shows registrations vs. capacity as a color-coded progress bar so overbooking and under-subscribed programs are immediately obvious. Create or edit programs with a guided form covering type, timing, location, lead staff, audience, and pricing.

School & Group Visits queue

A filterable queue of confirmed, checked-in, and completed group visits. Each visit record captures chaperone ratios, accessibility requirements, room needs, assigned guide, and internal notes. Staff can check in a group with one tap, mark a visit completed, and flag follow-up as sent — creating a clean audit trail for every school and community visit.

Visitors & Attendance analytics

Month-by-month bar charts break down visitor types (general, members, groups, events). A daily line chart lets staff drill into any single month. Mobile-responsive cards show daily totals for teams checking figures on-the-go.

Reports

A summary view of total visitors, average program fill rate, total registrations, and visitor rating — alongside ranked lists of programs by fill rate and exhibits by engagement, for at-a-glance operational reporting.

How the AI workflow operates

1. A staff member opens an exhibit's detail page and taps Generate Recommendation in the AI Recommend tab.
2. The app sends the exhibit's title, category, description, period, and engagement stats to a server-side route — never exposing credentials to the browser.
3. The server checks AI credit availability before calling the model. If credits are exhausted, it returns a clear 402 message directing staff to the Glide dashboard to buy extra credits or upgrade the plan.
4. If credits are available, the route calls Claude Sonnet with a structured system prompt that instructs the model to return a JSON object containing: program title, audience, timing, rationale, and next_steps (an array of three action strings).
5. The server parses the JSON and returns it to the client. The recommendation renders as a structured card with labeled sections — not raw text.
6. Staff can click Create This Program to navigate directly to the program creation form, pre-filled with the context they need.

Data model

The app ships with seeded data: 24 exhibits spanning 20 categories, 24 programs from May through August 2026, 24 group visits including school, university, corporate, and community groups, 12 staff members, 15 feedback entries with ratings and comments, daily attendance records from 2026-05-18 through 2026-07-17 (with July showing peak summer traffic), and 24 exhibit relationship links.

All data is generic — no named museum, city, or institution appears — making this template immediately adaptable to any cultural venue.