Pipeline Hygiene

Inactive Opportunity Review Queue

Auto-surface deals that have gone quiet, no activity for N days, into a weekly review queue so stale opportunities get a deliberate decision (push, pause, or close) instead of inflating the forecast forever.

Start a Project All Case Studies

4 to 7 days: build time
4: outcomes
4: stack tools
6: build steps

Built with real HMX CRM tool paths

GGoHighLevel smart lists / HubSpot active lists

LLast-activity + stage-age fields

GGHL Workflows (inactivity timer + owner task)

PPipedrive rotting-deal indicator alternative

GGoHighLevel smart lists / HubSpot active lists

LLast-activity + stage-age fields

GGHL Workflows (inactivity timer + owner task)

PPipedrive rotting-deal indicator alternative

Outcome
signals

These are the real outcome statements attached to this HMX CRM case study.

stale surfaced: quiet deals flagged automatically
forced decision: push, pause, or close, no drift
honest forecast: dead weight removed from the total
weekly habit: review runs on a fixed cadence

Case architecture

Inactive Opportunity Review Queue Architecture

6 nodes

per-stage inactivity

Track last-activity and

GoHighLevel smart lists /

Last-activity + stage-age

Unrouted Queue

CRM Outcome

01per-stage inactivity
Auto-surface deals that have gone quiet, no activity for N days, into a weekly review queue so stale opportunities get a deliberate decision (push,...
02Track last-activity and
Track last-activity and time-in-stage on every open opportunity
03GoHighLevel smart lists /
GoHighLevel smart lists / HubSpot active lists stores the canonical CRM state for Inactive Opportunity Review Queue so reporting and follow-up read from one place.
04Last-activity + stage-age
Build a review queue/view that surfaces every deal breaching its threshold
05Unrouted Queue
When automation confidence is low, route the record to a manual owner with the source, stage, and last action attached.
06CRM Outcome
stale surfaced quiet deals flagged automatically; forced decision push, pause, or close, no drift; honest forecast dead weight removed from the tot...

Problem

The operating gap

Open deals with no recent activity linger in the pipeline, making the forecast look healthier than it is and burying the deals that genuinely need a nudge. Reps don't notice the rot because nothing flags inactivity.

Build

What gets built

Define inactivity by stage (a top-of-funnel deal and a late-stage deal tolerate different silence), build a review queue that surfaces breaches, and attach a forced decision, advance with a next step, pause with a wake date, or close with a lost reason, run on a weekly cadence.

Build
steps

Inactive Opportunity Review Queue uses a CRM operating layer for CRM Systems. Auto-surface deals that have gone quiet, no activity for N days, into a weekly review queue so stale opportunities get a deliberate decision (push,... The architecture connects per-stage inactivity, gohighlevel smart lists /, last-activity + stage-age, and crm outcome with an explicit control path.

01Set per-stage inactivity thresholds so 'stale' means something different early vs late
02Track last-activity and time-in-stage on every open opportunity
03Build a review queue/view that surfaces every deal breaching its threshold
04Attach a required decision to each: advance with a next step, snooze with a wake date, or close with a reason
05Schedule the queue into a recurring weekly review so it's a habit, not a fire drill
06Report on how much pipeline value is currently stale so the team sees the cost

Stack

Tools and layers

GoHighLevel smart lists / HubSpot active lists
Last-activity + stage-age fields
GHL Workflows (inactivity timer + owner task)
Pipedrive rotting-deal indicator alternative

Capture layer: Set per-stage inactivity thresholds so 'stale' means something different early vs late
Rules layer: Track last-activity and time-in-stage on every open opportunity
CRM State layer: GoHighLevel smart lists / HubSpot active lists stores the canonical CRM state for Inactive Opportunity Review Queue so reporting and follow-up read from one place.
Automation layer: Last-activity + stage-age fields handles routine steps while define inactivity by stage (a top-of-funnel deal and a late-stage deal tolerate different silence), build a review queue that surfaces breaches, an...
Human Review layer: stale surfaced quiet deals flagged automatically; forced decision push, pause, or close, no drift; honest forecast dead weight removed from the tot...

Data flow

01Set per-stage inactivity thresholds so 'stale' means something different early vs late
02Track last-activity and time-in-stage on every open opportunity
03Build a review queue/view that surfaces every deal breaching its threshold
04Attach a required decision to each: advance with a next step, snooze with a wake date, or close with a reason
05Schedule the queue into a recurring weekly review so it's a habit, not a fire drill
06Report on how much pipeline value is currently stale so the team sees the cost

Controls

Open deals with no recent activity linger in the pipeline, making the forecast look healthier than it is and burying the deals that genuinely need...
Define inactivity by stage (a top-of-funnel deal and a late-stage deal tolerate different silence), build a review queue that surfaces breaches, an...
When automation confidence is low, route the record to a manual owner with the source, stage, and last action attached.

Research
basis

Build a CRM with the same traceability

The intake starts with lead sources, stages, and follow-up rules so the scope stays honest.