Build standardized KPI definition templates for teams

Standardize team metrics and eliminate conflicting calculations for critical business KPIs. Use this before building dashboards or quarterly reports.

You getMetric Name and Objective, exact Formula and inclusion and Exclusion Rules

Prompt

Prompt
Act as a business intelligence lead. First, ask me 2-3 short numbered questions in one message to understand the metric, who uses it, and the systems tracking it, then wait for my answers.
After I reply, establish a rigorous definition for the metric:
- Provide an exact mathematical formula with explicitly defined numerator and denominator boundaries.
- Specify handling rules for common edge cases, including mid-month changes, refunds, and paused accounts.
- Define the standard reporting frequency and owner responsibility.
Output format:
- Metric Name and Objective
- Exact Formula (plain text and arithmetic format)
- Inclusion and Exclusion Rules
- Edge Case Handling Table (Case, Rule, Logic)
- Verification Checklist (3 steps to test output against raw tables)

Example output

Example for: monthly customer churn rate in a B2B SaaS company

Metric Name and Objective
Monthly Customer Churn Rate: Measure the percentage of active paying organizations that terminate all active paid subscriptions within a calendar month.

Exact Formula
Customer Churn Rate = (Number of Accounts Cancelled During Month) / (Total Active Accounts at Month Start) * 100

Inclusion and Exclusion Rules

  • Included: Any contract ending with zero active revenue before 23:59:59 on the last calendar day of the month.
  • Excluded: Free trial accounts, proof-of-concept plans, and internal test accounts.
  • Excluded: Accounts downgrading their tier but retaining at least one active paid license.

Edge Case Handling Table

CaseRuleLogic
Same-Month Signup and CancelExclude from both countsNot present in start-of-month baseline; track under 30-day onboarding churn instead.
Paused AccountCount as Active for 60 daysCustomer intent remains retained; churn only if paused beyond allowed window.
Delinquent PaymentChurn after 30 days past dueGrace period applies; mark churned on day 31 of failed rebill.

Verification Checklist

  1. Confirm the denominator strictly counts snapshots taken at 00:00:00 on the 1st of the calendar month.
  2. Verify that downgrades to a lower paid tier are filtered out of the cancellation event table.
  3. Compare total churned logos against finance revenue clawbacks to ensure consistency.
Written by AI from this prompt. Your results will vary.

Run this prompt in ChatGPT, Claude, or Gemini. The model will ask you three quick questions; respond concisely. For a follow-up, ask for a SQL snippet that implements the resulting inclusion and exclusion logic.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis