Audit consulting pipeline for stalled deals

Spot fake pipeline confidence, identify stagnant proposals, and categorize deals into revive or purge lists. Use this during your quarterly business review.

You getHealth Summary, triage Table and two Revive Message Drafts

Prompt

Prompt
Act as a sales operations director for solo consultants. Audit the quarterly pipeline data pasted below to remove false pipeline confidence.

- Flag any deal where the last client contact exceeds 14 days or where proposal review has stalled.
- Assign each stalled deal to one category: Revive (needs single crisp follow-up), Demote (push to next quarter nurture), or Purge (mark closed-lost).
- Provide one direct, non-needy revive message draft for the top two salvageable deals.
- Note that this is business planning guidance, not formal financial advice.

Output format:
1. Health Summary (total deals, stalled deal count, percentage at risk)
2. Triage Table (columns: Deal Name, Deal Value, Days Silent, Recommended Action)
3. Two Revive Message Drafts
4. Recommended Pipeline Clean-up Next Steps

My deal pipeline data is below:

Example output

Example for: quarterly pipeline data showing 6 active consulting opportunities

  1. Health Summary
  • Total Deals: 6
  • Stalled Deal Count: 3
  • Percentage at Risk: 50% ($42,000 of $84,000 total active pipeline)
  1. Triage Table
Deal NameDeal ValueDays SilentRecommended Action
Nexus ERP Strategy$22,00024Demote (Budget frozen until Q3)
Vertex Brand Audit$12,00018Revive (Decision maker awaiting board sign-off)
Ardent Ops SOW$8,00031Purge (Ghosted after three follow-ups)
BluePeak Discovery$15,0005Active (Next call scheduled Thursday)
Kestrel Growth Sprint$18,0007Active (Reviewing contract draft)
Lumina Workshop$9,00016Revive (Pending final team headcount)
  1. Two Revive Message Drafts
  • Vertex Brand Audit:
    "Hi Mark, circling back on the brand audit scope we discussed last month. Are you still targeting an April kickoff, or should we pause this until your board wraps their current review?"
  • Lumina Workshop:
    "Hi Sarah, following up on the leadership workshop plan. Did you get final confirmation on team headcount, or should we release those tentative calendar holds for next month?"
  1. Recommended Pipeline Clean-up Next Steps
  • Archive Ardent Ops as closed-lost in your CRM today to reflect realistic pipeline totals.
  • Move Nexus ERP to an automated quarterly check-in sequence for June.
  • Send the two revive emails before end-of-week to set next week's schedule.
Written by AI from this prompt. Your results will vary.

Paste your active deal names, values, stages, and last contact dates directly below the prompt in ChatGPT, Claude, or Gemini. As a follow-up, ask the model to draft a specific break-up email for any deal marked as Purge.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Freelancing & Consulting
Freelancing & Consulting

Turn client interview notes into a case study

Transforms raw interview transcripts into a structured, persuasive consulting case study. Use it right after client debriefs to update your portfolio quickly.

Freelancing & Consulting

Uncover client budget and timeline constraints

Obtain real financial limits and critical deadlines during sales calls without awkward friction. Designed for freelance strategists before writing proposals.