Business Report Prompt Templates

AI prompt templates for business reports. Create clear, actionable reports for stakeholders.

Overview

Business reports transform raw data and observations into actionable insights for decision-makers. Effective reports don't just present information, they synthesize it, highlight what matters, and make recommendations clear. Strong prompts help you structure reports that busy executives will actually read and act upon.

Best Practices

1

Lead with conclusions and recommendations, busy readers may only read the first page

2

Use data visualization descriptions to support key points, not just for decoration

3

Structure around decisions the reader needs to make, not chronology of your analysis

4

Quantify impact whenever possible, 'revenue increased 15%' beats 'revenue improved'

5

Include clear next steps with owners and deadlines

Prompt Templates

1. Executive Summary for Report

Write an executive summary for a [REPORT_TYPE] covering [TIME_PERIOD]. Key findings: [FINDINGS]. Main recommendation: [RECOMMENDATION]. Target reader: [AUDIENCE]. Keep it under 200 words and lead with the most important insight.
Report Type: quarterly sales analysis, Time Period: Q3 2024, Findings: enterprise deals up 34% but SMB segment down 12%, average deal size increased from $45K to $62K, sales cycle lengthened by 18 days, Recommendation: double down on enterprise while investigating SMB churn, Audience: VP of Sales and CRO
Executive Summary

Q3 revenue grew 18% YoY, but this masks a significant shift in our customer mix that requires strategic attention.

Key findings:
- Enterprise segment: +34% revenue, average deal size up to $62K (from $45K)
- SMB segment: -12% revenue, with churn rate increasing to 8.2%
- Sales cycle: Extended 18 days on average, driven by enterprise deals requiring more stakeholders

The enterprise momentum is a strength to build on, but the SMB decline signals a problem we can't ignore, these customers represent 60% of our volume and are the pipeline for future enterprise accounts.

Recommendation:
1. Immediate: Allocate two additional AEs to enterprise to capitalize on momentum
2. Within 30 days: Conduct churn analysis on lost SMB accounts to identify root cause
3. Q4: Develop SMB retention playbook based on findings

Full analysis and supporting data follow in sections 2-5.

Opening section of any report for senior leadership

  • โ€ขWrite this last, after your full analysis, it's a summary, not an introduction
  • โ€ขAssume this may be the only section some readers see

2. Status Report

Write a [FREQUENCY] status report for [PROJECT/INITIATIVE]. Current status: [STATUS]. Progress since last report: [PROGRESS]. Blockers or risks: [BLOCKERS]. Next period priorities: [PRIORITIES]. Metrics: [KEY_METRICS]. Keep it scannable with clear sections.
Frequency: weekly, Project: CRM migration, Status: on track, Progress: completed data mapping and validation, began user acceptance testing with pilot group, Blockers: integration with legacy billing system delayed 1 week due to API documentation issues, Priorities: complete UAT, begin training material development, Key Metrics: 85% data validation complete, 12 of 50 users in pilot
CRM Migration, Weekly Status Report
Week of October 14, 2024

Status: ๐ŸŸข On Track

Progress This Week:
โœ“ Data mapping and validation 85% complete (up from 60%)
โœ“ User acceptance testing launched with pilot group (12 users)
โœ“ Custom field configuration finalized
โœ“ Single sign-on integration tested successfully

Blockers & Risks:
โš ๏ธ Legacy billing system integration delayed 1 week
 - Root cause: Incomplete API documentation from vendor
 - Mitigation: Scheduled call with vendor technical team for Thursday
 - Impact: No impact to overall timeline if resolved by Oct 21

Next Week Priorities:
1. Complete remaining data validation (targeting 100%)
2. Expand pilot to 25 users
3. Begin training material development
4. Resolve billing integration blocker

Key Metrics:
- Data validation: 85% โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘ 
- Pilot users: 12/50 (24%)
- Timeline: Day 34 of 60 (57%)

Questions or concerns? Reply to this email or join office hours Wednesday at 2pm.

Regular updates on ongoing projects or initiatives

  • โ€ขUse consistent formatting each week so readers know where to look
  • โ€ขProactively surface risks before they become surprises

3. Analysis Report

Write an analysis report on [TOPIC] for [AUDIENCE]. Data analyzed: [DATA_SOURCES]. Key question being answered: [KEY_QUESTION]. Include methodology summary, findings, and recommendations. Structure for a reader who has 10 minutes.
Topic: website conversion rate decline, Audience: marketing leadership, Data Sources: Google Analytics, Hotjar recordings, customer surveys, Key Question: why did conversion rate drop 23% in September
Analysis: September Conversion Rate Decline

Key Finding: The 23% conversion drop is primarily attributable to mobile checkout friction introduced in the September 1st release, not traffic quality or pricing factors.

---

Methodology
Analyzed three data sources to isolate the cause:
1. Google Analytics: Traffic sources, device breakdown, funnel progression
2. Hotjar: 200 session recordings, heatmaps on checkout pages
3. Customer surveys: 47 responses from abandoned cart follow-ups

---

Findings

1. Mobile conversion dropped 41%, desktop only dropped 8%
 - Mobile traffic share increased to 64% (from 58%), amplifying the impact

2. Checkout step 2 abandonment spiked from 12% to 34%
 - Hotjar recordings show users struggling with new address form
 - Autofill no longer working on mobile browsers

3. Traffic quality remained consistent
 - Same channel mix, similar engagement metrics pre-checkout
 - Ruled out: paid media targeting issues, SEO traffic changes

4. Customer survey feedback (47 responses):
 - 68% mentioned "checkout was frustrating"
 - 23% specifically mentioned mobile issues

---

Recommendations

1. Immediate: Roll back address form to August version (Est. +15% conversion recovery)
2. This week: Fix mobile autofill compatibility
3. Before next release: Implement checkout A/B testing framework

---

Appendix: Full data tables and session recording links available upon request.

When leadership needs to understand why something happened and what to do about it

  • โ€ขLead with the answer, then provide supporting evidence
  • โ€ขDistinguish between correlation and causation in your findings

4. Monthly Business Review

Write a monthly business review for [MONTH/YEAR] for [BUSINESS/DEPARTMENT]. Compare performance to [COMPARISON_PERIOD]. Include: overall performance summary, key metrics vs targets, highlights, challenges, and priorities for next month. Target reader: [AUDIENCE].
Month: October 2024, Business: Customer Success department, Comparison: September 2024 and October 2023, Audience: CEO and executive team
Customer Success Monthly Business Review
October 2024

---

Performance Summary

October was a strong month for retention but challenging for expansion. Net Revenue Retention hit 108%, driven by lower-than-expected churn. However, expansion revenue missed target by 15% as upsell conversations stalled in uncertain budget environments.

---

Key Metrics vs Targets

| Metric | Target | Actual | vs LM | vs LY |
|--------|--------|--------|-------|-------|
| Net Revenue Retention | 105% | 108% | +3% | +5% |
| Gross Churn | 2.0% | 1.4% | -0.3% | -0.8% |
| Expansion Revenue | $420K | $357K | -12% | +8% |
| NPS | 45 | 52 | +4 | +12 |
| Time to First Value | 14 days | 11 days | -2 days | -5 days |

---

Highlights
โœ“ Lowest churn month in company history (1.4%)
โœ“ NPS reached all-time high of 52
โœ“ New onboarding playbook reduced Time to First Value by 21%
โœ“ Successfully onboarded 3 enterprise accounts without dedicated resources

Challenges
โœ— Expansion revenue 15% below target
โœ— Enterprise CSM capacity at 115% (unsustainable)
โœ— Two key accounts flagged at-risk (combined ARR: $380K)

---

November Priorities
1. Close $380K at-risk accounts with executive intervention
2. Launch Q4 upsell campaign with revised ROI messaging
3. Hire enterprise CSM (req approved, interviews starting)
4. Pilot automated health scoring to improve early warning signals

Regular business reviews for executive leadership

  • โ€ขUse consistent metrics each month to enable trend analysis
  • โ€ขBalance wins and challenges, credibility comes from honesty

5. Competitive Analysis Report

Write a competitive analysis comparing [OUR_COMPANY/PRODUCT] to [COMPETITORS]. Focus areas: [FOCUS_AREAS]. Include strengths, weaknesses, opportunities, and threats relative to each competitor. Format for [AUDIENCE] who will use this for [PURPOSE].
Our Product: Project management SaaS, Competitors: Asana, Monday.com, ClickUp, Focus Areas: pricing, enterprise features, integrations, Audience: product team, Purpose: roadmap prioritization
Competitive Analysis: Project Management Market
Prepared for Product Roadmap Planning

---

Market Position Summary

We occupy the mid-market segment with strong collaboration features but gaps in enterprise administration and reporting. Asana leads in enterprise, Monday.com in ease-of-use, ClickUp in feature breadth at lower price points.

---

Competitor Breakdown

**Asana**
Strengths:
- Enterprise admin controls (SSO, provisioning, audit logs)
- Brand recognition in Fortune 500
- Strong professional services arm

Weaknesses:
- Premium pricing excludes SMB
- Slower feature velocity
- Complex UI learning curve

Threat level: High for enterprise deals
Opportunity: Win on price and usability in mid-market

---

**Monday.com**
Strengths:
- Best-in-class onboarding and ease of use
- Strong marketing and brand awareness
- Flexible for non-PM use cases (CRM, etc.)

Weaknesses:
- Performance issues with large datasets
- Limited advanced PM features (dependencies, critical path)
- Pricing scales poorly with team size

Threat level: High for new buyers prioritizing UX
Opportunity: Win on PM depth and scalability

---

**ClickUp**
Strengths:
- Aggressive pricing (often 50% below us)
- Rapid feature development
- Feature parity or better in most areas

Weaknesses:
- Reliability concerns (uptime, bugs)
- Inconsistent support experience
- Brand perception as "cheap alternative"

Threat level: High for price-sensitive buyers
Opportunity: Win on reliability and support

---

Roadmap Implications

1. Enterprise gap is our biggest risk, prioritize audit logs and advanced permissions in Q1
2. Onboarding improvements could neutralize Monday.com's UX advantage
3. Avoid competing with ClickUp on features alone, differentiate on reliability messaging

Product planning, sales enablement, or strategic planning

  • โ€ขFocus on dimensions that matter to your buyers, not every possible comparison
  • โ€ขUpdate competitive analysis quarterly, markets move fast

Common Mistakes to Avoid

โ€ข

Burying insights under methodology explanations, executives want conclusions first, then supporting evidence

โ€ข

Presenting data without interpretation, raw numbers aren't insights until you explain what they mean

โ€ข

Failing to include specific recommendations, a report without action items is just informational noise

Frequently Asked Questions

Business reports transform raw data and observations into actionable insights for decision-makers. Effective reports don't just present information, they synthesize it, highlight what matters, and make recommendations clear. Strong prompts help you structure reports that busy executives will actually read and act upon.

Related Templates

Have your own prompt to optimize?