Report

Forecast OnePageCRM deals closing soon

For sales leaders who want a quick, honest forecast of open deals, just by asking their AI assistant.

Forecast the OnePageCRM deals expected to close between 1 April and 30 June 2026.

31 open deals worth 412,000 are expected to close between 1 April and 30 June, and 168,000 of that is late stage. - Likely: 168,000 across 9 late-stage deals - At risk: 244,000 across 22 early-stage deals - No amount recorded: 3 deals Figures are unweighted. Want the full table sorted by close date?

OnePageCRM

Sample figures. Your results come from your own account.

onepagecrm-get-deal

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

OnePageCRM

Run it on your own OnePageCRM data.

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

The problem

Forecasts mix open deals with won and lost ones

Revenue forecasts get built by exporting OnePageCRM deals and totalling them in a spreadsheet. Open deals get mixed with won and lost ones, and nobody agrees which are likely and which are at risk.

Without PopdockAI

Export deals closing in the window
Filter out won and lost deals by hand
Total amounts by stage in a spreadsheet
Argue over which deals are likely

With PopdockAI

Deals expected to close in the window are read
Open deals are separated from won and lost
Open amounts are totalled by stage, split likely and at risk
Totals are unweighted, deals with no amount are named, nothing changes

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 revenue from deals expected to close between `{from-date}` and `{to-date}` (YYYY-MM-DD), optionally for owner `{owner-id}`.

**Step 1: Pull the deals**

Call `onepagecrm-get-deal` with `expected-close-date.from` set to `{from-date}`, `expected-close-date.to` set to `{to-date}`, and `owner-id` when supplied. Set `max-records` to 200.

**Step 2: Split and total**

* Separate open deals from won and lost deals using `status`.
* Sum `amount` for open deals per `stage` and in total; sum `cost` and report margin where present.
* If stages are ordered (early to late), call late-stage deals the likely close and early-stage deals the at-risk part.

**Step 3: Report**

A short summary (open total, likely total, at-risk total), then a table of deals sorted by expected-close-date with name, company-name, stage, amount. Mention any deals with an empty `amount`.

**Rules & Guidelines:**

* Read-only. Never call `onepagecrm-add-deal`, `onepagecrm-update-deal` or `onepagecrm-delete-deal`.
* State that the figures are unweighted totals; do not invent probabilities.

**Validation:**

* If either date is missing or not a valid date, ask for it and stop.
* If nothing is returned, say the window is empty.

Who it's for

One answer, three teams that use it

Sales leaders

See the quarter's open pipeline

Likely and at risk totals by stage give you a clear forecast for the period.

Forecast OnePageCRM deals expected to close between 1 January and 31 March 2027.

Founders

Plan cash on real deal totals

Unweighted open totals by close date show what could land and when.

What open OnePageCRM deals are expected to close next month, and how much is late stage?

Sales managers

Check one rep's forecast

Filter by owner to see a rep's open deals by stage, and which have no amount.

Forecast Tom Reyes's OnePageCRM deals closing this quarter.

How it works

What PopdockAI does when you ask

You give a date window and optionally an owner, and your AI assistant builds an open deal forecast from OnePageCRM. No probabilities are invented, and it only reads.

Ask

You give a date window and optionally an owner.

Your AI tool

Read

It reads the deals expected to close in that window.

onepagecrm-get-deal

Total

It separates open from closed and sums amounts by stage.

No items found.

Report

You get likely and at-risk totals and a table by close date.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

onepagecrm-get-deal

Returns deals from OnePageCRM, with their stage, status, amount, expected close date, owner and linked contact or company. Filter by stage, status or date.

Read only.Nothing in OnePageCRM 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.

The outcome

An honest open deal forecast in one answer

Related use cases

More ways to put this data to work

Find OnePageCRM contacts missing from a Mailchimp audience

Ask your AI which OnePageCRM contacts are missing from a Mailchimp audience, who is on it but unsubscribed and who has no email, read-only.

Learn More

Find OnePageCRM contacts missing from Constant Contact

Ask your AI which OnePageCRM contacts are missing from Constant Contact or lack permission to send, read-only and matched on email.

Learn More

OnePageCRM and Chorus account briefing

Ask your AI for an account briefing that joins OnePageCRM contacts and deals with Chorus conversations and emails, flagging deals with no recorded call.

Learn More

OnePageCRM and Chorus rep coaching review

Ask your AI to set a rep logged OnePageCRM activity beside their Chorus conversations and scorecard scores and suggest coaching points.

Learn More

OnePageCRM open deals with no recent Chorus contact

Ask your AI which open OnePageCRM deals have had no Chorus conversation or email lately, flagged Quiet, Email only or Active, with totals.

Learn More

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.