/
/
Find the stale deals that put the most value at risk
For sales managers who want old open deals ranked by value with last activity and a next move, just by asking their AI assistant.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Cold deals slip past when you scroll by hand
To find deals that have gone cold, reps scroll each pipeline, then open every deal to check its last note and open tasks. The biggest deals are easy to miss in the scroll.
Without PopdockAI
- Scroll pipelines looking for old deals
- Open each deal to find its last note
- Check for any open task by hand
- Decide the next move deal by deal
With PopdockAI
- Open deals older than your threshold are pulled together
- Stage, latest note, open task and owner checked for each
- Neglected and late stage deals flagged by risk
- Ranked by value with a recommended action, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find open deals older than {stale-days} days (default 60), optionally in pipeline {pipeline-id}, and recommend an action for each.
**Step 1: Pull candidate deals**
Call `activecampaign-get-deal` with `created-date.to` set to today minus {stale-days} days, `pipeline-id` = {pipeline-id} if given, and the status filter value that means open. If you are unsure which status value means open, call once without it and read the status field to see the values in use.
**Step 2: Add context**
For each deal call `activecampaign-get-dealstage` (to name the stage) and `activecampaign-get-note` with `related-id` = the deal id (latest note date) and `activecampaign-get-dealtask` with `related-record-id` = the deal id (any open task). Resolve owners with `activecampaign-get-user`.
**Step 3: Judge**
A deal with no note and no open task is neglected. A late-stage deal with no recent activity is the highest risk.
**Step 4: Report**
A table: deal, value, stage, owner, age in days, last note date, open task, recommended action (chase, re-qualify, close lost). Sort by value descending, then total value at risk.
**Rules & Guidelines:**
* Read-only job. Do NOT call any write tool: no add, update, delete, sync, move, duplicate or bulk tool, in particular `activecampaign-deal-update` and `activecampaign-deal-delete`. If the user asks for a change, tell them to use a write prompt instead.
* Never guess an id. Only use ids returned by a tool in this run. Report only what the tools returned; say so when a value is missing.
**Validation:**
* If a lookup returns no records, say so and stop rather than widening the search silently.
* If a name or email matches more than one record, list the matches (id and key fields) and ask which one to use before continuing.
Who it's for
One answer, three teams that use it
Sales managers
Rescue the deals that matter
See the largest stale deals first with a suggested action for each.
Rank open ActiveCampaign deals older than 60 days by value.
Sales reps
Know which deals need a decision
See each old deal's owner, last note and whether anything is scheduled.
Show open ActiveCampaign deals older than 45 days with their owners and last note dates.
Revenue operations
Quantify value at risk
Get the total value sitting in stale deals for the forecast.
How much value is at risk in deals older than 90 days in pipeline 2?
How it works
What PopdockAI does when you ask
You set how old counts as stale and your AI assistant checks each deal's activity. It only recommends, so no deal is edited, moved or deleted.
Ask
You give an age in days, or use 60, and optionally a pipeline.
Pull
It finds open deals older than that in ActiveCampaign.
Context
It reads each deal's stage, latest note, open tasks and owner.
Report
A table by value shows risk, a recommended action and the total value at risk.
What PopdockAI provides
The tools behind the answer
Ready made tools for ActiveCampaign and one secure connection to your AI tool. No code, no exports.
activecampaign-get-deal
activecampaign-get-dealstage
activecampaign-get-note
activecampaign-get-dealtask
activecampaign-get-user
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Know which cold deals to chase first
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
