Clinical Trial Enrollment Tracking Template: What to Log and Why

Most sites start enrollment tracking with a shared spreadsheet, or whatever the last coordinator built before handing off the role. That works fine until a sponsor asks for a screen fail rate broken out by referral source, or a new coordinator inherits a tracker nobody can fully explain.

A fixed set of fields, updated the same way every time, closes both gaps before they surface in a monitoring visit. Below is the field list, a copy-ready template, and how the log turns into the metrics sponsors already expect to see.

Why an Ad Hoc Spreadsheet Runs Out of Room

A tracker that grows organically tends to drift. One coordinator adds a column for a sponsor request. Another abandons a field nobody uses anymore. Eighteen months in, the spreadsheet can answer some questions well and others not at all, and the gaps are rarely the ones you expect until a monitoring visit exposes them.

None of this reflects poorly on the coordinator who built it. A tracker built under deadline pressure, one screening event at a time, is going to look different from one designed up front with the end reports in mind. The fix is not a better spreadsheet author. It is a fixed structure that does not depend on any one person remembering what a column means.

The Fields Worth a Column

Eight fields cover almost everything a site or a sponsor will ask for later. Fewer than that and a monitoring visit surfaces a question the log cannot answer. More than that and coordinators start skipping fields under time pressure, which defeats the point.

A Template You Can Copy Today

Copy the structure below into a spreadsheet or your CTMS. The two rows underneath the header are illustrative, not real patient data, and show how a completed row should read.

A screen fail row still earns a full entry. It is what makes the screen fail rate calculation possible in the first place.

Update Cadence and Ownership

Update the log at the event, not in a weekly batch. A screening logged the same day is accurate. A week of screenings reconstructed from memory on a Friday afternoon is not, and the gaps tend to land in exactly the fields that matter most.

One person owns the log. Not because only one person is capable of updating it, but because a shared file with no clear owner is how fields quietly stop getting filled in. The coordinator who owns it does not have to be the one entering every row, just the one who notices when a row goes missing.

From Log to the Numbers Sponsors Ask For

The eight fields above are not just a record. They are the raw material for the metrics sponsors already track on their end: enrollment rate against target, cumulative screen fail rate, and time from activation to first randomization. A site keeping this log has those numbers on hand before a monitoring visit asks for them, not after.

The full breakdown of which metrics matter, how often to review them, and where the thresholds sit is in the site performance metrics guide. For sites specifically working on the screen fail number this log tracks, see reducing screen fail rates.

Where Tracking Habits Slip

The log usually breaks down in three predictable places, and none of them are about a site being careless. Time pressure at the point of screening pushes data entry to later, and later never quite arrives. A patient's record lives across paper, an EDC system, and a sponsor portal, and the site's own log is the one nobody is required to keep current. A coordinator who built the tracker leaves, and the next person inherits a structure they were never shown.

All three are what happens when a tracking system depends on one person's memory instead of a fixed structure everyone uses the same way. A copy-ready template does not fix time pressure or turnover on its own, but it removes the guesswork about what a column means for whoever picks it up next.

Two studies from the Clinical Enroll portfolio show what consistent tracking supports on the enrollment side, even under a narrow protocol: