AI-Tracked Pipeline Health for Startups (MCP Playbook) [2026]
Hygiene signals worth tracking
Before automating, agree what unhealthy means for your stage. Seed teams can start with five signals — no custom BI required:
| Signal | Definition | Default threshold |
|---|---|---|
| Stale opp | Open deal, no activity logged | 14 days |
| Blank next step | Commit/Best Case with empty next step | Any commit deal |
| Single-thread | One contact on deal > $X | Set X to your ACV floor |
| Close date slip | Close date moved twice in 30 days | Flag for standup |
| Inbound neglect | Lead unassigned past SLA | 4–24h by plan — see inbound playbook |
Document thresholds in a Workspace doc — agents read the same rules each week. Align with board-ready forecast discipline.
Weekly AI-tracked ritual (30 minutes)
- Run read-only MCP scorecard (prompts below) — paste output to standup doc
- Human spot-check — validate two flagged deals in Momentum
- Assign owners — stale cleanup, next-step updates — in standup, not via agent bulk edit
- Archive prompt output — link doc in calendar series for audit trail
Connect clients using Claude Desktop setup or Cursor playbook — same keys policy.
Four MCP prompts for pipeline health
1. Weekly commit scorecard (read-only)
Generate a pipeline health scorecard for commit and best-case deals closing this month. Sections: (A) deals missing next step, (B) deals with no activity in 14+ days, (C) total commit amount by owner, (D) top three risks in one sentence each. Tables only — no record updates.
2. Stage aging report (read-only)
List open opportunities grouped by stage with average days in stage and count. Flag stages where any deal exceeds 2× the team’s median days-in-stage. Read-only.
3. Inbound + commit collision (read-only)
List inbound leads from last 7 days still unassigned or past SLA. Separately list commit deals where account has open P1/P2 support case. Highlight accounts appearing in both lists. Read-only.
Extends agentic support handoff thinking.
4. Forecast narrative draft (human-approved)
Draft 120-word forecast summary for internal use: commit total, deal count, largest risk, one inbound trend if visible. Mark every numeric claim with source field. Do not send externally — draft for founder edit only.
Governance for AI-tracked workflows
- Separate MCP keys:
founder-rovsops-draft— see API key governance - No customer PII in prompt files stored in public Git repos
- Rotate keys on offboarding; review Admin audit monthly
- Escalate to write tools only with documented approval — never auto-close lost
When to add Insight dashboards
When deal volume exceeds what a weekly narrative can carry, promote recurring signals to Insight charts — activity by rep, stage conversion, mail response times. AI tracking remains the exception layer; dashboards are the trend layer.
Example Monday scorecard output (structure)
Paste MCP output into a Workspace doc with this skeleton so standup stays scannable:
| Section | Content | Owner action |
|---|---|---|
| Commit summary | Count, total amount, vs last week | Founder validates top 3 deals |
| Exceptions | Stale, blank next step, SLA breaches | Assign rep + due date in CRM |
| Inbound | Unassigned leads, source breakdown | Revise routing if recurring |
| Support collisions | Commit accounts with open P1/P2 | CS + AE sync before forecast |
| Forecast note | 120-word draft | Edit for board deck — do not auto-send |
Store one doc per week in a Drive folder linked from your standup calendar series. New hires read four weeks of scorecards to learn what “healthy” looks like — faster than shadowing every call.
Connecting AI tracking to quote-to-cash
Pipeline health is not only top-of-funnel. Add a monthly read-only pass for closed-won opps without invoice issued — pairs with quote-to-cash playbook. Agents can list exceptions; finance still owns Ledger actions.
Anti-patterns
- Agent bulk-updates stages Friday night — humans own commit classification
- Scorecard without spot-check — models summarize wrong once per quarter is enough to hurt
- Exporting CSV to public ChatGPT — use MCP on org workspace instead
- Tracking vanity counts — hygiene signals beat logo totals for seed forecast