PromptGenerator
Data & Analysis

Data & Analysis

Metric Definition

An unambiguous, computable definition for a business metric.

01

Shape your prompt

7 fields
02

Your prompt

835 characters

The 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.