Back to Problem DictionaryView Documentation →
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 Solution
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.
Related Sales Ops Automations
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