Library/RevOps, Data & Analytics Support/Reporting Requests/Analyze Pipeline Performance by Lead Source
TestedRevOps, Data & Analytics SupportQuick Win (under 10 min)

Analyze Pipeline Performance by Lead Source

Summarize which lead sources produce the best and worst pipeline outcomes using a leads and outcomes dataset.

About this prompt

This prompt helps sales managers, directors, and RevOps analyze a leads and pipeline dataset to understand which sources — inbound content, events, demo requests, outbound — are producing real pipeline versus noise. It produces a ranked summary of source performance with hypotheses about why each source performs the way it does. Use it during quarterly pipeline reviews, before budget allocation decisions, or when the team suspects that certain sources are generating volume without generating revenue.Not all leads convert at the same rate, and not all pipeline is created equal — but most teams treat their lead sources as interchangeable until the number misses. This prompt takes a structured dataset of leads and their downstream outcomes (opportunities created, stage progression, close rate, ACV) and produces a clear performance ranking by source, along with analytical hypotheses about the drivers behind the differences. Paste your data into [lead_source_data] — a CRM export with source tagging and deal outcomes by row is ideal, but a summarized table with conversion metrics per source also works. The output identifies the highest-leverage sources worth investing in further, the worst performers worth cutting or reconsidering, and plausible explanations for the gaps (e.g., event leads close faster because they're already in-market, inbound content leads have longer cycles but higher ACV). This prompt is most useful for RevOps or sales leadership preparing a pipeline health review — not for individual reps. For best results, include at least 90 days of data and flag any sources that changed significantly in that period so the AI can account for recency bias.

The prompt

"Using this leads and outcomes dataset {lead_source_data}, analyze performance by lead source (e.g., demo requests, events, inbound content, outbound). Summarize which sources produce the best and wor
The rest of this prompt is Pro.Copying the full text is Pro. Browsing stays free, and 100 prompts are free in full.
Start Pro — $4.99/monthSee the free prompts
Copy prompt
☆ Save to library
Send to a teammate
Email it
Link copied — paste it in Slack
Open in
ClaudeChatGPTCopilotGemini
Copying the full text is Pro.

Variables to replace

LEAD SOURCE DATA

How to run it

  1. Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot — it's tuned to run in any of them.
  2. Replace the variables — swap each bracketed token for your deal's specifics. The variables list above explains every field.
  3. Make it yours — run it, keep what's strong, and tighten your inputs on the next pass. The prompt improves with your context.

What good output looks like

Make it yours

StageOngoing/Cross-Stage
SeatSales Manager, RevOps / Sales Ops, Sales Director
DifficultyAdvanced
Time to valueQuick Win (under 10 min)
Works withAI-Agnostic
CategoryRevOps, Data & Analytics Support
Promptifi ProFull text of all 2,900+ prompts, every workflow, unlimited saves.Start Pro — $4.99/moor $99 once, lifetime
You're ProFull library open. Copy, save, and chain anything.
More from the library

Reps who ran this also ran.

Evaluation
PRO

Write Live-Call Rebuttals for Three Common Objections

This prompt produces natural-sounding spoken rebuttals for up to three sales objections, each under 50 words and built for use in a live call rather than a written response. It is built for AEs, inside sales reps, sales managers preparing coaching material, and founder-led sellers who need to handle recurring objections consistently. Use it when you have identified the specific objections your deals run into and want structured, ready-to-speak responses.

AE, Inside Sales, Sales Manager, Founder-Led SellerAI-Agnostic
Open →
Discovery
PRO

Extract Deal Intelligence from Call Transcript

This prompt helps AEs and Sales Engineers extract structured deal intelligence from a discovery or qualification call transcript. It produces a stakeholder map, key intelligence summary, current-state environment snapshot, red and green flags, MEDPICC scoring with rationale, and prioritized next steps. Use it immediately after any prospect call where you need to update your CRM, align internally, or prepare for the next conversation.

AE, Sales EngineerAI-Agnostic
Open →
Prospecting
PRO

Generate 10 Angle-Diverse Cold Email Variants Under 75 Words

This prompt generates ten cold email variants — one per named angle — each under 75 words, built around a no-oriented question and an easy out. It is designed for SDRs, BDRs, and AEs who need a full A/B test suite for a specific persona and industry without duplicating approach or question type. Use it when you are launching a new sequence and want to cover the full angle spectrum before committing to a primary message.

SDR,BDR,AEAI-Agnostic
Open →

Stop rewriting. Start closing.

Browse the librarySee pricing
Copy prompt
Start Pro — $4.99/mo