How do I use the "Create a KPI Dashboard Framework" prompt?

Copy the prompt template, fill in the variables (BUSINESS_TYPE, PRIMARY_OBJECTIVES, TARGET_AUDIENCE, REPORTING_FREQUENCY), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this business 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 5-7 core KPIs rather than overwhelming stakeholders with too many metrics Ensure each KPI has a clear owner responsible for data accuracy and interpretation Use consistent time periods and definitions across all metrics to enable meaningful comparisons Include both leading indicators (predictive) and lagging indicators (outcome-based) for balanced insights Test dashboard usability with actual end users before final implementation

business intermediate

Create a KPI Dashboard Framework

Generate comprehensive KPI dashboard frameworks with metrics, visualizations, and tracking systems for business performance monitoring.

Works with: chatgptclaudegemini

Prompt Template

Create a comprehensive KPI dashboard framework for [BUSINESS_TYPE] with the following requirements: Business Context: - Business type: [BUSINESS_TYPE] - Primary objectives: [PRIMARY_OBJECTIVES] - Target audience for dashboard: [TARGET_AUDIENCE] - Reporting frequency: [REPORTING_FREQUENCY] Please develop a complete dashboard framework that includes: 1. **Strategic KPI Categories**: Identify 4-6 main categories of metrics aligned with business objectives 2. **Specific KPIs**: For each category, define 3-5 specific, measurable KPIs including: - KPI name and definition - Calculation method/formula - Target/benchmark values - Data sources required - Update frequency 3. **Dashboard Layout Design**: Recommend optimal visual arrangement including: - Priority hierarchy (what appears above the fold) - Chart types for each KPI - Color coding system - Filter and drill-down capabilities 4. **Implementation Roadmap**: Provide a phased approach including: - Phase 1: Quick wins (immediate implementation) - Phase 2: Enhanced metrics (3-6 months) - Phase 3: Advanced analytics (6-12 months) 5. **Governance Framework**: Define roles, responsibilities, and processes for: - Data quality management - Regular review cycles - Dashboard maintenance and updates Format the response with clear headings, bullet points, and actionable recommendations that can be immediately implemented.

Variables to Customize

[BUSINESS_TYPE]

The type of business or industry

Example: SaaS subscription platform

[PRIMARY_OBJECTIVES]

Main business goals to track

Example: Increase recurring revenue, reduce churn, improve customer satisfaction

[TARGET_AUDIENCE]

Who will be using the dashboard

Example: C-suite executives and department heads

[REPORTING_FREQUENCY]

How often metrics should be updated

Example: Daily for operational metrics, weekly for strategic KPIs

Example Output

# KPI Dashboard Framework for SaaS Subscription Platform ## Strategic KPI Categories ### 1. Revenue Performance - **Monthly Recurring Revenue (MRR)**: Sum of all subscription revenue normalized to monthly amounts - **Annual Recurring Revenue (ARR)**: MRR × 12, target: 25% YoY growth - **Revenue per Customer**: Total revenue ÷ active customers, benchmark: $150/month ### 2. Customer Health - **Churn Rate**: (Customers lost ÷ Total customers at start) × 100, target: <5% monthly - **Customer Lifetime Value (CLV)**: Average revenue per user ÷ Churn rate - **Net Promoter Score (NPS)**: Customer satisfaction survey, target: >50 ### 3. Growth Metrics - **Customer Acquisition Cost (CAC)**: Total sales/marketing spend ÷ New customers acquired - **Monthly Active Users (MAU)**: Unique users with meaningful engagement monthly - **Conversion Rate**: Free trial to paid conversion, target: >15% ## Dashboard Layout Design **Top Row**: Revenue trend line, current MRR, MRR growth rate **Second Row**: Customer count, churn rate, CAC:CLV ratio **Bottom Sections**: Detailed breakdowns by customer segment, geographic region, and product tier **Visual Elements**: Green/red color coding for targets, sparklines for trends, gauge charts for ratios ## Implementation Roadmap **Phase 1 (0-30 days)**: Implement core revenue and customer metrics using existing CRM data **Phase 2 (1-3 months)**: Add cohort analysis and predictive churn modeling **Phase 3 (3-6 months)**: Integrate customer satisfaction surveys and advanced segmentation

Pro Tips for Best Results

Start with 5-7 core KPIs rather than overwhelming stakeholders with too many metrics
Ensure each KPI has a clear owner responsible for data accuracy and interpretation
Use consistent time periods and definitions across all metrics to enable meaningful comparisons
Include both leading indicators (predictive) and lagging indicators (outcome-based) for balanced insights
Test dashboard usability with actual end users before final implementation