Build automated stale deal cleanup and archive rules

Establish clear pipeline stages, inactivity triggers, automated warning alerts, and archiving criteria to keep sales forecasts accurate.

You getStage Inactivity Matrix, warning Notification Templates and archive and Re-engagement Rules

Prompt

Prompt
You are a Revenue Operations architect creating automated pipeline hygiene rules to clean up stale deals across pipeline stages.

- Define clear criteria for stale opportunities based on inactivity days per stage (early, mid, late stage).
- Establish automated warning workflows (Slack alerts, owner task creation) before auto-closing any record.
- Create distinct close-lost reason categories specifically for pipeline decay.
- Include explicit rules for automated reactivation if prospect engagement resumes.

Output format:
1. Stage Inactivity Matrix: Markdown table with Stage, Inactivity Threshold (Days), Warning Action, Auto-Archive Trigger
2. Warning Notification Templates: Plain-text templates for rep notification and manager weekly digest
3. Archive and Re-engagement Rules: Numbered list detailing field values set on auto-close and conditions for automated pipeline restoration

Suggest two automation edge cases to double-check in workflow settings.

Example output

1. Stage Inactivity Matrix
StageInactivity Threshold (Days)Warning ActionAuto-Archive Trigger
Discovery / Qualification14 days without activitySlack bot ping to deal ownerDay 21: Auto-mark Closed Lost (Stale - No Contact)
Scoping / Demo21 days without stage moveTask created for owner + Slack pingDay 30: Auto-mark Closed Lost (Stale - Disengaged)
Proposal / Negotiation30 days without customer responseEmail alert to owner and sales managerDay 45: Manager review flag; Day 60 auto-close
Contract Sent14 days without signatureUrgent reminder task + manager mentionDay 30: Stage moved to Stalled; auto-close at 60
2. Warning Notification Templates

Owner Slack Alert (Day 14/21 Trigger):

Opportunity Alert: [Deal Name] has had zero logged activity for [X] days in [Stage]. Update next steps by Friday or this deal will automatically be archived on [Date].

Manager Weekly Digest Alert:

Pipeline Decay Warning: [Count] deals totaling $[Amount] have passed inactivity thresholds without owner updates this week. Review pending archives in the Stale Deals dashboard before Sunday midnight.

3. Archive and Re-engagement Rules
  1. Closed Lost Field Stamp: When auto-archive executes, set Stage = "Closed Lost", Closed Reason = "Automated Hygiene - No Response", and preserve original Last Stage in a custom tracking field.
  2. Task Purge: Automatically close all open future reminder tasks assigned to the archived deal.
  3. Re-engagement Trigger: If an inbound email, form submission, or document view is recorded on an archived deal's primary contact within 180 days, create a high-priority task for the original owner and trigger a Slack notification.
  4. Reactivation Workflow: Move stage to "Re-engaged Discovery" only after a confirmed bidirectional call or email is logged.
Edge Cases to Double-Check
  • Deals with future close dates set far ahead that pause normal outreach (e.g., annual budget hold until Q1).
  • Auto-logging email sync tools that count automated marketing drip emails as real sales activity.
Written by AI from this prompt. Your results will vary.

Run this directly in Claude, ChatGPT, or Gemini to get an enterprise-ready pipeline governance spec. Follow up by asking the model to adjust the day thresholds to match an average 90-day sales cycle.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Automation & Workflows
Automation & Workflows

Build a personal weekly admin cleanup routine

Generate a practical 45-minute checklist to clear digital clutter, reset inboxes, and file documents. Ideal for individual contributors drowning in open tabs and desktop files.