How do I use the "Create KPI Dashboard Metrics" prompt?

Copy the prompt template, fill in the variables (BUSINESS_FUNCTION, COMPANY_TYPE, PRIMARY_OBJECTIVES, TIME_PERIOD), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this data prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Start with 3-5 primary KPIs before adding secondary metrics to avoid dashboard clutter Include both leading indicators (predictive) and lagging indicators (results) for balanced insights Set realistic target ranges based on industry benchmarks and historical performance Choose visualization types that make trends and anomalies immediately obvious Define clear alert thresholds to enable proactive decision-making

data beginner

Create KPI Dashboard Metrics

Generate comprehensive KPI dashboard metrics for any business function. Define key performance indicators with targets and visualization tips.

Works with: chatgptclaudegemini

Prompt Template

You are a business intelligence expert tasked with creating comprehensive KPI dashboard metrics for [BUSINESS_FUNCTION]. Design a strategic dashboard that provides actionable insights and clear performance visibility. Please create KPI metrics with the following specifications: Business Context: - Business function: [BUSINESS_FUNCTION] - Company type: [COMPANY_TYPE] - Primary objectives: [PRIMARY_OBJECTIVES] - Time period for tracking: [TIME_PERIOD] For each KPI, provide: 1. KPI Name and Definition 2. Why it matters (business impact) 3. How to calculate it (formula) 4. Target/benchmark ranges 5. Data sources needed 6. Recommended visualization type 7. Update frequency 8. Who should monitor it Organize the KPIs into categories: - Primary KPIs (3-5 most critical metrics) - Secondary KPIs (5-7 supporting metrics) - Leading indicators (predictive metrics) - Lagging indicators (outcome metrics) Also include: - Dashboard layout recommendations - Alert thresholds for critical metrics - Integration suggestions with existing tools - Tips for stakeholder communication Ensure all metrics are SMART (Specific, Measurable, Achievable, Relevant, Time-bound) and aligned with business goals.

Variables to Customize

[BUSINESS_FUNCTION]

The specific business area or department to create KPIs for

Example: Sales and Marketing

[COMPANY_TYPE]

Type and size of the company

Example: SaaS startup with 50 employees

[PRIMARY_OBJECTIVES]

Main business goals and objectives

Example: Increase revenue by 40%, improve customer retention, expand market share

[TIME_PERIOD]

Reporting and tracking timeframe

Example: Monthly and quarterly reporting

Example Output

# Sales & Marketing KPI Dashboard for SaaS Startup ## Primary KPIs **Monthly Recurring Revenue (MRR)** - Definition: Total predictable revenue generated monthly - Formula: Sum of all subscription revenues normalized to monthly - Target: $500K+ (20% month-over-month growth) - Visualization: Line chart with trend indicators - Data source: Billing system, CRM - Monitor: CEO, Sales Director **Customer Acquisition Cost (CAC)** - Definition: Total cost to acquire one new customer - Formula: (Sales + Marketing expenses) / New customers acquired - Target: <$300 (3:1 LTV:CAC ratio) - Visualization: Bar chart with benchmark line - Update: Monthly ## Secondary KPIs **Lead Conversion Rate** - Definition: Percentage of leads converted to paying customers - Target: 15-25% - Alert threshold: Below 10% **Churn Rate** - Definition: Percentage of customers lost monthly - Target: <5% - Critical alert: Above 8% ## Dashboard Layout - Top row: Primary revenue metrics (MRR, CAC) - Middle: Funnel metrics (leads, conversion, churn) - Bottom: Campaign performance and forecasts **Integration**: Connect Salesforce, HubSpot, and Stripe for automated data flow.

Pro Tips for Best Results

Start with 3-5 primary KPIs before adding secondary metrics to avoid dashboard clutter
Include both leading indicators (predictive) and lagging indicators (results) for balanced insights
Set realistic target ranges based on industry benchmarks and historical performance
Choose visualization types that make trends and anomalies immediately obvious
Define clear alert thresholds to enable proactive decision-making