Create a Comprehensive Quarterly Business Review Report
Generate a structured quarterly business review report with KPIs, financials, strategic updates, and next-quarter priorities.
๐ The Prompt
Act as a senior business analyst and create a comprehensive Quarterly Business Review (QBR) report for [COMPANY NAME] covering Q[QUARTER NUMBER] of [YEAR]. The company operates in the [INDUSTRY] sector and has approximately [NUMBER OF EMPLOYEES] employees.
Structure the report using the following framework:
1. **Executive Summary**: Write a concise 150-200 word overview of the quarter's performance, highlighting the top 3 wins and top 2 challenges faced.
2. **Financial Performance Overview**: Create a structured breakdown covering revenue performance vs. target of [REVENUE TARGET], profit margins, operating expenses, and quarter-over-quarter growth trends. Use placeholder data tables where appropriate.
3. **Key Performance Indicators (KPIs)**: Analyze the following KPIs and provide status indicators (On Track / At Risk / Off Track):
- Customer acquisition cost
- Customer retention rate
- Employee productivity metrics
- [CUSTOM KPI 1]
- [CUSTOM KPI 2]
4. **Strategic Initiatives Update**: Provide progress updates on [NUMBER OF INITIATIVES] key strategic initiatives, including percentage completion, blockers, and next steps for each.
5. **Competitive Landscape**: Summarize any notable market shifts, competitor moves, or emerging threats observed during the quarter.
6. **Team & Operational Highlights**: Recognize department-level achievements, new hires, and process improvements in [DEPARTMENT 1] and [DEPARTMENT 2].
7. **Risks & Mitigation**: Identify 3-5 forward-looking risks with proposed mitigation strategies.
8. **Next Quarter Outlook & Priorities**: Define the top 5 priorities for the upcoming quarter with measurable success criteria.
Use a professional, data-driven tone. Include actionable recommendations throughout. Format the report so it can be presented to both C-suite executives and department heads.
๐ก Tips for Better Results
Replace all placeholder variables with real company data before generating for the most accurate and relevant output.
Add specific numerical targets and actual results to the KPI section so the AI can provide meaningful variance analysis.
Run the prompt once for the overall structure, then follow up with deeper prompts for each individual section that needs more detail.
๐ฏ Use Cases
Business analysts, department heads, and executives who need to prepare polished quarterly review presentations or reports for leadership meetings and board reviews.