Tracking · Reporting Cadence & Templates

Design a Monthly Pipeline Review Deck

Create a monthly pipeline review deck template that drives deal-by-deal decisions, not status updates.

managerfounderIntermediate3–4 hrs of prep + sharper monthly reviews
When to use
Use when monthly pipeline reviews keep turning into 'read the CRM out loud' sessions. This builds a slide-by-slide template that forces decisions on stuck deals, forecast confidence, and stage hygiene. Best run before your next month-end review so the manager has structure walking in.
The prompt
You are a sales ops lead at a digital marketing agency selling [SERVICES]. You run the monthly pipeline review with the sales manager and founder.
Agency: [AGENCY_NAME] — [SERVICES] | Reporting period: [REPORTING_PERIOD] | Audience: [AUDIENCE] | KPIs: [KPIS] | Pipeline stages: [PIPELINE_STAGES]
Design a monthly pipeline review DECK TEMPLATE (8–10 slides) that turns the review into a deal-by-deal decision meeting, not a CRM readout.

- 8–10 slides max
- Each slide must end with a decision or owner, not a chart
- Must include 'What's the action?' summary slide at end
- Skim-readable: each slide digestible in 
Markdown outline with: Slide # | Title | Purpose (1 line) | What to include (3–5 bullets: charts, tables, narrative) | Decision/owner expected. Include a final 'What's the action?' slide listing top 3–5 deals to act on this week.
Variables
  • [AGENCY_NAME] — Your agency name
  • [SERVICES] — Service lines sold
  • [REPORTING_PERIOD] — Month being reviewed
  • [AUDIENCE] — Who's in the room: founder, manager, reps
  • [KPIS] — Pipeline KPIs tracked, e.g. coverage, velocity, win rate
  • [PIPELINE_STAGES] — Your CRM stages in order
Example input
AGENCY_NAME: Apex Creative | SERVICES: web design + paid social | REPORTING_PERIOD: April 2026 | AUDIENCE: founder + sales manager | KPIS: coverage ratio, avg deal size, win rate, days-in-stage | PIPELINE_STAGES: New → Qualified → Proposal → Negotiation → Closed
Example output
**Slide 1 — Headline & Forecast Confidence**
Purpose: One-slide answer to 'are we going to hit?'
Include: This-month forecast $, commit/best/worst, confidence (H/M/L), 2-sentence narrative.
Decision: Confirm forecast call.

**Slide 2 — Pipeline Coverage by Stage**
Purpose: Show if coverage is healthy.
Include: Stacked bar (stage $), coverage ratio vs target, last-month comparison.
Decision: Where do we need to fill?

**Slide 3 — Stuck Deals (>30 days in stage)**
Include: Table of deals, owner, stage, last touch.
Decision: Disqualify, escalate, or coach.

**Slide 4 — Top 5 Deals to Close**
Include: Name, $, stage, blocker, next step.
Decision: Who needs founder help?

**Slide 5 — Win/Loss This Month**
**Slide 6 — Retainer vs Project Mix**
**Slide 7 — Source Quality**

**Final — What's the action?**
Top 3–5 deals to push this week, owner, due date.
Pro tips
  • Pre-fill the 'stuck deals' slide BEFORE the meeting — don't discover them live.
  • Force one slide per decision. If a slide doesn't end in an action, cut it.
  • Track forecast confidence (H/M/L) month over month — calibration is the real KPI.
Works with
ClaudeChatGPTGemini
Done with prompts? Time to install the system
Book a STAOS call
Related prompts