agency-pipeline-analyst

Analyze CRM pipeline data to identify at-risk deals and forecast variance.

Updated Feb 11, 2026
One-click install
npx skills add https://github.com/augustoheiss/LogicDefense --skill agency-pipeline-analyst-augustoheiss
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: agency-pipeline-analyst
Source: https://github.com/augustoheiss/LogicDefense/tree/main/.gemini/skills/agency-pipeline-analyst
Command: npx skills add https://github.com/augustoheiss/LogicDefense --skill agency-pipeline-analyst-augustoheiss

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill identifies at-risk deals, hidden velocity problems, and forecasting blind spots in CRM pipelines so revenue teams can act before quarters are missed.

Core Features & Use Cases

  • Pipeline velocity & coverage analysis: Calculate qualified-opportunity throughput, average deal size, win rate, and sales cycle to quantify revenue velocity and coverage by segment, rep, and source.
  • Deal health scoring with MEDDPICC: Combine qualification depth, engagement intensity, and progression velocity into a composite health score to surface late-stage underqualified deals and prioritise interventions.
  • Probability-weighted forecasting: Produce Commit / Best Case / Upside forecasts using historical conversion, velocity adjustments, engagement signals, and seasonal patterns, with confidence intervals and divergence analysis from stage-weighted CRM totals.
  • Actionable interventions & coaching: Rank at-risk deals by impact and feasibility and produce specific next steps (e.g., schedule economic buyer meeting, assign executive sponsor, or disqualify) to convert reviews into working sessions.

Quick Start

Analyze the current CRM pipeline and produce a Commit/Best Case/Upside forecast with deal-level MEDDPICC scores, velocity diagnostics, and prioritized intervention recommendations.

Frequently Asked Questions about agency-pipeline-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What is probability-weighted forecasting and how does it apply to pipeline analysis?

Probability-weighted forecasting produces Commit, Best Case, and Upside projections by applying historical conversion rates, velocity adjustments, and seasonal patterns. It generates confidence intervals and highlights divergence from standard stage-weighted CRM totals.

What CRM deal-level fields are required for MEDDPICC deal scoring?

Pipeline velocity and coverage analysis calculates qualified-opportunity throughput, average deal size, win rate, and sales cycle length. This quantifies revenue velocity and coverage metrics across individual sales segments, reps, and lead sources.

Can I generate specific coaching interventions for at-risk pipeline deals?

MEDDPICC deal scoring and pipeline analysis require deal-level CRM fields including opportunity stage, amount, close date, activity timestamps, contacts, and MEDDPICC qualification data to accurately calculate composite health scores and probability-weighted forecasts.

How do I benchmark stage conversion rates across my sales pipeline?

Yes, the analysis ranks at-risk deals by revenue impact and feasibility, then produces specific next-step coaching interventions. Recommended actions include scheduling economic buyer meetings, assigning executive sponsors, or disqualifying stalled opportunities.

Why does my CRM forecast diverge from probability-weighted projections?

Stage conversion benchmarking applies historical pipeline data across sales segments and reps to identify velocity bottlenecks. It calculates win rates and progression metrics to pinpoint where deals stall in the sales cycle.

What is the best way to analyze pipeline velocity bottlenecks and deal health?

Forecast divergence occurs when probability-weighted projections adjust for historical conversion, velocity, and engagement signals, causing them to differ from stage-weighted CRM totals. The analysis highlights these gaps to reveal hidden forecasting blind spots.