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?

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.

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.

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.

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.

What changes

Nothing about these questions requires new software or a process initiative. They move the review's attention from motion to silence, which is where the money actually goes missing. Teams that ask them 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.