A $120M ARR enterprise SaaS company with 210 quota-carrying reps engaged us after their VP of Sales Operations came to a hard conclusion: four people on her team were spending every Friday assembling the Monday pipeline deck, and it needed to stop. Twenty percent of a four-person team's capacity, every single week, going to data extraction, formatting, and assembly — with nothing left for the actual sales operations work the team existed to do.
The Problem We Were Hired to Solve
The Monday pipeline review was the CRO's most important recurring meeting. It set tone, surfaced risk, and directed resource allocation for the week. But the first 20 minutes of every call were spent establishing shared understanding of the numbers — where pipeline stood, what had moved, what was at risk. That was time that should have been spent making decisions, not reading the room into alignment.
Quota attainment analysis, territory modeling, comp plan modeling, deal desk support — the strategic work that a high-performing sales ops team should be doing — was being squeezed into four days between pipeline calls. In practice, it barely got done.
Sales operations exists to give revenue leaders better information faster. If SalesOps is spending a full day a week making a deck, it's doing sales administration — not sales operations.
What We Built
The Monday pipeline deck: We built a Friday-evening automation that pulls pipeline data from Salesforce via API, segments it by region, stage, product, and close quarter, compares it against prior-week snapshots to surface week-over-week movement, and populates the CRO's standard deck template. We configured Claude to write the executive summary and regional callouts using the data as input, in the style and voice of the manually-written version. The deck lands in the CRO's inbox by 7am Monday.
Rep-level forecast briefs: Every Monday morning, each of the 210 reps receives an automated personal pipeline brief: current quarter commit vs. quota, top five deals by close probability, deals that slipped from the prior week, and two or three data-driven talking points for their own forecast call. Reps stopped going into 1:1s without knowing where they stood.
Win/loss pattern analysis: Every two weeks, a win/loss analysis runs across the prior period's closed deals — surfacing patterns in deal characteristics, competitor presence, rep tenure, and sales cycle length that correlate with wins vs. losses. A summary report goes to the CRO and regional VPs. What used to be a quarterly manual analysis project now runs continuously on autopilot.
Stage progression alerts: Deals that haven't moved stages in 21 days and are in the current quarter trigger an automated alert to the rep's manager. No more deals aging silently in Stage 3 while the forecast assumes they'll close.
What Changed at the Monday Call
Within three weeks of launch, the CRO described the change simply: the Monday call had changed character. The first 20 minutes were no longer spent establishing shared understanding. Everyone arrived having read the deck, with an opinion already formed. The call became a working session — which deals needed executive support, where to deploy marketing resources, which reps needed coaching. "The call used to be an information transfer," she told us. "Now it's a working session. The difference is enormous."
The sales ops team recovered their Fridays. In the first quarter after launch, they completed a territory redesign analysis that had been deprioritized for 14 months. They also built a rep performance prediction model — identifying reps at risk of missing quota six weeks out rather than three — that regional VPs credited with saving two at-risk quarters.
Why This Engagement Pattern Works
Pipeline reporting automation delivers the highest ROI of almost any first project for sales operations teams, because the cost is visible (a full day every week) and the benefit is immediate. The technical requirements are straightforward: a Salesforce connected app, an automation platform, a templating layer, and a language model for narrative generation. The build takes four to six weeks. The output is a sales intelligence function that runs in real time — and unlocks everything else a great SalesOps team wants to do but never has time for.
Running sales operations at scale? Let's talk about what pipeline automation could look like for your team.
Get Your Free AI Audit