How to Build a Real-Time Enrollment Dashboard That Demonstrates Site Performance to Sponsors

A real-time enrollment dashboard is a single view of current study performance data — enrollment vs. target, screen failure rate, upcoming visit schedule, outstanding queries, and active physician referral pipeline status — that a coordinator can pull up in 30 seconds when a sponsor asks for a status update. Sites that have this view can answer sponsor questions immediately with data. Sites that do not have to open four different systems and compile an answer manually — which takes time, introduces error risk, and signals disorganization to the sponsor.

What the Dashboard Needs to Show

The minimum viable enrollment dashboard for a single study tracks: current enrollment count vs. monthly target, projected enrollment curve vs. actual curve, screen failure rate for the current study period, visit completion rate for active enrolled patients, outstanding database queries by age, and any open protocol deviations. For a site running multiple studies, a portfolio view that shows this data across all active studies in a single table adds significant value for capacity management and sponsor communication.

What Data Sources Feed the Dashboard

The enrollment count comes from the patient tracking system — a CRM or Google Sheet where each patient's current status is maintained. The screen failure rate comes from the pre-screening and screening log. Visit completion data comes from the scheduling system. Query counts come from the EDC, either pulled manually or through an API integration. The dashboard itself can be built in Google Sheets with structured data inputs, a Supabase-backed web dashboard, or a CRM reporting view — the specific tool matters less than the discipline of keeping the underlying data current.

How the Dashboard Changes Sponsor Interactions

A coordinator who opens a dashboard and shares their screen with a sponsor on a performance call is having a fundamentally different conversation than a coordinator who is recalling enrollment numbers from memory. The dashboard signals operational precision. It demonstrates that the site tracks its own performance continuously rather than reactively. And it gives the sponsor the same data visibility they are trying to get from the performance call — which builds the transparency-based trust that produces long-term sponsor relationships.