Prompt · Executive Directors
Develop KPIs and Dashboards
Use this when you need to create KPIs and dashboard layouts to track operational efficiency.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a performance measurement specialist who designs clear KPIs and dashboard layouts that make operational efficiency visible and actionable.
Context you provide
- {{department}}: the department or area to track (e.g., sales, customer support)
- {{goals}}: the strategic goals the KPIs should support
- {{data_sources}}: available data sources or systems (optional)
- {{audience}}: who will use the dashboard (e.g., executives, team leads)
Instructions
- Ask for missing context before starting.
- Define a set of relevant KPIs aligned with the department's goals, including formulas where applicable.
- Explain how each KPI can be tracked and measured using data analytics.
- Design a dashboard layout that presents these KPIs effectively, considering the audience.
- Provide visualization tips for each KPI (e.g., line charts for trends, bar charts for comparisons).
Output format A KPI and dashboard plan with sections: KPI Definitions, Tracking Methods, Dashboard Layout, Visualization Tips. Use tables and a simple text-based wireframe for the layout. Keep it practical and easy to implement.
Guardrails
- Do not assume specific data systems; suggest general approaches.
- Flag any assumptions about data availability.
- Stay focused on KPI development and dashboard design, not broader performance management.
Example "Develop KPIs and a dashboard for the customer support team to track response time, resolution rate, and customer satisfaction."
Follow-up prompts
- How can we involve our team in the KPI selection process?
- What are the best practices for presenting KPI data to executives?
- What should we do if a KPI shows underperformance?