Data & SQL21 categories
Pin this metric down
Two teams report different numbers under the same metric name.
Mediummetricsdefinitions
Turn this loose metric into a definition two teams cannot read differently. Decide explicitly: who is in the population, which timestamp defines the period, what counts as one, and what happens to test accounts, refunds, and deleted records. Give a one-paragraph definition, then the exclusions as a short list. Metric:
Making it yours
- Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
- Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
- If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.
Numbers and metrics. Pinning down what a metric means, what a report measures, and whether a surprising number is real.
Related prompts
Pin down this metric definitionTwo teams report different numbers for the same metric name.Work out what this report actually measuresInheriting a dashboard whose numbers nobody can explain.Sanity-check a number before I believe itA result jumped 40% and you want to rule out your own query first.What does this report actually measure?Inheriting a dashboard nobody can explain.Sanity-check this number before I share itA figure jumped and you want to rule out your own query first.Explain this query to me line by lineYou inherited a 200-line query and need to understand it before changing it.
Keep this one
Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.
Add to your browser — free