Generate Metric Definition Documents

Metric Definition Document Generator enables Claude to create comprehensive, standardized metric definition documents for business intelligence and analytics systems, standardizing documentation, ensuring consistency across analytics teams, and enabling clear communication between business stakeholders and technical implementers. Every metric definition it produces covers six essential components: metric name, business purpose, technical definition with precise calculation methodology, data sources, ownership by both business and technical owners, and governance covering approval status, review cycle, and change management, written in unambiguous language for both business and technical readers with explicit edge cases, exclusions, and sample calculations.

Use it to document a business or analytics metric end-to-end: overview metadata such as ID, category, owner, and status, business context covering purpose and key questions answered, a technical definition with a SQL formula and business rules for inclusions, exclusions, filters, time zone, and currency, a data-sources table, available dimensions and lowest granularity, data-quality checks and a worked sample calculation, usage guidelines covering reporting schedule and interpretation notes, and a change-management section with an approval process and version history. It also covers common metric patterns - ratio metrics with division-by-zero handling, period-over-period and percentage-change comparisons, and cohort-analysis metrics covering cohort definition, time buckets, and survivorship bias. It is a documentation-generation skill, not an analytics or BI tool itself - it produces the definition document, not the underlying data pipeline or dashboard.

Input is a metric to document - its name, business purpose, and available calculation logic or data sources. Output is a structured Markdown metric definition document following the full template: overview, business context, technical definition with a SQL formula, business rules, a data-sources table, dimensions and granularity, data-quality checks, a sample calculation with input data and expected output, usage guidelines, and a change-management and version-history section.

-- Example calculation
SELECT 
  DATE_TRUNC('month', order_date) as month,
  SUM(order_total) as monthly_revenue
FROM orders 
WHERE order_status = 'completed'
GROUP BY 1

The document template is Markdown with embedded SQL for the technical formula and Markdown tables for data sources and version history. No specific BI platform such as Looker, Tableau, or dbt integration is documented; the template is platform-agnostic and meant to be version-controlled alongside a team's own documentation system.

Analytics and data-governance teams standardizing how metrics are defined and documented across an organization, who want a consistent template covering business purpose, technical calculation, data quality, and change management rather than ad hoc or inconsistent metric documentation.