There are two types of enrollment reports a site can give a sponsor. The first: “We have enrolled 12 patients.” The second: “We have enrolled 12 patients. Our current pipeline contains 8 pre-screened, qualified patients with appointments scheduled in the next two weeks. Based on our current 62% show rate and 58% screen-to-enroll rate, we project 4–5 additional enrollments in the next 14 days, reaching target enrollment by [date].” The second report demonstrates operational control. Sites that report this way get preferred access to future studies. Here is the exact format and the data system behind it.
The 7 Metrics Every Enrollment Report Must Include
- Enrolled to date — against target and against timeline
- Current inquiry volume — inquiries received this month vs. same period last month
- Pre-screen pass rate — percentage of inquiries advancing to pre-screen pass
- Appointment show rate — percentage of scheduled appointments attended
- Screen-to-enroll rate — percentage of screened patients who enrolled
- Active pipeline count — patients currently pre-screened and in the scheduling/screening process
- Projected enrollment date — based on current rate and active pipeline
The Enrollment Projection Formula
Use this formula to build a defensible projection: Active pipeline × show rate × screen-to-enroll rate = projected additional enrollments from current pipeline. Then: remaining slots needed ÷ current monthly enrollment rate = months to target. Example: 20 patients in pre-screen/scheduled pipeline. 65% show rate. 55% screen-to-enroll rate. Projected: 20 × 0.65 × 0.55 = 7.2 additional enrollments from current pipeline. If target is 30 patients and 12 are enrolled, 18 more are needed. 7 from pipeline, 11 from future inquiries. At current rate of 4/month, 2.75 more months to target. Present this as: “Projected target enrollment: [date], assuming current inquiry volume is maintained.”
What to Say When You’re Behind
Do not wait for a sponsor call to disclose that enrollment is behind. Report it proactively with a recovery plan: “As of [date], we are tracking 2 patients behind our original projection. We have identified the cause: [specific cause — e.g., pre-screen pass rate dropped from 35% to 22% following an ad targeting change on [date]]. Corrective action taken: [specific action]. Expected impact: [specific projection adjustment]. Next review point: [date].” Proactive, specific, and with an action already taken is the difference between a site that maintains sponsor confidence when behind and a site that loses it.
Build the Reporting Infrastructure This Week
The 7-metric report requires pipeline data. If you are not tracking all 7 metrics currently, build the tracking spreadsheet today: one row per patient, columns for each funnel stage with dates. The report then pulls directly from this data — no manual assembly needed. Review the spreadsheet every Friday. Generate the sponsor report monthly or at whatever frequency your contract requires, pulling directly from Friday’s data snapshot.
Report Format Template
[Site Name] — Enrollment Status Report — [Date]
Enrolled: X of Y target (Z% complete)
Monthly inquiry volume: X (vs. X last month)
Pre-screen pass rate: X% (benchmark: 25–45%)
Show rate: X% (benchmark: 55–75%)
Screen-to-enroll rate: X% (benchmark: 40–65%)
Active pipeline: X patients in pre-screen/scheduling
Projected target completion: [date]
Risks or variances: [specific issue and corrective action if any]
Next report: [date]
Action Plan
- Build the 9-column pipeline tracking spreadsheet if not already in place
- Backfill data for the current trial going back to activation date
- Calculate your 5 conversion rates from the existing data
- Build the report template using the format above
- Share the first version with your sponsor contact before they ask for it