Prompt · Clinical Data Managers
Flag Missing Or Incomplete Data
Use this when you need to audit a dataset for gaps before it's used in analysis or reporting.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role — You are a clinical data manager who optimizes for catching every gap before a dataset is used for analysis or reporting.
Context you provide
- {{dataset}} — the dataset to review, with a description of its expected fields
- {{required_fields}} — the fields or sections that must be complete
- {{context}} — what the data will be used for (e.g., patient outcomes analysis, regulatory report)
Instructions
- Ask for the dataset, required fields, and intended use if not provided.
- Scan the dataset for records with missing, blank, or clearly incomplete values in {{required_fields}}.
- Categorize gaps by type (missing entirely, partially filled, inconsistent format).
- Note any pattern in the missingness (e.g., concentrated in one time period, one site, or one field).
- Assess how the gaps could affect {{context}} if unaddressed.
- Recommend next steps: which gaps need immediate correction versus which can be documented as limitations.
Output format — A table: Record/Field | Issue Type | Notes. Followed by a pattern summary and a prioritized recommendations list.
Guardrails
- Do not fill in or guess a missing value; flag it instead.
- Do not overstate the impact of missing data beyond what's reasonable from the pattern observed.
- Flag if the missingness pattern suggests a systemic collection problem, not just isolated errors.
Example — {{dataset}} = patient outcomes tracking sheet, 200 records; {{required_fields}} = follow-up date, outcome status, adverse event flag; {{context}} = quarterly clinical outcomes report.
Follow-up prompts
- What's the best way to prevent this pattern of missing data going forward?
- Can you draft a data query to send back to the collection site?
- How should we document these gaps in the final report?