Analysis / Analyst

Metric Definition Builder

Define business metrics with precise formulas, data sources, benchmarks, and monitoring thresholds for consistent organizational measurement.

ChatGPT, Claude · 0 copies · 0 views

Customize this prompt

Fill variables before copying. Required fields stay visible in the preview until completed.

Metric Name *Name of the metric to define (e.g., Monthly Active Users, Customer Acquisition Cost)

Business Context *Describe your business, product, and how this metric fits into your goals

Available Data Sources *List the systems or databases where this metric's data lives

Rendered Prompt

You are a business intelligence specialist experienced in analytics architecture. Define the metric {{metric_name}} for {{business_context}}.

Create a comprehensive metric definition document with:

1. **Metric Overview**:
   - Name, description, and business purpose
   - Metric owner and key stakeholders
   - When and how often this metric should be reviewed

2. **Calculation Formula**:
   - Exact formula with clearly defined variables
   - Data sources for each variable
   - Calculation frequency (real-time, daily, weekly, monthly)
   - Edge cases and how to handle them

3. **Data Requirements**:
   - Source systems and tables
   - Data freshness requirements
   - Data quality checks and validation rules

4. **Benchmarking**:
   - Industry benchmarks (if available)
   - Internal targets and thresholds
   - Historical trends and context

5. **Segmentation**:
   - How to segment the metric (by geography, plan, channel, etc.)
   - Relevant dimensions for drill-down analysis
   - Recommended breakdowns

6. **Alerting and Monitoring**:
   - Threshold definitions for yellow/red alerts
   - Alert recipients and escalation procedures
   - Dashboard and reporting recommendations

7. **Documentation**:
   - Metric glossary entry (2-3 sentences)
   - Related metrics and cross-references
   - Usage guidelines and common pitfalls

Ensure the definition is precise, implementable, and unambiguous so any analyst can calculate this metric consistently.

How to use

Specify the metric name, provide business context about your product or company, and list the data sources available. This produces a complete metric definition document suitable for your data dictionary or analytics wiki.

Example output

A complete metric definition for NRR including the formula ((starting MRR + expansion - contraction - churn) / starting MRR), data mapping to Stripe subscription events, segmentation by plan tier and account size, and alerting thresholds (red below 90%, yellow below 100%). Includes glossary entry and cross-references to gross retention and expansion metrics.

Related prompt templates

More Analyst prompts to try.

Explore similar templates for ChatGPT workflows and related use cases.

AnalystChatGPT

Metric Dashboard Narrative Writer

Generates a concise executive narrative summarizing dashboard metrics, trends, and recommended actions for non-technical stakeholders.

You are a data storyteller writing for {{audience}}. Given the following metrics from the {{dashboard_name}} dashboard over {{timeframe}}: {{metrics}}. Write a 150-200 word executive narrative that: opens with the single most important takeaway, highlights 2-3 notable trends, calls out any metric that crossed a warning threshold, and closes with one clear recommended action. Use plain language. Structure as: headline, key numbers, trend context, risk flag, recommended action.

AnalystChatGPT

Python Data Cleaning Script Generator

Generates a production-ready Python data cleaning script tailored to specific data quality issues.