A data analysis prompt for design a data quality monitoring plan. It gives Claude and ChatGPT a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.
4.8(81 ratings)867 copies
Updated By Author
41 words · v1.2
Fill in the blanks · 1 variable
Claude promptReplace every highlighted token before sending
<task>
Design a data quality monitoring plan for {pipeline}. Define checks for freshness, volume, schema, uniqueness, referential integrity and distribution drift. For each give the threshold, alert channel, owner and runbook link. Flag checks that would be noisy in the first month.
</task>
Think carefully before answering. Keep any reasoning separate and put the final deliverable inside <answer> tags.
Share what worked, what broke and which model you used. Comments appear after posting and are moderated for spam.
How to use this prompt
1
Open Claude and start a new chat. Paste the prompt exactly as written.
2
Replace each placeholder ({pipeline}) with your own details. Leave the instructions and the output format untouched.
3
Add one concrete example or data point if the model's first answer is vague. Specific input produces specific output.
4
Run it once, then ask for a single revision with a specific critique rather than regenerating from scratch.
5
Review the result. Reconcile totals to a trusted source, verify the query and review the statistical claim with an analyst.
Worked example
This is the kind of input the prompt expects and the shape of output it produces. Your result will differ with the model and the details you supply.
Example input
Pipeline: the daily events pipeline
Example output
**Finding:** activation within 7 days predicts 90-day retention, but the effect is concentrated in self-serve signups.
**Method:** cohort by signup month, activation defined as completing two core actions within 7 days, retention measured on day 90. Excludes internal accounts and trials.
**Caveat:** sales-assisted accounts are small and may be underpowered. This is correlational, not causal. **Sanity check:** total users reconcile to the billing table within 0.4%.
Tips for a better result
Give the schema and the metric definition before asking for an interpretation.
Ask for the query or code so you can rerun it and check a known total.
Require a 'what this cannot tell us' section to surface confounders.
Change one variable at a time and compare the outputs; it is the fastest way to learn what this model responds to.
Common mistakes
Trusting a percentage without checking the denominator or sample size.
Treating correlation as causation in a retention or revenue analysis.
Letting the model invent a result for data it was not given.
Verified Knowledge · FAQ
Questions about this prompt
Practical answers about running the design a data quality monitoring plan prompt.
Related prompts
Same job, a different angle — or the next step in the workflow.
A data analysis prompt for explain a regression output to a stakeholder. It gives Claude and ChatGPT a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.
This copy-ready data analysis prompt helps you explain correlation versus causation with this case with fewer blank-page decisions. Paste it into Claude and ChatGPT, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.
This copy-ready data analysis prompt helps you summarise a dataset for an executive with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.
ChatGPTClaude
4.8(51)965 copies
A
Written and reviewed by Author
AIPrompt123 Contributor
Contributing author and prompt engineer at AIPrompt123.
Last reviewed 9 May 2026 · version 1.2 · tested on Claude, ChatGPT
Comments
Share what worked, what broke and which model you used. Comments appear after posting and are moderated for spam.