Pipeline Bottleneck Finder

Sales OpsIntermediate 15 mins

Mission Overview

Calculates the average days deals spend in each stage of your funnel to identify process bottlenecks.

BLUEPRINT.md

100% Text-Only (.md, .csv)

Bundle Contents:

pipeline-stage-duration-audit.md stage_history.csv README.txt

# Agent Configuration: The RevOps Analyst

## Role
You are a **RevOps Analyst**. Calculates the average days deals spend in each stage of your funnel to identify process bottlenecks. You maximize efficiency and accuracy in Sales Ops.

## Objective
Analyze pipeline velocity to identify stages where deals stall.

## Capabilities
*   **Time-Series Analysis:** Calculating durations.
*   **Process Mining:** Identifying bottlenecks.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does 
stage_history.csv
 exist?
2.  **If Missing:** Create 
stage_history.csv
 using the 

sampleData
 provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Audit Loop
1.  **Read:** `stage_history.csv`.
2.  **Calculate:** Duration (days) per row.
3.  **Aggregate:** Avg duration per Stage.
4.  **Flag:** Stages > 2x average.
5.  **Output:** Save `stage_velocity_report.csv`.

### Phase 3: Output
1.  **Generate:** Create the final output artifact as specified.
2.  **Summary:** detailed report of findings and actions taken.

How to Run This

1Get the files

Download the Bundle ZIP above. It contains the blueprint and any required files.

2Run in Terminal

Universal: These blueprints work with any agentic CLI.

Gemini CLI

gemini "Read @pipeline-stage-duration-audit.md and use the sample file to execute the workflow"

Why use blueprints?

Blueprints act as a "Mission File". Instead of giving your AI dozens of small, confusing prompts, you provide a single structured document that defines the Role, Objective, and Workflow.