Five questions that make a pipeline review tell the truth

The weekly pipeline review has a design flaw: it reviews the pipeline. Deals that are moving get discussed, deals with activity get inspected, and the meeting ends with everyone feeling current. Meanwhile the records quietly costing you money are precisely the ones with nothing new to discuss, so they never make the screen. A review of what's moving is a highlight reel, not an audit.

Five questions fix that. Each one is a saved filter a CRM admin can build in minutes; ask them in the same meeting, every week, and the silent part of the portal starts reporting to you.

1. What entered its stage more than 30 days ago and hasn't moved?

Stage age, not deal age. A deal can be young overall and still be stuck. And a deal stalled in proposal stage is aging at the exact moment it was closest to closing. Sort by value, look at the top ten, and ask each one the only question that matters: what is the next step, and who owns it?

The 30-day threshold is a starting point, not a law. Better: pull your own median days-per-stage and flag anything past the 75th percentile for its stage. A deal twelve days into a stage that usually takes six is telling you something a calendar month would hide.

2. Which open deals have no scheduled next activity?

An open deal with no task and no meeting on the calendar isn't being worked; it's being remembered, occasionally. This filter is the single fastest leak detector in most portals. The fix costs nothing: every open deal gets a next step with a date, or it gets closed honestly.

Watch for the workaround that follows: tasks titled "follow up" due in six weeks, created to satisfy the filter. The standard is a real next step a buyer would recognize (a scheduled call, a document owed, a named decision date), and the review should spot-check two or three at random. The point isn't compliance. It's that a deal with no honest next step is a decision being deferred, and deferred decisions default to no.

3. What did we close-lost on timing last quarter, and who has gone back?

Timing reasons expire. If nobody is assigned to revisit the "not now" pile on a schedule, the answer to "who has gone back" is nobody, and a list of buyers who already evaluated you is rotting on a shelf. The full re-approach playbook, including which records qualify and the two-line message that works, is in "not now" is not "no".

In the review itself, this question needs sixty seconds: how many timing losses aged past 90 days this week, and whose name is on the follow-up task. If the answer to the second half is silence two weeks running, the motion needs an owner, not a reminder.

4. Which records does nobody own?

Departed reps, reshuffled territories, imports that never got assigned. Ownerless records can't leak in the review because they can't appear in anyone's book. Count them monthly; reassign by name, not in bulk, because a bulk transfer moves ownership without moving responsibility. The full procedure for the departure case, which is where most ownerless records come from, is the rep offboarding checklist.

5. What arrived more than 90 days ago and has never been touched?

The zero-activity filter is the humbling one: the marketing spend that cleared, the forms that were filled, the buyers who raised a hand and heard nothing. Whatever the number is, it's the most expensive list your company owns. Where those leads go missing, and the first-touch standard that stops the flow, is covered in someone else is calling the lead you paid for.

Running the meeting

Mechanically, this works as a second half bolted onto the existing review: twenty minutes for what's moving, ten for what isn't. The five filters live on one dashboard, each with a trend line, because the trend is the real report: a graveyard count falling week over week means the system is tightening; a flat one means the meeting is theater.

Two rules keep it honest. First, no relitigating: when a record surfaces, the only discussion is the next step, not the archaeology of how it got there. Reviews that punish the surfacing teach people to hide records, and hidden records are the expensive kind. Second, every surfaced record leaves the meeting with a name and a date attached, or it gets closed honestly. Surfacing without assignment is just guilt with a dashboard.

Teams that ask these questions weekly stop accumulating dormant records at the old rate, not because anyone works harder but because silence finally has somewhere to be seen. The first time through, the filters usually return more than anyone expects. That backlog is answerable too; it's what a record-by-record audit is for, and it's the fastest way to turn the pile the review just found into a number the CFO will read.