Stale opportunity alerts: key rules: Define 'stale' using your sales process, not fixed days.; Trigger alerts based on stage entry or last customer response, not record-modified dates.; Suppress alerts during scheduled next steps and redirect to current owner if ownership changes.
Image: CRM Stack

Automation

Part of CRM automation

Triggering alerts for stale opportunities

Define an actionable stale-deal signal, choose the right time trigger and avoid repeated CRM alerts that lack a clear resolution.

A stale-opportunity alert should explain what needs review, reach the accountable person and stop once the condition is resolved. Define “stale” from the sales process first: a past close date, no planned next activity and a long time in one stage are different signals.

Choose a reason the owner can act on

SignalQuestion for the ownerPossible resolution
No next activityIs there a specific next action?Schedule it or record why the deal is waiting.
Close date has passedIs the date still realistic?Confirm a revised date or close the deal as appropriate.
Stage duration exceeds the team’s review pointWhat shows progress?Record it, revise the stage or escalate a blocker.

A review point should come from the team’s sales process and reliable data, not an assumed universal number of days.

Define the clock and exclusions

Decide when the clock starts: stage entry, the last meaningful customer response, an agreed decision date or another field the team maintains. A generic record-modified date can move when someone corrects a typo, concealing an unchanged customer situation.

Decide how weekends, public holidays, long procurement periods and customer-requested pauses affect the review date.

Exclude closed opportunities. Consider suppressing an alert while a genuine next step is scheduled, and define when that suppression ends. If ownership changes, direct any later alert to the current owner.

Include the opportunity, alert reason and relevant date. Avoid repeated messages while the same unresolved condition remains true.

Match the trigger to the time rule

An alert based on elapsed time may need a scheduled check or a date-based action. HubSpot workflows can be enrolled manually, based on a set frequency or through specific enrolment triggers. Zoho CRM workflow rules can use date fields and scheduled actions.

None of these features establishes that the chosen timestamp measures meaningful sales progress.

Before wider use, check a recently active deal, an overdue deal, a deal with a future activity, a paused deal, a closed deal and a deal whose owner changes before the alert time. Inspect whether the alert reaches the right person and whether it stops after resolution. Review dismissed alerts; repeated legitimate waiting reasons may indicate that the rule or its underlying data needs adjustment.

More from Automation