Executive Project Status Report & RAG Health Dashboard Generator
Generate concise, executive-level project status reports using the RAG (Red-Amber-Green) health framework.
Compatibility & Specs
Compatible AI Models
ClaudeChatGPTGemini
Last UpdatedOct 3, 2026
Customizable Variables5 parameters
Main Prompt Template
212 words • 1518 characters
You are a Director of Program Management and Executive Reporting Specialist. Executives do not have time to read 10-page status updates; they need to quickly digest health, budget, schedule, blockers, and required decisions in 60 seconds. I need you to synthesize recent progress into an executive-ready RAG status report.
Project Name, Workstream & Current Phase:
[project_overview]
Accomplishments This Period (What got completed):
[recent_accomplishments]
Active Blockers, Impediments & Risks (What is stuck or delayed):
[active_blockers]
Planned Deliverables for Next Period:
[next_period_goals]
Budget, Schedule & Scope Variance:
[variance_context]
Deliver the Executive Status Report (RAG Dashboard):
1. Overall RAG Health Badge & 1-Line Status: State the overall project status: GREEN (On Track), AMBER (At Risk - Mitigation in place), or RED (Critical - Leadership intervention needed), supported by an executive rationale.
2. RAG Dimension Scorecard: Break health down into 4 dimensions: Schedule Health, Scope Health, Budget/Cost Health, and Team Morale/Capacity Health.
3. Key Accomplishments (Value Shipped): Highlight 3 to 4 completed milestones framed around business outcomes rather than hours worked.
4. Critical Blockers & Required Leadership Decisions: Clearly state any blocker requiring executive sponsorship or budget approval to unblock (What is the decision? Who owns it? When is it needed by?).
5. Next Period Commitments: List top 3 target deliverables for the upcoming reporting window.
Tip:Variables marked in purple brackets can be tailored below.
Customize Prompt
Fill in the variables below. Your customized prompt updates instantly in the browser — no AI API needed.
Parameters (5)* Indicates required field
[project_overview]
Project title, department, and current milestone phase
[recent_accomplishments]
What tasks, tests, or features were completed this week
[active_blockers]
What is holding up work or causing delay
[next_period_goals]
What will be completed in the next reporting cycle
[variance_context]
How the project is tracking against original estimates
5 parameters active
Live Customized OutputLive Preview
311 wordsYou are a Director of Program Management and Executive Reporting Specialist. Executives do not have time to read 10-page status updates; they need to quickly digest health, budget, schedule, blockers, and required decisions in 60 seconds. I need you to synthesize recent progress into an executive-ready RAG status report.
Project Name, Workstream & Current Phase:
Global Payments Modernization (Phase 2: European Gateway Integration & Multi-Currency Settlement).
Accomplishments This Period (What got completed):
Completed sandbox testing for EUR and GBP payment processing with Adyen. Successfully executed 12,000 synthetic test transactions with 99.98% pass rate. Finished localization for French and German checkout UI.
Active Blockers, Impediments & Risks (What is stuck or delayed):
Banking partner compliance sign-off for German SEPA Direct Debit is delayed by 8 business days due to holiday backlog at their end. This threatens our Nov 1 European launch window.
Planned Deliverables for Next Period:
Execute 50k concurrent simulated transactions load test; complete final audit of currency exchange rate conversion logic.
Budget, Schedule & Scope Variance:
Schedule is currently 6 business days behind baseline due to partner compliance delays; budget is 4% under forecast.
Deliver the Executive Status Report (RAG Dashboard):
1. Overall RAG Health Badge & 1-Line Status: State the overall project status: GREEN (On Track), AMBER (At Risk - Mitigation in place), or RED (Critical - Leadership intervention needed), supported by an executive rationale.
2. RAG Dimension Scorecard: Break health down into 4 dimensions: Schedule Health, Scope Health, Budget/Cost Health, and Team Morale/Capacity Health.
3. Key Accomplishments (Value Shipped): Highlight 3 to 4 completed milestones framed around business outcomes rather than hours worked.
4. Critical Blockers & Required Leadership Decisions: Clearly state any blocker requiring executive sponsorship or budget approval to unblock (What is the decision? Who owns it? When is it needed by?).
5. Next Period Commitments: List top 3 target deliverables for the upcoming reporting window.
How to Use This Prompt
Follow this 3-step workflow to extract high-signal responses from any compatible AI model.
01
1. Tailor the Parameters
Use the interactive customizer above to substitute the bracketed placeholders with your exact context, requirements, and constraints.
02
2. Send to AI Model
Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot. These models follow structured multi-step constraints reliably.
03
3. Review and Iterate
Review the output against the verified benchmark below. Follow up in the conversation to stress-test edge cases or refine tone.
Prompt Variables & Parameters
Reference breakdown of every dynamic variable embedded in this prompt template.
| Placeholder | Parameter Name | Type | Status | Description & Guidance |
|---|---|---|---|---|
| [project_overview] | Project Name & Current Phase | text | Required | Project title, department, and current milestone phaseDefault: Global Payments Modernization (Phase 2: European Gateway Integration & Multi-Currency Settlement). |
| [recent_accomplishments] | Accomplishments This Period | textarea | Required | What tasks, tests, or features were completed this weekDefault: Completed sandbox testing for EUR and GBP payment processing with Adyen. Successfully executed 12,000 synthetic test transactions with 99.98% pass rate. Finished localization for French and German checkout UI. |
| [active_blockers] | Active Blockers & Impediments | textarea | Required | What is holding up work or causing delayDefault: Banking partner compliance sign-off for German SEPA Direct Debit is delayed by 8 business days due to holiday backlog at their end. This threatens our Nov 1 European launch window. |
| [next_period_goals] | Planned Deliverables Next Period | text | Required | What will be completed in the next reporting cycleDefault: Execute 50k concurrent simulated transactions load test; complete final audit of currency exchange rate conversion logic. |
| [variance_context] | Budget, Schedule & Scope Variance | text | Required | How the project is tracking against original estimatesDefault: Schedule is currently 6 business days behind baseline due to partner compliance delays; budget is 4% under forecast. |
Example Execution & Benchmark Output
Sample input arguments and the verified AI response demonstrating expected quality and formatting.
Sample VariablesInputs
[project_overview]
Global Payments Modernization (Phase 2: European Gateway Integration & Multi-Currency Settlement).
[recent_accomplishments]
Completed sandbox testing for EUR and GBP payment processing with Adyen. Successfully executed 12,000 synthetic test transactions with 99.98% pass rate. Finished localization for French and German checkout UI.
[active_blockers]
Banking partner compliance sign-off for German SEPA Direct Debit is delayed by 8 business days due to holiday backlog at their end. This threatens our Nov 1 European launch window.
[next_period_goals]
Execute 50k concurrent simulated transactions load test; complete final audit of currency exchange rate conversion logic.
[variance_context]
Schedule is currently 6 business days behind baseline due to partner compliance delays; budget is 4% under forecast.
Expected AI ResponseVerified Result
### Executive Project Status: Global Payments Modernization
**Reporting Period:** Week Ending October 3, 2026 | **Project Sponsor:** VP Financial Engineering
```
OVERALL HEALTH: [ AMBER — AT RISK ]
Rationale: Multi-currency technical integrations are outperforming quality benchmarks, but 3rd-party banking compliance delays in Germany threaten the Nov 1 go-live deadline.
```
#### 1. RAG Dimension Scorecard
* **Schedule: AMBER** (Tracking 6 business days behind baseline schedule due to vendor compliance response time)
* **Scope: GREEN** (100% of planned Phase 2 multi-currency capabilities retained; zero de-scoping required)
* **Budget: GREEN** (Operating at 4% under allocated expenditure)
* **Team Capacity: GREEN** (Engineering velocity steady; 0 unfilled roster positions)
#### 2. Key Accomplishments This Period
* **Synthetic Transaction Stress Test:** Completed 12,000 automated end-to-end payment runs in sandbox with 99.98% processing success.
* **Core European Localization:** Delivered production-ready French and German checkout UI ahead of localization schedule.
#### 3. Critical Blocker & Executive Decision Required
* **The Blocker:** German banking partner compliance review backlog is stalling SEPA Direct Debit production credentials.
* **Required Leadership Action:** Executive Sponsor needs to initiate a peer-level escalation with the Managing Director of European Partnerships at Adyen by Oct 6 to fast-track credential clearance.
Best Use Cases
Scenarios and roles where this prompt produces maximum leverage.
Program managers delivering weekly RAG dashboards to C-suite steering committees
Product directors communicating project variances and blockers transparently
Consulting engagement managers providing structured executive status reports to enterprise clients
Tips for Best Results
Techniques to elevate response fidelity
- •Provide rich background context rather than one-sentence inputs to receive deep, non-generic responses.
- •Engage in multi-turn conversation: use the initial output as a baseline, then ask the AI to sharpen specific sections.
- •Prompt the model to highlight any hidden assumptions or missing trade-offs in its recommendations.
Common Mistakes to Avoid
Frequent failure modes and anti-patterns
- •Giving minimal context and expecting nuanced, expert-level strategic output.
- •Not validating factual references, citations, or statistical claims with verified primary sources.
- •Skipping the customization step and pasting raw bracketed template variables into the AI chat.
Part of Curated Collections
This prompt is sequenced as part of these goal-oriented workflows
Related AI Prompts
Complementary workflows in Operations
Operationsadvanced
Project Delivery Risk Pre-Mortem & Mitigation Matrix
Conduct a pre-mortem analysis to anticipate hidden technical and operational project delivery failures.
claudechatgptgemini
#operations#project-management#risk-management
Operationsbeginner
Chaotic Meeting Notes to Structured Action Item & RACI Matrix Converter
Transform messy, unstructured meeting transcripts and bullet points into crystal-clear accountability matrices.
claudechatgptgemini
#operations#meeting-notes#action-items
Businessintermediate
Competitor Pricing & Packaging Strategy Teardown
Deconstruct rival pricing tiers, feature gating, expansion revenue triggers, and discounting traps to position your pricing power.
claudechatgptgemini
#pricing-strategy#competitor-analysis#packaging
Related Engineering Guides
Deep-dive playbooks and system prompt methodologies for Operations