← Workflow report completeness calculator
Workflow data collection plan for agency teams
Before a team measures a workflow change, agree on what to count and how the information will be collected. This planner turns a measure into a repeatable collection process that staff can test together.
1. Define the measure
State the question the team needs to answer and define the event in observable terms. For a percentage, write the numerator and denominator, eligibility rules, period and unit. Agree how to handle exclusions, unknown answers and zero denominators.
2. Plan collection
Identify the source, who collects and checks the information, when and how often, and how it will be recorded. Count eligible opportunities independently of reports where possible. Use existing information if it answers the question and minimize collection burden. Decide whether to collect every eligible event or a sample; document the selection method, coverage and limitations. Agree what is considered late or missing and how duplicate or conflicting reports will be reconciled. Use the minimum information needed and an approved process for matching, access and retention.
3. Test and check
Try the plan with staff who will collect the data. If training is needed, use a live, screen-shared and recorded group session with accessible materials and agreed recording arrangements. Have collectors apply the definitions to the same fictional examples and compare their interpretations. Choose how many records to check against the source and how to select them; check for completeness and accuracy, note difficulties and improve the method. Assign an owner, frequency and correction process for ongoing checks. Apply definitions consistently across comparison periods; record any changes. Ask people affected by the workflow for their perspective using an appropriate privacy-preserving method.
4. Decide how results will be used
Choose a review date, responsible role and next decision. Review reporting completeness separately from the observed result. Missing or inaccurate information can affect interpretation; an apparent change alone does not establish its cause.
Fictional example
An agency team tests whether a form is easier to find at handoff. Before collection, it agrees which handoffs qualify, what constitutes a delay, when a response becomes missing and how reports match the independently counted handoffs. A staff coordinator checks the first few records with the collectors, resolves discrepancies under an agreed process and adjusts the instructions if needed. The team records the resulting method before comparing periods.
Your collection plan
This worksheet has no save button. Print or copy your work to an approved document before leaving; your browser or printed files may retain copies. Do not enter names, client details or other identifying information.
Include event, unit, period, numerator, denominator, eligibility and exclusions.
Who collects what, where, when and how? Include eligible counts, sampling coverage and method, and approved matching, access and retention.
Define missing, unknown and duplicate handling; include check selection, frequency, responsible role and correction process.
Include the trial, feedback, review date, responsible role and next decision.
Put the plan to work
After collecting counts, use the report completeness calculator to see missing reports alongside the observed result. Contact Special Learning to discuss group training for your organization.
Practice the definition together
Use the data collector group calibration guide to compare interpretations before collection.
Sources
Informed by the Institute for Healthcare Improvement’s simple data collection planning tool and the Agency for Healthcare Research and Quality’s guidance on developing quality measures.
