Most site directors know their current enrollment count. Very few can tell you their inquiry-to-enroll conversion rate, their weekly inquiry trend, or their projected enrollment date based on current pipeline. The difference between a site that manages enrollment and a site that reacts to it is the dashboard. Here is what to track, how to calculate it, and what thresholds trigger action.
Your 5 Leading Indicators (Tracked Weekly)
Enrollment count is a lagging metric. These five indicators tell you what enrollment will be in 30–60 days:
- Weekly inquiry volume: Total new patient inquiries received. Trend matters more than absolute number — two consecutive weeks of 20%+ decline requires immediate ad review.
- Pre-screen pass rate (rolling 4-week average): Calculate weekly to spot targeting drift. If your 4-week average drops below 20%, your ads are reaching unqualified audiences.
- Show rate (rolling 4-week average): Below 55% for two consecutive weeks triggers a reminder sequence audit.
- Screen-to-enroll rate (rolling 4-week average): A sudden drop here — more than 10 percentage points from your baseline — signals a protocol eligibility issue to discuss with the PI.
- Active pipeline count: Number of patients currently in pre-screen or scheduling stages. This is your 2-week enrollment forecast. Multiply by show rate and screen-to-enroll rate to project upcoming enrollments.
How to Calculate Your Enrollment Rate Correctly
Basic rate: total enrolled ÷ months of active recruitment = monthly rate. Adjusted rate (more accurate): exclude the first 3-week ramp-up period from your calculation. For a trial that activated 10 weeks ago and has enrolled 12 patients, your adjusted rate uses 7 weeks (10 minus 3): 12 ÷ 1.75 months = 6.9 patients/month. Using 10 weeks would produce 4.8/month — a significant underestimate of your actual sustainable rate. Use the adjusted rate for all sponsor projections.
The Friday 20-Minute Review
Every Friday, spend 20 minutes on these five steps: (1) Update your pipeline spreadsheet with the week’s data. (2) Calculate week-over-week change in inquiry volume. (3) Calculate rolling 4-week averages for pass rate and show rate. (4) Update active pipeline count. (5) Recalculate projected enrollment completion date. If any metric crosses a threshold (below), assign a specific corrective action to a specific person before end of day Friday — not “we’ll look into it next week.”
Action Thresholds — What Triggers Intervention
- Inquiry volume declines 25%+ week-over-week: check ad account status, budgets, and scheduling conflicts
- Pre-screen pass rate below 20% for 2 consecutive weeks: review ad targeting settings
- Show rate below 55% for 2 consecutive weeks: add or fix appointment reminders
- Active pipeline below 5 qualified patients: increase ad budget 20% and send referral update to physicians
- Projected enrollment date moves beyond agreed timeline: notify sponsor within 48 hours with recovery plan
Build Your Dashboard This Week
- Add 5 columns to your pipeline tracker: Week, Inquiries, Pass Rate, Show Rate, Pipeline Count
- Backfill the last 4 weeks of data from your existing records
- Calculate your adjusted monthly enrollment rate
- Set Friday 20-minute calendar block as a recurring weekly meeting with yourself
- Define your action thresholds and assign standing responsibility for each corrective action
