I Gave an AI Agent Three Years of Deal History. Here's the First Pattern It Found.

A developer connected Claude to a client's HubSpot pipeline via an MCP server and, after feeding it three years of closed deal history, found that time spent in one middle sales stage past a certain threshold predicted Closed Lost outcomes better than deal size or sales rep. The finding illustrates how an agent with raw-record access can restate questions a fixed dashboard never asks, rather than running smarter queries.

I connected Claude to a client's HubSpot pipeline through our MCP server, gave it three years of closed deal history, and asked one open question: "what should I be worried about in this pipeline that isn't in the current dashboard." No leading question, no hint at what I already suspected. The first thing it flagged wasn't a number. It was a stage. It noticed that a disproportionate share of deals that eventually closed had spent an unusually long stretch sitting in the same middle stage before moving, and that deals which spent longer than that stretch in that stage were far more likely to eventually go to Closed Lost than the ones that moved through quickly. Not "deals in this stage are risky," which is a fact you could get from a funnel chart. The specific claim was: time spent in this one stage , past a certain point, predicted the outcome better than any other single field in the record, including deal size and sales rep. That's a pattern a dashboard built to show funnel counts by stage will never surface, because a funnel chart answers "how many deals are in each stage right now," not "how long has each deal individually been sitting there, and does that duration itself carry signal." The agent wasn't running a smarter query, it was asking a different question of the same data. A saved dashboard answers the question it was built to answer, forever, until someone rebuilds it. An agent with read access to the raw records and no fixed question can restate the question every time you ask it something new. The gap between those two things is the entire reason "AI reading your CRM" is worth building rather than just being a novelty: Simplified shape of what the agent actually queried, once it decided stage duration was worth checking def stage duration vs outcome deals: list dict - dict: """deals: {stage, days in stage, outcome}, ... outcome is 'won' or 'lost'. Groups by stage, then checks whether duration correlates with the eventual outcome inside that stage. """ from collections import defaultdict from statistics import mean by stage = defaultdict lambda: {"won days": , "lost days": } for d in deals: bucket = "won days" if d "outcome" == "won" else "lost days" by stage d "stage" bucket .append d "days in stage" return { stage: { "avg days won": mean v "won days" if v "won days" else None, "avg days lost": mean v "lost days" if v "lost days" else None, } for stage, v in by stage.items } No agent needed to write that function, I could write it myself in five minutes. What I wouldn't have done in five minutes is think to ask the question in the first place, across every stage, every rep, and every quarter, without a hypothesis already narrowing where I looked. That's the actual value: not a smarter calculation, a wider search. The underlying problem the agent surfaced a stage that quietly concentrates risk is the same pattern behind what gets lost after every discovery call https://artefactventures.com/en/blog/conversation-intelligence-for-sales when there's no structured way to capture why a deal stalled. It's also a direct instance of revenue leakage from architecture gaps https://artefactventures.com/en/blog/revenue-leakage : the CRM had the data the whole time, and nobody had asked it the right question. Try it on your own pipeline If you want to see what an agent finds in your own pipeline before you decide whether it's worth running for real, the MCP server is free to install: And if what it finds is the kind of thing you'd rather walk through with someone than read off a screen alone, book a call https://artefactventures.com/en/contact?hsLang=en&utm source=devto&utm medium=guest content&utm campaign=devto-2026-q4-waterfall&utm content=devto ai-agent-deal-history and bring what it surfaced. If you've pointed an agent at your own CRM with no leading question, I'd like to hear what it found that your dashboard hadn't shown you.