agency-pipeline-analyst

Diagnose pipeline health and surface at-risk deals from CRM deal-level data.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides revenue operations teams with rigorous, data-driven pipeline diagnostics that replace gut-feel forecasting and surface deals requiring immediate intervention. It reduces forecast misses by identifying velocity, engagement, and qualification signals that predict deal outcomes 30–60 days in advance.

Core Features & Use Cases

  • Pipeline velocity analysis: Compute velocity from qualified opportunity counts, average deal size, win rate, and sales cycle length to reveal leading revenue signals.
  • Coverage and quality-adjusted pipeline: Convert weighted pipeline into realistic coverage ratios by discounting stale or underqualified deals.
  • Deal health scoring (MEDDPICC + engagement + velocity): Combine qualification depth, engagement intensity, and progression velocity into a composite deal health score for prioritization.
  • Probability-weighted forecasting: Produce Commit / Best Case / Upside forecasts with confidence intervals using historical conversion, velocity weighting, and engagement adjustments.
  • Actionable interventions: Rank at-risk deals by impact and feasibility and recommend explicit next steps (e.g., schedule economic buyer meeting).
  • Use Case: Run a quarterly pipeline review to convert CRM exports into a probability-weighted forecast, surface the top 10 intervention deals, and quantify coverage gaps by segment.

Quick Start

Run a pipeline health analysis for the current quarter using a CRM export that includes stage, amount, close date, last activity, contacts, and MEDDPICC qualification fields.

Frequently Asked Questions about agency-pipeline-analyst

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

FAQPage Schema
How do I identify at-risk deals in my sales pipeline?

Identify at-risk deals by analyzing CRM data for velocity drops, stale engagement, and incomplete MEDDPICC qualification. This process surfaces opportunities requiring immediate intervention by scoring deal health against historical conversion patterns.

What is probability-weighted forecasting and how does it improve sales predictions?

Probability-weighted forecasting predicts revenue by applying historical conversion rates, velocity weighting, and engagement adjustments to pipeline deals. It produces Commit, Best Case, and Upside forecasts with confidence intervals, replacing gut-feel estimates with data-driven accuracy.

How do I calculate pipeline velocity to reveal revenue signals?

Calculate pipeline velocity by multiplying qualified opportunity counts, average deal size, and win rate, then dividing by sales cycle length. This reveals leading revenue signals by quantifying how quickly deals progress through your pipeline stages.

What CRM data do I need for a pipeline health analysis?

You need CRM deal attributes including stage, amount, close date, last activity, and contacts, along with historical closed-won and lost records with timestamps. These inputs compute velocity, MEDDPICC assessments, and engagement signals for diagnosis.

Can I use MEDDPICC qualification to prioritize sales interventions?

Yes, MEDDPICC qualification depth combines with engagement intensity and progression velocity into a composite deal health score. This score ranks at-risk deals by impact and feasibility, recommending explicit next steps like scheduling economic buyer meetings.

What is the best way to convert weighted pipeline into realistic coverage ratios?

Convert weighted pipeline into realistic coverage ratios by discounting stale or underqualified deals based on engagement signals and MEDDPICC completion. This quality-adjusted approach reveals true coverage gaps by segment and rep for quarterly reviews.