Connectors

/

ActiveCampaign

/

ActiveCampaign Stale deals review
Report

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.

Try PopdockAI free
Get a live demo
ActiveCampaign Stale deals review
Which open deals in ActiveCampaign are older than 90 days? Rank them by value and tell me what to do with each.
7 open deals are older than 90 days, with 238,000 at risk. - Largest: Contoso renewal, 90,000, Proposal stage, 134 days old, last note 12 Aug, no open task, chase - Highest risk: Fabrikam expansion, 60,000, late stage, no note and no open task, requalify - Lowest value shown: Adventure Works trial, 4,000, 97 days old, close lost - Total value at risk: 238,000 Want the other 4 deals in the table?
ActiveCampaign
Sample figures. Your results come from your own account.
activecampaign-get-deal
activecampaign-get-dealstage
activecampaign-get-note
activecampaign-get-dealtask
activecampaign-get-user

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

ActiveCampaign

ActiveCampaign
Run it on your own ActiveCampaign data.

Connect ActiveCampaign, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Pull

It finds open deals older than that in ActiveCampaign.

activecampaign-get-deal
activecampaign-get-dealstage
activecampaign-get-note
activecampaign-get-dealtask
activecampaign-get-user

Context

It reads each deal's stage, latest note, open tasks and owner.

No items found.

Report

A table by value shows risk, a recommended action and the total value at risk.

Your AI tool

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.

get-data

activecampaign-get-deal

Returns ActiveCampaign deals with the fields and filters the connector exposes. Read only.
get-data

activecampaign-get-dealstage

Returns ActiveCampaign deal stages with the fields and filters the connector exposes. Read only.
get-data

activecampaign-get-note

Returns ActiveCampaign notes with the fields and filters the connector exposes. Read only.
get-data

activecampaign-get-dealtask

Returns ActiveCampaign deal tasks with the fields and filters the connector exposes. Read only.
get-data

activecampaign-get-user

Returns ActiveCampaign users with the fields and filters the connector exposes. Read only.
Read only.Nothing in ActiveCampaign Changes

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.

How Popdock AI secures your data

The outcome

Know which cold deals to chase first

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation