You Know What Changed This Week. Do You Know If That's Normal?
Your pipeline review this week showed that you lost $540K and pushed four deals out. Bad week? Maybe. Or maybe that’s exactly what happens every third week of the quarter, and you just never had the data to see the pattern.
Single-period pipeline analysis tells you what happened. It doesn’t tell you whether that’s normal.
The pattern problem
Most teams analyze their pipeline in isolation. This week’s flow view shows the changes. Last week’s is gone — or buried in a spreadsheet someone exported. The week before that doesn’t exist anymore.
Without trend data, every week feels like a new crisis. The pipeline dropped $400K — is that alarming or is that what always happens mid-quarter? We won six deals — is that good or below average? New pipeline added $800K — is that enough to cover what we’ll lose next month?
You can’t answer any of these questions by looking at a single period. You need to see the pattern.
What trend analysis reveals
When you compare pipeline flow patterns across six months or four quarters, things jump out that weekly analysis misses:
Seasonal patterns. Maybe your pipeline always shrinks in December and explodes in January. That’s not a crisis — it’s a cycle. But if you don’t see the trend, December feels like the sky is falling every year.
Degrading pipeline generation. New deals per month trending down over the last four months is a slow-moving problem that’s invisible week to week. By the time it shows up in the forecast, it’s too late to fix.
End-of-quarter compression. How much of your pipeline movement happens in the last seven days of the quarter? If the answer is “most of it,” that tells you something about your team’s deal discipline — and it’s a pattern you can change.
Win/loss ratio shifts. Winning more deals than you’re losing is good. But if the trend shows the ratio narrowing over time, you have a competitive problem developing that a single month’s data won’t surface.
The average as a baseline
The most useful number in a trend analysis isn’t any single month — it’s the average. When you know that a typical month in your pipeline produces $1.2M in new deals, loses $400K, and wins $600K, you have a baseline. This month’s numbers suddenly have context.
Your current month is 20% below average on new pipeline? That’s a flag worth investigating. Your lost deals are right on the average? That’s normal attrition, not a problem to solve.
Without the baseline, everything is reactive. With it, you can plan.
Building trends into your rhythm
The best time to review trends isn’t every week — it’s monthly or quarterly, when the patterns have enough data to be meaningful.
- Monthly: Open the trend view at the start of each month. Compare the last six months. Are we generating enough pipeline? Is the win rate holding? Is the loss rate growing?
- Quarterly: Before the QBR, look at the last four quarters side by side. How does this quarter compare? What’s the trajectory?
- Board prep: When the board asks “how is this quarter different from last quarter?”, the trend view is the answer — not an opinion, but data.
Flow Trends is part of Pipeline Reviews, available in RevWorks Basic and RevWorks AI. See it on your data.
