KPI Dashboard Blueprint
Generate a complete KPI dashboard specification from your business goals — what to track, how to measure it, target ranges, and which tools to pull data from. Perfect for setting up Google Sheets, Looker Studio, or any BI tool.
Pro tip
Paste in your actual revenue numbers or last quarter results as context. The more real data you feed in, the more specific the thresholds and targets will be.
How to use this prompt
- Pick your AI model. Choose the tab for Claude, ChatGPT, Gemini or Copilot — each variant is tuned for that model.
- Copy the full prompt. Click Copy Full Prompt to copy the text to your clipboard.
- Paste into your AI tool. Open your chosen model and paste the prompt into a new chat.
- Replace the
[placeholders]. Swap any bracketed fields for your company name, audience, product or tone. - Run and refine. Review the output. If anything is off, ask the AI to tighten tone, length or format.
Prompt Variants by Model
Claude
Claude 4.x
UPDATED APR 2026
You are a business analytics consultant helping a small business owner design their KPI dashboard.
<business_context>
Business type: [YOUR_BUSINESS_TYPE]
Revenue range: [ANNUAL_REVENUE]
Team size:...You are a business analytics consultant helping a small business owner design their KPI dashboard.
<business_context>
Business type: [YOUR_BUSINESS_TYPE]
Revenue range: [ANNUAL_REVENUE]
Team size: [NUMBER]
Current tools: [e.g., Stripe, QuickBooks, Google Analytics, Shopify]
Biggest challenge: [WHAT_KEEPS_YOU_UP_AT_NIGHT]
</business_context>
Design a KPI dashboard with these sections:
1. Executive summary — 5 headline metrics I should check daily
2. Revenue health — metrics, formulas, red/yellow/green thresholds
3. Customer health — acquisition cost, retention rate, lifetime value
4. Operations — efficiency metrics specific to my business type
5. Leading indicators — early warning signals before problems hit revenue
For each metric specify:
- Exact calculation formula
- Data source (which tool it comes from)
- Update frequency (real-time, daily, weekly)
- Target range and alert threshold
- One action to take when the metric goes red
Prioritize metrics I can actually pull from my existing tools. Flag any gaps where I need a new data source.
Notes: Claude excels at structured analytical output. The XML context tags help it weight your specific situation. Add actual numbers from last quarter for calibrated thresholds.
ChatGPT
GPT-5
UPDATED APR 2026
Act as a business analytics consultant who has helped 200+ small businesses set up their first KPI dashboards.
I need you to design a complete KPI dashboard for my business.
My details:
- Business...Act as a business analytics consultant who has helped 200+ small businesses set up their first KPI dashboards.
I need you to design a complete KPI dashboard for my business.
My details:
- Business type: [YOUR_BUSINESS_TYPE]
- Annual revenue: [ANNUAL_REVENUE]
- Team size: [NUMBER]
- Tools I already use: [e.g., Stripe, QuickBooks, Google Analytics, Shopify]
- My biggest challenge right now: [WHAT_KEEPS_YOU_UP_AT_NIGHT]
Create a dashboard blueprint with:
1. The 5 numbers I should check every morning
2. Revenue health metrics with exact formulas and red/yellow/green zones
3. Customer health — CAC, retention, LTV with benchmarks for my industry
4. Operations efficiency metrics specific to my business type
5. Leading indicators that warn me before problems hit the bottom line
For every metric, tell me: the exact formula, where to pull the data from, how often to update it, what a healthy range looks like, and one specific action to take when it goes red.
Only recommend metrics I can actually measure with my current tools. Call out any blind spots.
Notes: ChatGPT responds well to the persona + specificity combo. Adding "Be specific and actionable" reduces generic filler. Use Code Interpreter to have it build a sample spreadsheet template.
Gemini
Gemini 3 Pro
UPDATED APR 2026
I need help building a KPI dashboard for my small business. Here is my situation:
**Business type:** [YOUR_BUSINESS_TYPE]
**Annual revenue:** [ANNUAL_REVENUE]
**Team size:** [NUMBER]
**Tools I...I need help building a KPI dashboard for my small business. Here is my situation:
**Business type:** [YOUR_BUSINESS_TYPE]
**Annual revenue:** [ANNUAL_REVENUE]
**Team size:** [NUMBER]
**Tools I use:** [e.g., Stripe, QuickBooks, Google Analytics, Shopify]
**Biggest challenge:** [WHAT_KEEPS_YOU_UP_AT_NIGHT]
Research current industry benchmarks for my business type, then design a KPI dashboard with:
1. Five headline metrics for a daily check-in
2. Revenue health section with formulas, data sources, and target thresholds
3. Customer health — CAC, retention, LTV with industry-specific benchmarks
4. Operational efficiency metrics tailored to my business type
5. Leading indicators that signal problems before they hit revenue
For each metric include: the calculation, which of my tools provides the data, update frequency, healthy vs warning vs critical ranges, and one action step when it goes red.
Stick to metrics I can measure with my existing stack. Flag any gaps.
Notes: Gemini has real-time search grounding — asking it to "research current industry benchmarks" activates this for up-to-date data. Works especially well in Google Workspace environments where it can reference Sheets directly.
Copilot
Copilot (Microsoft 365)
UPDATED APR 2026
Help me create a KPI dashboard for my small business.
Business type: [YOUR_BUSINESS_TYPE]
Annual revenue: [ANNUAL_REVENUE]
Team size: [NUMBER]
Tools I use:...Help me create a KPI dashboard for my small business.
Business type: [YOUR_BUSINESS_TYPE]
Annual revenue: [ANNUAL_REVENUE]
Team size: [NUMBER]
Tools I use: [e.g., Stripe, QuickBooks, Google Analytics, Shopify]
My biggest problem right now: [WHAT_KEEPS_YOU_UP_AT_NIGHT]
I need:
1. The 5 most important numbers to check daily
2. Revenue metrics with exact formulas and color-coded thresholds
3. Customer metrics — acquisition cost, retention, lifetime value
4. Operations metrics for my specific business type
5. Early warning indicators
For each metric: give me the formula, tell me where the data lives in my tools, how often to update it, what good/warning/critical looks like, and what to do when it goes red.
Keep it practical — only metrics I can actually pull from my existing tools.
Notes: Copilot integrates with Excel and Power BI natively. If used inside Microsoft 365, it can auto-create the dashboard layout in Excel. Keep language direct and conversational for best results.
Frequently Asked Questions
What does the KPI Dashboard Blueprint prompt do?
Generate a complete KPI dashboard specification from your business goals — what to track, how to measure it, target ranges, and which tools to pull data from. Perfect for setting up Google Sheets, Looker Studio, or any BI tool.
Which AI models is this prompt tested on?
This prompt is field-tested on Claude, ChatGPT, Gemini and Copilot. Each model has its own optimized variant above.
Do I need a paid AI account to use this prompt?
No. This prompt is written to run on the free tier of Claude, ChatGPT, Gemini and Copilot. Paid tiers simply give you longer context windows and faster responses.
Can I customize this prompt for my business?
Yes. Any text inside square brackets is a placeholder you replace with your own business details, such as company name, audience, product or tone. You can also ask the AI to adjust format, length or style after the first output.
When was this prompt last verified?
Each model variant above shows its own freshness stamp. AlignAI re-verifies every prompt at least monthly and rebuilds when a major model changes.
Don’t see what you need? tailored to your use case.