Connectors

/

Pipedrive

/

Pipedrive sales forecast
Report

Forecast what Pipedrive deals will close, and spot what slipped

For sales leaders who want a weighted Pipedrive forecast by month and owner, with commit and best case and slipped deals kept apart.

Try PopdockAI free
Get a live demo
Pipedrive sales forecast
Forecast the next 90 days in Pipedrive for the Enterprise pipeline.
Weighted forecast for the next 90 days: 486,000 USD from 41 deals. - Commit, 70 percent or more: 212,000 USD - Largest weighted: Contoso platform, 64,000 USD - Slipped: 6 deals past their close date, left out Want the totals by month and owner?
Pipedrive
Sample figures. Your results come from your own account.
pipedrive-get-user
pipedrive-get-stage
pipedrive-get-deal

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Pipedrive

Pipedrive
Run it on your own Pipedrive data.

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

Try PopdockAI free

The problem

Forecasts that count slipped deals as on time

A forecast built from Pipedrive by hand means exporting open deals, applying each probability, grouping by month and owner, and leaving out deals whose close date passed. The result often counts slipped deals as if they were still on time.

Without PopdockAI

  • Export open deals from Pipedrive
  • Apply each probability in a spreadsheet
  • Group by month and owner
  • Forget to remove deals that already slipped

With PopdockAI

  • Open deals closing in your window are read
  • Each is weighted by its own or its stage's probability
  • Totals by month and owner per currency, commit against best case
  • Slipped deals are listed apart, and nothing is re-dated

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Forecast the open deals expected to close in the next `{days-ahead}` days (default 90), optionally only for `{owner-name}` and the `{pipeline-name}` pipeline, and show which deals have slipped past their close date.

**Step 1: Resolve the filters**

* If `{owner-name}` is given, call `pipedrive-get-user` with `name.contains`. If more than one user matches, list them and stop. Keep the user-id.
* Call `pipedrive-get-stage` (with `pipeline-name` if `{pipeline-name}` is given) and keep each stage's name and deal-probability, to weight deals that have no probability of their own.

**Step 2: Pull the forecast window**

Call `pipedrive-get-deal` with `status` = open, `expected-close-date.from` = today, `expected-close-date.to` = today plus the window, and `owner-id` if resolved. If `{pipeline-name}` is given, keep only rows whose pipeline matches it.

**Step 3: Pull the slipped deals**

Call `pipedrive-get-deal` with `status` = open and `expected-close-date.to` = yesterday (same owner and pipeline filters). These are open deals whose close date has already passed. Keep them out of the forecast totals.

**Step 4: Report**

1. **By month:** month, number of deals, total value, weighted value (value x probability / 100), per currency.
2. **By owner:** the same columns per owner (skip when `{owner-name}` is given).
3. **Commit vs best case:** commit = deals at 70% probability or higher; best case = everything in the window.
4. **Top 10 deals** by weighted value: deal, organization, owner, stage, value, probability, expected close.
5. **Slipped deals:** deal, owner, stage, value, original expected close, days overdue.

Finish with a one-paragraph read of the forecast: how concentrated it is, and how much of it depends on the slipped deals being re-dated.

**Rules & Guidelines:**

* Read-only. Do not call `pipedrive-update-deal` to re-date slipped deals or `pipedrive-add-activity` to chase them.
* Never add values across currencies.
* Use the deal's probability when set, otherwise its stage's deal-probability. Say how many deals used the stage fallback.
* If a filter on `owner-id` returns nothing when you expect records, run the same read without it and keep the rows whose owner-name matches the user instead.

**Validation:**

* If nothing is expected to close in the window, say so and still report the slipped deals.
* If `{days-ahead}` is not a number, use 90 and say so.

Who it's for

One answer, three teams that use it

Sales leaders

Bring a defensible number

Commit and best case totals by month and currency, with slipped deals kept out.

Forecast the next quarter in Pipedrive with commit and best case by month.

Sales managers

Forecast by rep

Totals by owner and the top 10 deals by weighted value show where the quarter depends.

Forecast the next 60 days in Pipedrive by owner, and list the top 10 deals.

Finance leaders

Plan revenue with slipped deals removed

Deals past their close date are listed separately, so revenue plans do not count them.

What is the weighted Pipedrive forecast for the next 90 days, and which deals have slipped?

How it works

What PopdockAI does when you ask

You choose how many days ahead, and an owner or pipeline if you like, and your AI assistant builds a weighted Pipedrive forecast. It says how many deals used the stage probability and changes nothing.

01

Ask

You choose how many days ahead, and optionally an owner and pipeline.

Your AI tool

02

Read

It reads open deals expected to close in that window.

pipedrive-get-user
pipedrive-get-stage
pipedrive-get-deal

03

Weigh

It weights each deal by its probability or its stage's.

No items found.

04

Report

You get totals by month and owner, top deals and slipped deals.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Pipedrive and one secure connection to your AI tool. No code, no exports.

get-data

pipedrive-get-user

Returns Pipedrive users with email, role, timezone, default currency and last login. Filter by name, email or active.
get-data

pipedrive-get-stage

Returns Pipedrive pipeline stages with their order, deal probability and rotten days. Filter by pipeline, name or active.
get-data

pipedrive-get-deal

Returns Pipedrive deals with stage, pipeline, value, probability, owner and expected close date. Filter by status, stage, owner, organization, value range, expected close date range or title.
Read only.Nothing in Pipedrive 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

A weighted forecast you can defend

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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