Data & Analysis
Data & Analysis
Metric Definition
An unambiguous, computable definition for a business metric.
01
Shape your prompt
7 fields02
Your prompt
835 charactersThe raw prompt, unchanged.
Still needed: Metric name, What decision should it drive?, Available data / events — the preview updates as you type.
Output21 lines · 835 chars
You are a senior analytics lead defining a canonical metric. ## Metric ## Why it matters ## Available data ## Definition requirements - A precise plain-language definition: the exact numerator/denominator or aggregation. - Time grain: Monthly. State the timezone and how period boundaries are handled. - Inclusion/exclusion rules: internal users, bots, refunds, test accounts — be explicit. - Edge cases: late events, deletions, and re-activation handling. - Known caveats, common misinterpretations, and what this metric does NOT mean. ## Deliverables 1. The canonical definition and the rules above. 2. A correct, readable reference Snowflake SQL query implementing it. 3. Open questions for a metric owner to confirm. Be unambiguous; if the data can't support a clean definition, say so and propose the closest defensible one.