/
/
Know which sales goals are behind and if pipeline can save them
For sales managers who want Dynamics 365 Sales goals compared with time elapsed and open pipeline, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.
The problem
A goal percentage does not tell you if you are on track
Goals show a percentage achieved, but not whether that is good enough for how far into the period you are, or whether open pipeline could close the gap. Working it out per person is a spreadsheet that is stale when finished.
Without PopdockAI
- Read each goal's percentage achieved
- Work out how far into the period you are
- Total open deals closing before the goal ends
- Rebuild it all next week
With PopdockAI
- Progress is compared with time elapsed
- Goals trailing by more than ten points are called behind
- Open deals closing in time are totalled, raw and weighted
- Each behind goal gets a verdict, 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:** Review sales goal progress for `{goal-owner}` (everyone if blank) in fiscal year `{fiscal-year}` (default the current year) and period `{fiscal-period}` (all if blank), and show whether the open pipeline can close each gap.
**Step 1: Pull the goals**
Call `dynamics-365-sales-get-goals` with `fiscal-year`, and `goal-owner` and `fiscal-period` if given. Skip goals whose `status` is not active.
**Step 2: Measure progress**
For each goal compute the gap (`target` minus `actual`) and time elapsed: the share of the days between `goal-start-date` and `goal-end-date` that have passed. A goal is behind when `percentage-achieved` is more than 10 points below the share of time elapsed.
**Step 3: Can the pipeline close the gap?**
For each goal that is behind and measures revenue, call `dynamics-365-sales-get-opportunities` with `owner` = the goal owner, `status` set to the open value, `est-close-date.from` = today and `est-close-date.to` = the goal end date. Sum the `est-revenue` and the probability-weighted revenue and compare with the gap.
**Step 4: Report**
1. A table of goals: name, owner, metric, period, target, actual, % achieved, % of time elapsed, on track or behind.
2. For each goal that is behind: the gap, the open pipeline closing before the goal ends (raw and weighted), and the 3 largest deals that could close it.
3. A one-line verdict per behind goal: pipeline covers the gap, covers it only unweighted, or cannot cover it.
**Rules & Guidelines:**
* This prompt is read-only. Do NOT call any create or update tool: `dynamics-365-sales-create-account`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-phone-call`, `dynamics-365-sales-update-account`, `dynamics-365-sales-update-contact`, `dynamics-365-sales-update-lead`, `dynamics-365-sales-update-opportunity`, `dynamics-365-sales-update-case`.
* Only compare opportunity revenue with goals whose metric is revenue. For count-based goals, compare the number of open deals instead and say so.
**Validation:**
* If no goals match, say so and state the filters used.Who it's for
One answer, three teams that use it
Sales directors
Know which goals need intervention
Behind goals come with a verdict on whether pipeline can close the gap.
Which Dynamics 365 Sales goals are behind for this quarter, and can open deals close them?
Sales managers
Coach reps on the right deals
The three largest open deals for each behind goal show where to focus.
Is Priya Shah's revenue goal on track for this fiscal year in Dynamics 365 Sales?
Revenue operations
Report goal health without a spreadsheet
Progress against time elapsed is worked out for every goal in one pass.
Review all active goals in Dynamics 365 Sales for Q3 and flag those behind by more than ten points.
How it works
What PopdockAI does when you ask
You optionally name an owner and period and your AI assistant checks every active goal in Dynamics 365 Sales against time and pipeline. It reports only.
01
Ask
You optionally name an owner, fiscal year and period.
02
Measure
It reads active goals and compares progress with time elapsed.
03
Cover
For goals behind, it totals open deals closing before the goal ends.
04
Report
You get each behind goal with a one-line verdict on the gap.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics 365 Sales and one secure connection to your AI tool. No code, no exports.
microsoft-dynamics-365-sales-get-goals
microsoft-dynamics-365-sales-get-opportunities
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 goals are behind and if pipeline can save them
Related use cases
More ways to put this data to work
Add Dynamics 365 Sales account contacts to a Constant Contact list
Ask your AI to add an account's Dynamics 365 Sales contacts to a Constant Contact list and it sorts out unsubscribes and existing contacts, then adds only the people you confirm.
Learn More
Add Dynamics 365 Sales account contacts to a Drip campaign
Ask your AI to put a Dynamics 365 Sales account's contacts into a Drip campaign and it checks each email in Drip, skips unsubscribes and existing members, and adds only what you confirm.
Learn More
.webp){kind=logo}
Add missing Dynamics 365 Sales accounts from Dynamics 365 Business Central customers
Ask your AI to find Business Central customers missing from Dynamics 365 Sales and it creates the confirmed ones as accounts with a follow-up task, leaving possible duplicates alone.
Learn More
Advance a Dynamics 365 Sales opportunity
Ask your AI to update a Dynamics 365 Sales opportunity and it checks the change makes sense, shows a before and after, and saves it with a note explaining why.
Learn More
Capture a new Dynamics 365 Sales lead
Ask your AI to add a lead to Dynamics 365 Sales and it checks leads, contacts and accounts first, then creates the lead and a first contact task after you confirm.
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.