Pipeline review analysis: AI prompt for sales

A ready-to-run prompt for data analysis work in B2B sales. It assigns the AI a specific senior role, takes your details as variables, and defines the output format — so the first result is usable, not a warm-up.

What this prompt does

Act as a RevOps analyst. It structures the request the way experienced practitioners brief a colleague: context first, then explicit deliverables, then quality constraints.

Best for

Sales professionals — and anyone doing this work — who need data analysis handled to a professional standard for prospects and buying committees. Typical moments: discovery calls, proposals and renewal conversations.

Before you use it

Have these details ready to replace the highlighted variables:

• [paste CSV/data]
• [X]

The prompt

Act as a RevOps analyst. Here is my pipeline export: [paste CSV/data]. Analyze: conversion rates by stage, average days in stage, deals stalled beyond [X] days, win rate by source and by deal size band. Flag the 5 deals most at risk with reasons, and give 3 process changes the data supports. Output tables first, narrative after.

Quality checklist before you run it

• Paste real data or a representative sample, not a description of it
• Sanity-check every calculated number independently
• Ask the model to state its assumptions before trusting conclusions

Common mistakes

• Trusting output numbers without independent spot-checks
• Describing your data instead of pasting a real sample
• Acting on findings whose assumptions you never read

When to use it — and when not to rely on it

Use it whenever data analysis would otherwise start from a blank page. Don't rely on it as a finished product: outputs need your judgment, your facts, and — in regulated work — professional review.

Related prompts

• KPI tree builder — Consulting
• Cold outreach sequence — Sales
• Discount pushback playbook — Sales
• Objection response library — Sales
• Sales demo storyline — Sales
• Comparative market analysis — Real Estate

Logical next step

After this, most sales teams move on to Cold outreach sequence.

All Sales prompts · All Data Analysis prompts · Search the full library