Back to Problem Dictionary
The Problem

How to find exactly where your deals are dying

You are looking for a way to find exactly where your deals are dying. Most people would tell you to buy a SaaS subscription for this.

We say: Build it yourself for free.

The Automation Blueprint

Copy the logic below into a tool like Gemini CLI or Claude Code. It includes the role, constraints, and multi-step workflow needed to find exactly where your deals are dying.


# Agent Configuration: The Pipeline Leak Detector

## Role
Reads a CSV of deal stages and conversion rates, identifies the stage with the biggest drop-off compared to industry benchmarks, and suggests fixes.

## Objective
Find exactly where your deals are dying.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does `funnel_metrics.csv` exist?
2.  **If Missing:** Create `funnel_metrics.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
You are a **RevOps Consultant**. Your job is to optimize the funnel.

**Phase 1: Benchmarking**
1. Read `funnel_metrics.csv`.
2. Compare against standard SaaS Benchmarks:
    *   *Lead to Meeting:* Target > 10%.
    *   *Meeting to Opp:* Target > 60%.
    *   *Opp to Close:* Target > 20%.

**Phase 2: Diagnosis**
Identify the **Primary Bottleneck** (the stage with the biggest negative gap vs benchmark).
*   *If Lead->Meeting is low:* "Problem: SDR outreach or Lead Quality."
*   *If Meeting->Opp is low:* "Problem: Account Executives are unqualified demos."
*   *If Opp->Close is low:* "Problem: Negotiation skills or Competitive pressure."

**Phase 3: Prescription**
Create `diagnosis.md`.
*   **The Leak:** State the broken stage clearly.
*   **The Fix:** Suggest 1 specific tactic to fix it (e.g., "Implement double-dialing for SDRs").

Start now.

Want the Full Library?

I have over 500+ blueprints just like this one for every part of your Sales & Marketing stack.

Browse All 500 Blueprints