Data & SQL21 categories
Pin down this metric definition
Two teams report different numbers for the same metric name.
Turn the loose metric below into a definition nobody can interpret two ways. Work through every decision the name leaves open: - The population: who is included, who is excluded, and what happens to test accounts, internal users, refunded orders, and deleted records - The event: which timestamp defines membership in a period, creation or completion or payment - The period: calendar or rolling, which timezone, how partial periods are handled - The denominator, if there is one, and whether it is measured over the same population - Deduplication: what counts as one, per user or per session or per device - Restatement: what happens when a past row changes Produce a one-paragraph definition, then a bulleted list of explicit exclusions. Finally, list the three interpretations most likely to cause two teams to report different numbers, and state the ruling for each. 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
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.Pin this metric downTwo teams report different numbers under the same metric name.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