Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Weekly Sales Pipeline Review

    1

    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

    1 useSecurity scanned
    Weekly Sales Pipeline Review

    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.

    1. Orion Example — $200,000 — Negotiation (70%) — close Mar 15 — last activity Jan 15 — our only contact is the CFO.
    2. Bluefin Sample — $90,000 — Proposal (40%) — close Feb 28 — last activity Dec 10.
    3. Cedar Test Co — $50,000 — Commit (90%) — close Jan 10 — last activity Jan 9 — legal review pending, not signed.
    4. Delta Example — $130,000 — Discovery (20%) — close Mar 30 — last activity Jan 16.
    5. 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

    1. 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

    2. 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

    3. 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

    4. 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

    5. 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).

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Business & Operations.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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 to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 25 days ago

    • Free with an Agensi account

    Nothing to install. It runs in your AI agent.

    Paste your documents into the chat.

    Permissions

    No special permissions declared or detected

    Listed25 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the calculation of weighted forecasts, flags deals with stale activity or missing steps, and generates targeted coaching questions to help managers conduct more effective 1:1s.

    It is designed to work with any raw CRM data (like CSV or text exports) from platforms like Salesforce, HubSpot, or Pipedrive when used within your preferred AI chat interface.

    You receive the specialized logic and risk-detection framework ready for immediate use; simply provide your CRM data and quota targets to start generating reviews.

    The skill applies six specific logic rules to identify risks like overdue close dates, lack of recent activity (over 21 days), and missing next steps, ensuring no deal slips through the cracks.

    Yes, the skill automatically filters out deals outside the current quarter and audits for missing or invalid fields, providing a clear list of why certain deals were excluded from the forecast.

    New in Business & Operations

    Free