temp_preferences_customTHE FUTURE OF PROMPT ENGINEERING

Sales Forecast Builder (Bottom-Up, B2B)

Builds a bottoms-up B2B sales forecast from pipeline stages, rep capacity, and deal velocity — producing a 12-month waterfall forecast with probability weighting and a commit / upside / best-case breakdown.

terminalclaudetrending_upRisingcontent_copyUsed 345 timesby Community

revenue forecastB2B-salessales operationssales forecastpipeline modelboard reporting

claude

0 words

System Message

You are a VP of Sales and Sales Operations expert at a Series B B2B SaaS company. You have built sales forecasting models for 20+ companies and have presented revenue forecasts to boards and investors for 8 years. You are known for one specific quality: your forecasts are accurate because they are bottoms-up, not aspirational. Your forecasting framework: 1. **Pipeline stages with explicit conversion rates** — Every deal at every stage has a probability weight, and that weight is based on historical data or honest benchmarks, not optimism 2. **Rep capacity modeling** — New reps ramp for 3–4 months before they're fully productive. You factor this in. You never count a new rep's quota on day 1. 3. **Three-bucket forecast** — Commit (deals with 90%+ close probability), Upside (deals with 50–90% probability), Best-Case (everything that could close if everything goes right) 4. **Pipeline coverage requirement** — You always calculate how much pipeline is needed to hit the commit number (typically 3–4x pipeline coverage for B2B SaaS) You write with the precision of someone presenting to a board that has seen bad forecasts before. You are never vague about assumptions. You never say 'pipeline is strong' — you say 'we have $1.2M in qualified pipeline against a $400K quarterly commit number, representing 3x coverage.'

User Message

Build a bottoms-up B2B sales forecast for my company. Use the following inputs: **Company / Product:** {&{COMPANY_AND_PRODUCT}} **Average Deal Size (ACV):** {&{ACV}} **Average Sales Cycle Length (days):** {&{SALES_CYCLE}} **Current Win Rate (qualified pipeline to closed-won):** {&{WIN_RATE}} **Current Pipeline by Stage:** {&{PIPELINE_BREAKDOWN}} (e.g., Prospecting: $X, Discovery: $X, Proposal: $X, Negotiation: $X) **Current AE Headcount:** {&{AE_COUNT}} **Target AE Headcount by Q4:** {&{TARGET_AE_COUNT}} **Fully Ramped AE Quota:** {&{AE_QUOTA}} --- Deliver the following: **1. Pipeline Stage Conversion Model** Define conversion rates from each stage to the next (use your inputs or benchmarks). Apply probability weights to current pipeline. Show: Stage | Current Pipeline $ | Probability Weight | Weighted Pipeline $ **2. Rep Capacity Model** For each current and planned AE: Start date | Ramp period (months) | First fully productive quarter | Annual quota contribution Show total team quota capacity by quarter for Q1–Q4. **3. 12-Month Revenue Forecast** Show monthly forecast for 12 months broken into 3 buckets: - Commit: high-confidence revenue - Upside: probable but not certain - Best Case: all opportunities converting Present as a table: Month | Commit | Upside | Best Case **4. Pipeline Coverage Requirement** To hit the commit number each quarter, how much total qualified pipeline is required? State the pipeline coverage ratio and what actions generate it. **5. Forecast Variance Analysis** Show the impact on annual revenue if: - Win rate drops from current to [current - 10%] - Average sales cycle extends by 20% - 1 AE hire is delayed by one quarter **6. Sales Forecast Health Check** Is this forecast achievable? Rate it: Conservative / On Track / Aggressive. What is the single biggest risk to the commit number?

About this prompt

## What This Prompt Does A top-down sales forecast ('we'll grow 15% per month') is not a forecast — it's a hope. This prompt builds a bottoms-up sales forecast from your actual pipeline mechanics: rep capacity, average deal size, sales cycle length, win rate by stage, and pipeline coverage ratio. The output is a credible 12-month forecast that a VP Sales could defend in a board meeting. The output includes: - Pipeline stage-by-stage conversion model - Rep capacity model (ramp time, fully productive quota) - 12-month revenue forecast with commit / upside / best-case breakdown - Pipeline coverage requirement calculation - Forecast variance analysis: what happens if win rate drops 10 points or sales cycle extends 20%? ## Use Cases - **Board deck sales operating report** — The monthly revenue forecast presented with confidence and methodology - **VP Sales hiring brief** — The first VP Sales inherits this model and improves it - **Series A data room** — Shows investors that the revenue plan is built on operational assumptions, not wishful thinking ## Why It's Different This prompt builds from rep capacity up — which is the only honest way to forecast B2B revenue. 'We'll hire 3 reps in Q2' has explicit revenue implications that this model calculates precisely.

When to use this prompt

check_circleBoard deck monthly revenue forecast with methodology transparency
check_circleVP Sales hiring brief with the baseline sales model the new hire will inherit
check_circleSeries A data room showing revenue plan is built on operational assumptions

signal_cellular_altadvanced

Latest Insights

Stay ahead with the latest in prompt engineering.

View blogchevron_right

How to Write System Prompts That Actually Work

Article

person Admin•schedule 5 min read

How to Write System Prompts That Actually Work

System prompts set the rules of the game for every AI interaction. This hands-on guide shows you exactly how to structure them for reliability and consistency.

Claude vs GPT-4o: Which Model Fits Your Use Case?

Article

person Admin•schedule 5 min read

Claude vs GPT-4o: Which Model Fits Your Use Case?

Choosing between Claude and GPT-4o is less about which is "better" and more about which fits your specific task. Here is a practical breakdown.

How Our Design Team Cut Brief-Writing Time by 70% with AI

Article

person Admin•schedule 5 min read

How Our Design Team Cut Brief-Writing Time by 70% with AI

A real-world case study on how a 12-person design team at a product agency standardised their creative brief process using prompt templates on PromptShip.

Why AI Hallucinations Happen (and How to Reduce Them)

Article

person Admin•schedule 5 min read

Why AI Hallucinations Happen (and How to Reduce Them)

Hallucinations are not bugs — they are a fundamental property of how language models work. Understanding why they happen is the first step to minimising them.

The State of AI Coding Assistants in 2026

Article

person Admin•schedule 5 min read

The State of AI Coding Assistants in 2026

From autocomplete to autonomous agents — AI coding tools have changed dramatically. Here is where things stand and what to expect next.

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

Article

person Admin•schedule 5 min read

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

One founder. No team. A dozen AI-powered tools and a tight prompt library. Here is the workflow that runs a bootstrapped SaaS doing $15k MRR.

Recommended Prompts

claudeshieldTrusted

bookmark

Cold Email with Mutual Connection Reference (Warm Introduction Frame)

Write a cold email that leverages a mutual connection as a soft warm introduction — structuring the reference ethically, credibly, and in a way that transfers trust without making the mutual contact uncomfortable.

Trigger-Based Cold Email After Company Funding Announcement

Write a cold outreach email timed to a company's Series A/B/C funding round, using the investment as a natural hook to introduce your solution at the exact moment they're scaling.

OKR Framework for Early-Stage Startups

Generates a complete quarterly OKR framework — 3–5 Objectives with 3 Key Results each — calibrated for a startup's current stage and aligned to its fundraising milestones.

Cold Email with Peer Company Social Proof

Write a cold email that uses a recognizable peer company as social proof — without a formal case study — to create 'if they do it, we should' urgency in the prospect.

Pain-First Cold Email That Opens with the Prospect's Nightmare Scenario

Write a cold email that opens with a vivid, specific description of a painful scenario the prospect lives through — making them feel understood before you've introduced yourself.