Skip to content

Stale and at-risk deals report

The Stale and at-risk deals report is a worklist. It lists the open deals that need attention now: deals nobody has worked for a while, deals past their Expected close date, and deals that have sat in one stage too long. Each row shows how many days the deal has been idle and how many it has been in its stage, so a rep knows what to pick up next and a manager knows what to ask about.

Go to Reports and click Stale and at-risk deals under Pipeline health.

The report covers the opportunities your role can view. It has no period: it shows what is true of your open deals today.

Use the row of filters above the numbers:

  • The deal owner: Everyone (or My team), or one person. This filter appears when your role reaches your team’s or everyone’s opportunities. People who have left are listed last, marked (inactive).
  • The pipeline: All pipelines or one pipeline. This filter appears when you have more than one.
  • The source: All sources or one source, matched to the deal’s Source.

Under the filters are the two thresholds the rules use:

  • Idle for (days): how many days without a touch before a deal counts as idle. Left blank, it follows Days with no activity under Stalled deals in Pipeline and stages, the same number the dashboard’s stalled-deals tile and the Stalled filter on the Opportunities list use, so the report agrees with them. The box shows that number as its placeholder.
  • In stage for (days): how many days in one stage before a deal counts as stuck. Left blank, it is 30.

Type a whole number from 1 to 365 in either box to try a different threshold; clear the box to go back to the default. Your filters and thresholds are kept in the page address, so a bookmark opens the same view.

A deal is on the list when it is open and at least one of these is true. A deal can hit more than one; its row shows a flag for each.

Rule What it means
Idle Nobody has touched the deal for the idle threshold or longer
Past due Its Expected close date is before today
Stuck It is in a stage, and has been there for the stage threshold or longer

A deal with no expected close date is never past due. A deal in no stage is never stuck: it is idle or past due on its own merits, and its In stage column counts from the day it was made.

A touch is something a person did on the deal: an activity logged or completed against it, a note, a meeting booked or held, a move to another stage, or an email sent about the deal from Gabriel. A new deal counts as touched on the day it was made. An email you received does not count: a customer’s unanswered mail is the deal going stale, not being worked. Edits made by a sync or an automation do not count either, so a deal the system keeps updating still reads as idle if nobody has worked it.

This is the same definition the dashboard, the Opportunities list’s Stalled filter and My Work use.

Four tiles across the top count the deals and add up their Value:

  • Needs attention: every deal that hits at least one rule.
  • Idle N+ days: the idle deals, at the idle threshold in force.
  • Past close date: the deals past their expected close date.
  • In stage N+ days: the stuck deals, at the stage threshold in force.

Click a tile to open its deals as a list, with the filters and thresholds the report was showing. The list’s total matches the tile. A tile with no deals is plain text. Click the report’s name in the trail at the top to come back with your filters and thresholds in place.

Under the tiles, Work next lists every deal that hits a rule, longest wait first. Each row has the deal (click it to open the deal), its company, owner and stage, then:

  • Idle: days since the last touch. Hover over it to see the date.
  • In stage: days in the current stage. Hover over it to see the date it entered the stage.
  • Close date: the expected close date, in red when it has passed.
  • Value: the deal’s Value.
  • Flags: Idle, Past due and Stuck, for each rule the deal hits.

Choose Any, Idle, Past due or Stuck above the list to see only the deals that hit one rule. Click Idle, In stage, Close date or Value in the header to reorder: idle and in stage put the longest wait first, close date the earliest first with undated deals last, value the largest first. The list pages like the Opportunities list.

  • A deal is open when its stage’s Outcome is Open, or it has no stage yet. Won and lost deals are never on the list.
  • Idle is counted from the deal’s last touch, as described above, never from the deal’s “last updated” time.
  • In stage is measured from the deal’s last recorded stage move, or from the day it was made when none is recorded. Gabriel started recording stage moves on a set date, and a stage set by an import or a sync records no move, so such a deal is measured from the move before it, or from its creation. Its days in stage can then read higher than the stage it is in would suggest; move it to its real stage in Gabriel and the count starts again. The dashboard’s “needs attention” tile and this report agree for deals whose stage moves were made in Gabriel.
  • “Today” for the past-due rule is the calendar date in your own time zone, or your company’s if you haven’t set one. A deal due today is not past due.
  • A deal exactly at a threshold is not yet idle or stuck: Idle for 7 means a deal becomes idle once more than 7 full days have passed since its last touch.
  • Idle and In stage never read below 0. An activity completed with a date in the future counts as a touch now, so the deal reads 0 days idle until that date passes.
  • Thresholds in the page address override the defaults for that view only. Changing Settings > Stalled deals changes the default for everyone.
  • Amounts on the tiles are shown rounded, such as $12.5K; the list shows them in full.
  • Work the list top down each morning. Longest idle first is the default for a reason: the deal nobody has touched longest is the one most likely to be lost quietly.
  • Clear Past due before a forecast call. A deal past its expected close date is either slipping or dead. Move the date or move the deal to a lost stage, and the Pipeline & forecast report reads true.
  • Set the Stalled deals setting to your sales cycle. Seven days is right for a transactional pipeline and too tight for enterprise deals. Set the default in Settings so every rep’s dashboard and this report agree, and use the box on the report to test a tighter or looser number before changing it.
  • Managers: filter to one rep. Pick a deal owner and review their list with them in the weekly one-to-one.

The report says nothing needs attention, but a deal looks idle. Check the thresholds: an Idle for of 30 hides a deal idle for 20 days. Also check whether something counted as a touch: a note, a logged activity, a stage move or an email sent from Gabriel in the last few days all do.

A deal shows more days in stage than it has been in that stage. Its current stage was set without a recorded move: the deal was made before Gabriel started recording stage moves, or an import or sync set the stage. It is counted from its last recorded move, or from the day it was made. Move it to its real stage in Gabriel to reset the count.

A deal in no stage shows days In stage but no Stuck flag. A deal has to be in a stage to be stuck in one. The column counts from the day it was made so the row still reads; give the deal a stage and the rule applies.

A deal I touched today still shows as idle. The touch has to be on the deal: an activity logged against the deal, a note on the deal, a meeting linked to the deal, or an email sent about the deal. A call logged against the contact only, with no deal chosen, does not touch the deal.

The tile count and the list total differ. They are the same query, so refresh the page: a deal was touched or moved between the two reads.