- Home
- Skills
- Business & Operations
- Weekly Sales Pipeline Review
Works with the AI Agents you already use
Weekly Sales Pipeline Review
Turns a pipeline export into a weighted in-quarter forecast, gap to quota, risk flags (stale, past-due, single-threaded) and one coaching question per flagged deal.
Free
Weekly Sales Pipeline Review
Example session with this skill installed
Prep my weekly pipeline review.
Quarter ends Mar 31, 2027. Today: Jan 18, 2027. Remaining quota for the quarter: $400,000.
- Orion Example — $200,000 — Negotiation (70%) — close Mar 15 — last activity Jan 15 — our only contact is the CFO.
- Bluefin Sample — $90,000 — Proposal (40%) — close Feb 28 — last activity Dec 10.
- Cedar Test Co — $50,000 — Commit (90%) — close Jan 10 — last activity Jan 9 — legal review pending, not signed.
- Delta Example — $130,000 — Discovery (20%) — close Mar 30 — last activity Jan 16.
- Elm Sample — $75,000 — Proposal (40%) — close Apr 20, 2027 — last activity Jan 17.
- Read your context and instructions
- Compiled the weekly sales pipeline
FORECAST SUMMARY
Management estimate for review, not financial reporting.
Quarter: 2027-01-01 to 2027-03-31 | Today: 2027-01-18 | Quota currency: USD (assumed)
Weighted forecast
USD 140,000 + 36,000 + 45,000 + 26,000 = USD 247,000
Gap
USD 400,000 − 247,000 = USD 153,000
Scope
4 included, 1 excluded (Elm Sample, out of quarter). No deals excluded for missing inputs. No other-currency amounts.
Assumptions
- Quarter start: only the quarter end was supplied, so start = 2027-03-31 + 1 day − 3 calendar months = 2027-01-01. Please verify.
- "$" is treated as USD for the quota and all amounts.
- Unmarked pipeline deals are open.
- Year assignment uses the nearest date to today:
Close dates: Mar 15 → 2027-03-15; Feb 28 → 2027-02-28; Jan 10 → 2027-01-10; Mar 30 → 2027-03-30.
Activity dates: Jan 15 → 2027-01-15; Dec 10 → 2026-12-10; Jan 9 → 2027-01-09; Jan 16 → 2027-01-16; Jan 17 → 2027-01-17.
- Today is your supplied date (2027-01-18), not the system date.
- Remaining quota is assumed to already reflect any won or signed deals. Please verify reconciliation.
DEAL TABLE
-
Orion Example
Status: Open
Amount: USD 200,000
Stage: Negotiation, 70%
Close: Mar 15 → 2027-03-15
Eligibility: Included
Weighted: 200,000 × (70 ÷ 100) = 140,000
Last activity: 2027-01-15
Next step: NOT PROVIDED
Contacts: 1, CFO -
Bluefin Sample
Status: Open
Amount: USD 90,000
Stage: Proposal, 40%
Close: Feb 28 → 2027-02-28
Eligibility: Included
Weighted: 90,000 × (40 ÷ 100) = 36,000
Last activity: 2026-12-10
Next step: NOT PROVIDED
Contacts: NOT PROVIDED -
Cedar Test Co
Status: Open ("not signed")
Amount: USD 50,000
Stage: Commit, 90%
Close: Jan 10 → 2027-01-10
Eligibility: Included. Overdue, but the close date is inside the quarter.
Weighted: 50,000 × (90 ÷ 100) = 45,000
Last activity: 2027-01-09
Next step: NOT PROVIDED (notes say "legal review pending")
Contacts: NOT PROVIDED -
Delta Example
Status: Open
Amount: USD 130,000
Stage: Discovery, 20%
Close: Mar 30 → 2027-03-30
Eligibility: Included
Weighted: 130,000 × (20 ÷ 100) = 26,000
Last activity: 2027-01-16
Next step: NOT PROVIDED
Contacts: NOT PROVIDED -
Elm Sample
Status: Open
Amount: USD 75,000
Stage: Proposal, 40%
Close: 2027-04-20
Eligibility: Excluded. 2027-04-20 is after the quarter end of 2027-03-31.
Weighted: n/a (would be 75,000 × 0.40 = 30,000 if it were in quarter)
Last activity: 2027-01-17
Next step: NOT PROVIDED
Contacts: NOT PROVIDED
No duplicates were found.
RISK FLAGS
Orion Example
R6 Single-threaded: only one contact is recorded ("our only contact is the CFO").
R3: no next step recorded.
Not triggered: R1, R2 (3 days since activity), R4.
Bluefin Sample
R2 Stale activity: 2027-01-18 − 2026-12-10 = 39 days, which is over 21.
R3: no next step recorded.
Not triggered: R1, R4.
Cedar Test Co
R1 Past close date: 2027-01-10 is before 2027-01-18 (8 days overdue) and the deal is not signed.
R3: no next step recorded. "Legal review pending" is a status, with no specific action, owner, or date.
Not triggered: R2 (9 days), R4.
Delta Example
R3: no next step recorded.
Not triggered: R1, R2 (2 days), R4.
Elm Sample (excluded, still screened)
R3: no next step recorded.
Not triggered: R1, R2 (1 day), R4.
Unassessed checks
- R5 is not assessed for any deal because no stage versus close-date criteria were supplied. For reference, Delta is in Discovery with 71 days to close.
- R6 is not assessed for Bluefin, Cedar, Delta, or Elm because no contacts are recorded.
COACHING QUESTIONS
Orion Example
With USD 140,000 of weighted forecast resting on a single CFO relationship, who else needs to approve this, and how will you get access to them before Mar 15?
Bluefin Sample
What has happened with the buyer since Dec 10, and what would tell you a Feb 28 close is still realistic?
Cedar Test Co
The Jan 10 close has passed and legal review is pending. What specifically is legal reviewing, who owns it on their side, and what date have they committed to?
Delta Example
What has to be true by mid-February for a deal still in Discovery to close by Mar 30?
Elm Sample
Is there any realistic way the buyer could sign before Mar 31, or should Elm be planned entirely as a Q2 deal?
DATA GAPS
- Quota currency: "$" is assumed to be USD. Is it USD, or another dollar currency?
- Quarter start: 2027-01-01 is derived from the quarter end. Is this a calendar quarter, or does your fiscal calendar differ?
- Remaining quota: Does the USD 400,000 already net out any deals won or signed this quarter?
- R5 criteria (all deals): What minimum lead time to close does your team expect for each stage?
- Next steps (all 5 deals, affects R3): What specific next action, if any, is already agreed for each deal?
- Contacts for Bluefin, Cedar, Delta, and Elm (affects R6): How many distinct stakeholders are involved, and in what roles? Please use anonymous labels.
- Cedar close date (affects R1 and forecast timing): Has a revised close date been set, or is Jan 10 still the CRM value?
Before using this review, verify the CRM data, the arithmetic, the exclusion, the quarter boundaries, the date-year assumptions, and the currency handling.
Connects securely to your tools. The creator never sees your data.
About this skill
Prepares a weekly sales 1:1 or forecast review from a pasted pipeline. Calculates a weighted forecast and remaining-quota gap, shows exclusions, and flags deal risks with their triggering rules. Provides one coaching question per flagged deal and identifies missing inputs. Forecast numbers are management estimates, not financial reporting.
Built and tested by AI Professions, where we test AI on real professional tasks. Before this skill was written, we locked a 5-criterion rubric and a fictional test input. Then Claude Opus 5.5, Claude Sonnet 5, Claude Fable 5.1 each ran it 3 times, and a model from another family (GPT-6 Astra) graded every run.
Test results (English, current version v1.2): Claude Opus 5.5: 5.0 of 5 · Claude Sonnet 5: 5.0 of 5 · Claude Fable 5.1: 5.0 of 5. Full transcripts and verdicts are public: prompt-benchmark on GitHub.
What you give it
- Quarter end; quarter start or fiscal quarter convention if available.
- Today's date, remaining quota, and currency.
- Each deal's de-identified ID, amount, stage, stated probability (%), close date, last activity date, next step, and relevant notes.
- Distinct contacts identified by anonymous labels and roles, preserving the number of people without disclosing names.
- Explicit won, lost, signed, or closed status where applicable; otherwise treat the deal as open.
- Team-defined stage versus close-date mismatch criteria, such as minimum lead time by stage.
- Paste only necessary CRM data; omit contact names, email addresses, phone numbers, and unrelated personal information.
- If quota, currency, or usable quarter context is missing, ask once for the missing review inputs. Otherwise proceed using the defaults below and list missing deal fields; never guess them.
- If essential inputs remain missing after that request, provide the supported calculations and identify the missing operand rather than inventing a figure.
Also available
- Spanish, French (France) and Brazilian Portuguese versions adapted to local practice, not translated: skill page · GitHub
- Claude Code plugin:
/plugin marketplace add aiprofessions/claude-skills
Important
The skill produces drafts. A licensed or responsible professional checks every output before use. Do not paste client, patient or personal data into tools your organization has not approved.
Free under CC BY 4.0. Credit: AI Professions (aiprofessions.ai).
Management estimates only, not for financial reporting. No currency conversion. Requires manual de-identification of PII. Does not initiate calls or sync directly with CRM APIs.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 25 days ago
- Free with an Agensi account
Permissions
No special permissions declared or detected