Pipeline review board for deals where the buyer went quiet

Open one board before every pipeline review to see which open deals have had no buyer activity in weeks, sorted quietest first.

App
Factors.aiSalesforceSlackSalesResearch & MonitoringMeeting Workflows
PromptCreate

Build me a pipeline inspector app that my AEs and our sales manager open before every pipeline review, so we can find the open deals where the buying account has actually gone quiet.

The main surface is a board of open opportunities. Load them with the Salesforce Get Many Opportunities operation, keeping amount, stage, close date and owner, and filtering to open deals only so closed won and closed lost stay off the board. Join each opportunity to its account with Salesforce Get Many Accounts so you can read that account's Website field, and derive a clean domain from it. For each domain, fetch the last 30 days of activity with the Factors.ai Get Account Journey operation. Factors accepts exactly one domain per lookup and has no pagination, so fan out one call per deal's account domain across a 30 day from/to window rather than trying to batch them.

Sort the board quietest first, by days since the account's last activity. Put a Gone dark badge on any deal that has had no account activity for 14 or more days while it is either sitting in a late stage or scheduled to close this quarter. Each card should show the deal facts, the days since last activity, and the badge when it applies.

Handle unmatched accounts explicitly. If an account's Website field is empty or cannot be parsed into a usable domain, that deal must render in a visible Cannot match state, and it must not be sorted or scored as if it were dark. A missing website is a data gap, not a silent buyer, and quietly rendering it as no activity would fabricate a dark deal signal that the team would then act on. Group or mark these clearly so someone can go fix the underlying account record.

Opening a deal shows a detail view with the engagement trend over the 30 day window beside the deal facts of amount, stage, close date and owner. Below that, show the timeline from the account journey: who from that company visited, which pages they read, and when they last appeared. Distinguish returning visitors from first-time ones, because three new people reading pricing at a stalled account is a very different and more valuable signal than the original champion checking in once. That distinction is the main thing a rep is trying to read on this screen, so make it visually obvious rather than burying it in the timeline.

Give each deal three direct actions. Create task creates a Salesforce task for the deal owner using Create Task. Log finding writes what the reviewer concluded back onto the deal with Add Note to Opportunity. Flag for review posts the deal summary to the team channel using the Slack Send a Message operation.

Draft a re-engagement plan kicks off a background agent scoped to that one deal. The agent reads the account journey plus the deal's stage and close date, decides whether this looks like renewed committee activity or true silence, and writes a recommended next play that references the specific pages and the specific people it saw in the journey. It attaches the finished plan to the deal with Add Note to Opportunity and returns it to the app so the plan is displayed in the deal view. Show that the agent is running while it works, and render the plan in place when it lands.

Finally, give the manager an owner filter on the board so a review meeting can walk one rep's deals at a time. Default the board to all owners, and keep the quietest-first sort and the Gone dark badges intact inside whatever filter is applied.

What does this prompt do?

  • Pulls every open deal from Salesforce with its amount, stage, close date and owner, then matches each one to its account's website so it can look up real buying activity.
  • Sorts the board quietest first and adds a Gone dark badge to any deal with no account activity for 14 days or more that is either in a late stage or due to close this quarter.
  • Opens each deal to show the engagement trend next to the deal facts, plus who from that company visited, which pages they read and when they last showed up, separating familiar faces from brand new ones.
  • Lets you act without leaving the board: create a follow-up task for the owner, log what you found on the deal, post it to your team channel, or have an agent draft a re-engagement plan.

What do I need to use this?

  • A Salesforce account with open opportunities, and accounts that have the website field filled in
  • A Factors.ai account that is tracking visitors to your website
  • A Slack workspace, if you want to flag deals to your team channel

How can I customize it?

  • Change the quiet threshold from 14 days, or widen the 30 day activity window the engagement trend is built from
  • Adjust which stages count as late, and whether closing this quarter should be part of the gone dark rule
  • Filter the board by owner so a review meeting can walk through one rep's deals at a time

FAQs

What happens to deals whose account has no website listed?
They show a clear Cannot match state instead of being scored. This matters more than it sounds: a missing website is not the same thing as a quiet buyer, and marking those deals dark would invent a problem that may not exist. It also gives you a tidy list of account records worth cleaning up.
Does this change anything in Salesforce on its own?
No. Nothing is written unless you click. Tasks, notes and re-engagement plans are all created on demand, one deal at a time, so the board stays a review surface rather than a background sync.
Can the sales manager look at just one rep's deals?
Yes. There is an owner filter on the board, so a pipeline review can walk one rep's deals at a time instead of scrolling past everyone else's.
How is this different from a report that emails me stalled deals?
A report tells you a deal is quiet. This is a board you work in: you can see who visited, what they read and when, judge whether the deal is genuinely dead, and then act on it right there.
Will it tell the difference between my champion going quiet and new people showing up?
Yes. The deal view separates returning visitors from first-time ones, so renewed interest from a new group of people does not get read the same way as real silence. That is often the difference between a dead deal and a deal that just changed hands.

Related templates

Browse and shortlist creators without burning audit credits

Search creators for free, shortlist the best with your team, and spend an audit credit only when you decide someone is worth a closer look.

HypeAuditor
Airtable
Slack
App
Hiring funnel dashboard for every open Hireflix role

One screen showing invited, completed, and shortlisted counts for every open role, plus the stalled invites that have quietly gone nowhere.

Hireflix
Slack
App
Global operations exposure map for your sites and suppliers

Open one board each morning to see which of your facilities, suppliers and shipping lanes are sitting near trouble in the news right now.

GDELT
Airtable
Slack
App
Compare creators on post performance before you pay them

Pick creators from your saved list and see their best and worst Instagram posts side by side, so your brief is built on what actually lands.

HypeAuditor
Google Docs
Slack
App
Review every Hireflix video interview from one daily queue

One screen where your hiring team watches every unscored candidate, reads the transcript alongside each answer, and scores and shortlists on the spot.

Hireflix
Slack
App
Deal sourcing kanban board for your Harmonic saved searches

Drag every new company from your Harmonic saved searches through New, Tracking, Meeting and Passed, with a one click diligence brief on every card.

Harmonic
Airtable
Slack
App

Stop guessing which deals are still alive.

Walk into your next pipeline review knowing exactly which accounts have gone quiet and which ones just brought new people to the table.