- Home
- Skills
- Sales & Lead Gen
- 📊 Pipeline Reporter Pro
More screenshots
Works with the AI Agents you already use
📊 Pipeline Reporter Pro
Turn CRM exports into 12-month pipeline forecasts, source-backed win/loss analysis and reviewable reports. PDF rendering, CRM access and scheduled delivery require suitable host tools.
$19
📊 Pipeline Reporter Pro
Example session with this skill installed
Synthetic test example: Use synthetic-pipeline-v2.csv for the October 2026 to September 2027 forecast. Apply the calculation contract, keep currency/value-basis groups separate, reconcile all 25 rows and exclude unresolved duplicate conflicts. Produce the executive report, JSON and PDF using the available host tools. Do not connect to a CRM, send email or schedule anything.
- Read your context and instructions
- Compiled the pipeline reporter pro
- Generated the data export
Generated in this synthetic test: pipeline-report-2026-10-16.pdf, with matching Markdown and JSON. PDF rendering used the test host’s available tools.
Pipeline Report 2026-10-16
SYNTHETIC DATA. Candidate 1.1.0 (revised contract) test. PROVISIONAL: unresolved conflicting CRM records are excluded, not resolved.
CRM source: CSV synthetic-pipeline-v2.csv | Forecast window: 2026-10 to 2027-09 | Theme: executive | Groups (currency/basis): USD/one-time, EUR/one-time, USD/monthly
Executive summary
USD/one-time: weighted open pipeline 110,000 on raw 215,000; closed won in window 45,000; 12-month expected
155,000 (conservative 95,400, upside 173,375)
EUR/one-time: weighted open pipeline 12,000 on raw 20,000; closed won in window 0; 12-month expected
12,000 (conservative 0, upside 14,000)
USD/monthly: weighted open pipeline 2,000 on raw 2,500; closed won in window 0; 12-month expected
2,000 (conservative 1,400, upside 2,000)
- Groups are never combined or converted.
- Data-quality score (lowest evaluable group, uncalibrated completeness heuristic):
75; per-group scores: EUR/one-time 75, USD/monthly 75, USD/one-time 75
12-month forecast by month: USD/one-time
Table A, USD/one-time: pipeline components
| Month | Deals | Raw R | Weighted W | Late L | Upside U |
|---|---|---|---|---|---|
| 2026-10 | 2 | 90,000 | 72,000 | 72,000 | 0 |
| 2026-11 | 1 | 30,000 | 16,500 | 0 | 13,500 |
| 2026-12 | 0 | 0 | 0 | 0 | 0 |
| 2027-01 | 0 | 0 | 0 | 0 | 0 |
| 2027-02 | 1 | 80,000 | 20,000 | 0 | 60,000 |
| 2027-03 | 0 | 0 | 0 | 0 | 0 |
| 2027-04 | 0 | 0 | 0 | 0 | 0 |
| 2027-05 | 1 | 15,000 | 1,500 | 0 | 0 |
| 2027-06 | 0 | 0 | 0 | 0 | 0 |
| 2027-07 | 0 | 0 | 0 | 0 | 0 |
| 2027-08 | 0 | 0 | 0 | 0 | 0 |
| 2027-09 | 0 | 0 | 0 | 0 | 0 |
| Total (12 mo) | 5 | 215,000 | 110,000 | 72,000 | 73,500 |
Table B, USD/one-time: actuals and scenarios
| Month | Closed won A | Conservative | Expected | Upside |
|---|---|---|---|---|
| 2026-10 | 45,000 | 95,400 | 117,000 | 117,000 |
| 2026-11 | 0 | 0 | 16,500 | 19,875 |
| 2026-12 | 0 | 0 | 0 | 0 |
| 2027-01 | 0 | 0 | 0 | 0 |
| 2027-02 | 0 | 0 | 20,000 | 35,000 |
| 2027-03 | 0 | 0 | 0 | 0 |
| 2027-04 | 0 | 0 | 0 | 0 |
| 2027-05 | 0 | 0 | 1,500 | 1,500 |
| 2027-06 | 0 | 0 | 0 | 0 |
| 2027-07 | 0 | 0 | 0 | 0 |
| 2027-08 | 0 | 0 | 0 | 0 |
| 2027-09 | 0 | 0 | 0 | 0 |
| Total (12 mo) | 45,000 | 95,400 | 155,000 | 173,375 |
12-month forecast by month: EUR/one-time
Table A, EUR/one-time: pipeline components (active months only; all 12 in JSON)
| Month | Deals | Raw R | Weighted W | Late L | Upside U |
|---|---|---|---|---|---|
| 2026-12 | 1 | 20,000 | 12,000 | 0 | 8,000 |
| Total (12 mo) | 1 | 20,000 | 12,000 | 0 | 8,000 |
Table B, EUR/one-time: actuals and scenarios (active months only; all 12 in JSON)
| Month | Closed won A | Conservative | Expected | Upside |
|---|---|---|---|---|
| 2026-12 | 0 | 0 | 12,000 | 14,000 |
| Total (12 mo) | 0 | 0 | 12,000 | 14,000 |
12-month forecast by month: USD/monthly
Table A, USD/monthly: pipeline components (active months only; all 12 in JSON)
| Month | Deals | Raw R | Weighted W | Late L | Upside U |
|---|---|---|---|---|---|
| 2027-01 | 1 | 2,500 | 2,000 | 2,000 | 0 |
| Total (12 mo) | 1 | 2,500 | 2,000 | 2,000 | 0 |
Table B, USD/monthly: actuals and scenarios (active months only; all 12 in JSON)
| Month | Closed won A | Conservative | Expected | Upside |
|---|---|---|---|---|
| 2027-01 | 0 | 1,400 | 2,000 | 2,000 |
| Total (12 mo) | 0 | 1,400 | 2,000 | 2,000 |
Scenario forecast (per group; currency/basis labeled)
| Group | Conservative | Expected | Upside | A + R cap |
|---|---|---|---|---|
| USD/one-time | 95,400 | 155,000 | 173,375 | 260,000 |
| EUR/one-time | 0 | 12,000 | 14,000 | 20,000 |
| USD/monthly | 1,400 | 2,000 | 2,000 | 2,500 |
Per month and currency/basis group via helper scenarios(): conservative = A + 0.7L; expected = A + W; upside = A + min(R, W + 0.25U). U = sum(amount x (1-p)) over rows with recognized category best case/upside only. 12-month totals are sums of monthly values; under U <= R-W the cap cannot bind, so sums equal a total-level call (checked).
Late-stage rule: L = eligible rows with category commit; if category absent, exact stage label in commit/contract/legal/procurement/negotiation (fallback, disclosed); present non-commit or unrecognized category never qualifies. Fallback rows: none.
Forecast by stage (per group)
| Group | Stage | Deals | Raw | Weighted | Share |
|---|---|---|---|---|---|
| USD/one-time | Negotiation | 1 | 50,000 | 40,000 | 36% |
| USD/one-time | Contract | 1 | 40,000 | 32,000 | 29% |
| USD/one-time | Discovery | 1 | 80,000 | 20,000 | 18% |
| USD/one-time | Proposal | 1 | 30,000 | 16,500 | 15% |
| USD/one-time | Prospecting | 1 | 15,000 | 1,500 | 1% |
| EUR/one-time | Proposal | 1 | 20,000 | 12,000 | 100% |
| USD/monthly | Negotiation | 1 | 2,500 | 2,000 | 100% |
Rep performance (per group; open and revenue figures in that group's currency/basis)
| Group | Owner | Open weighted | Won / Lost | Won revenue (valid) | Win rate |
|---|---|---|---|---|---|
| USD/one-time | Rep A | 40,000 | 1 / 1 | 45,000 | 50% |
| USD/one-time | Rep B | 18,000 | 1 / 2 | 22,000 | 33% |
| USD/one-time | Rep C | 52,000 | 1 / 1 | 18,000 | 50% |
| EUR/one-time | Rep C | 12,000 | 0 / 0 | 0 | n/a |
| USD/monthly | Rep A | 2,000 | 0 / 0 | 0 | n/a |
Win/loss analysis
| Group | Won | Lost | DQ (separate) | Win rate | Avg won deal (valid) |
|---|---|---|---|---|---|
| USD/one-time | 3 | 4 | 1 | 43% | 28,333 |
| EUR/one-time | 0 | 0 | 0 | n/a | n/a |
| USD/monthly | 0 | 0 | 0 | n/a | n/a |
- USD/one-time: observation period 2026-07-30 to 2026-10-08; average won deal population 3 won rows with valid amount of 3 won; loss reasons {'Competitor price': 2, 'No decision': 1, 'Feature gap': 1}
- Cross-group counts only (all groups, deduplicated nonconflicting terminal rows in the export; 2026-07-30 to 2026-10-08): 3 won, 4 lost, 1 disqualified. No blended monetary average.
- Lost themes (supplied notes/loss_reason only): Competitor (2, low), Price/budget (2, low), Timing/no decision (1, low), Feature gap (1, low)
- Won themes (supplied notes only): Champion strength (2, low), Implementation/security/legal (2, low), Competitor (1, low), Price/budget (1, low)
- Every theme is supported by fewer than 3 deals; directional only.
Pipeline risks and data-quality warnings
- USD/one-time Synth Deal Epsilon: forecast_category absent; excluded from U, retained in R and W
- USD/one-time Synth Deal Zeta: close_date 2026-10-05 before 2026-10-16; kept in 2026-10 (overdue)
- USD/one-time unallocated (missing close_date): Synth Deal Eta 25,000 weighted 15,000
- USD/one-time outside window: Synth Deal Theta 60,000 close 2027-11-30
- Invalid amount (open): USD/one-time Synth Deal Kappa (raw 'n/a')
- Negative amount flagged, not clamped: USD/one-time Synth Deal Xi -5,000
- Unassigned (missing currency), never added to a group: Synth Deal Omicron 10,000
- Unknown stage, unresolved: USD/one-time Synth Deal Iota 'Pending Review' 12,000
- Omitted category, excluded from R/W/L/U: USD/one-time Synth Deal Lambda 35,000
- Disqualified (terminal zero; explicit probability 60% ignored and disclosed): USD/one-time Synth Disqualified
- Conflicting duplicate CRM-003 (rows [4, 13]): all versions in review bucket; entire ID excluded from provisional calculations; not resolved
- Identical duplicates collapsed: 1
Data-quality scores by group
EUR/one-time: score
75 over 1 rows (supplied export, deduplicated, nonconflicting rows assigned to this group; all statuses). Open amount denominator 20,000; missing-date share 0.0% (0); unknown-stage share 0.0% (0); invalid-amount rows 0/1 = 0.0%; historical closed rows 0.
- −15: default inferred stage map on included open rows (Synth Deal Mu)
- −10: no historical closed deals in group
USD/monthly: score
75 over 1 rows (supplied export, deduplicated, nonconflicting rows assigned to this group; all statuses). Open amount denominator 2,500; missing-date share 0.0% (0); unknown-stage share 0.0% (0); invalid-amount rows 0/1 = 0.0%; historical closed rows 0.
- −15: default inferred stage map on included open rows (Synth Deal Nu)
- −10: no historical closed deals in group
USD/one-time: score
75 over 19 rows (supplied export, deduplicated, nonconflicting rows assigned to this group; all statuses). Open amount denominator 312,000; missing-date share 8.0% (25,000); unknown-stage share 3.8% (12,000); invalid-amount rows 2/19 = 10.5%; historical closed rows 7.
- −15: default inferred stage map on included open rows (Synth Deal Alpha, Synth Deal Delta, Synth Deal Epsilon, Synth Deal Zeta)
- −10: >10% of rows invalid/missing/negative amount (Synth Deal Kappa, Synth Deal Xi)
Recommended next actions
- Resolve any conflicting CRM export rows with an authoritative source before they re-enter the forecast.
- Confirm currency and amount basis on unassigned rows; set close dates on unallocated rows; map unknown stage labels.
- Supply forecast categories where absent or unrecognized so late-stage and upside membership stop relying on fallback rules.
- Fix invalid, missing or negative amounts, including on closed rows, so outcome rows can carry monetary value.
Appendix: field mapping, assumptions, missing data
Field mapping: deal_name->deal_name, amount->amount, currency->currency, amount_basis->amount_basis, stage->stage, owner->owner, close_date->close_date, created_date->created_date, closed_date->closed_date, probability->probability, forecast_category->forecast_category, loss_reason->loss_reason, notes->notes, account_name->account_name, source->source, crm_record_id->crm_record_id
Probability units declared: percent. Probability source: mixed.
Group order rule: eligible raw R descending, ties alphabetical; no currency hardcoded. Secondary groups show active months in PDF/Markdown; JSON holds all 12.
Missing fields: forecast_category absent on some rows (see absent_category_rows); no user category or late-stage mapping supplied
Row reconciliation: closed_lost:USD/one-time 4; closed_won:USD/one-time:historical 2; closed_won:USD/one-time:in_window 1; conflicting_duplicate_pending 2; disqualified:USD/one-time 1; eligible:EUR/one-time 1; eligible:USD/monthly 1; eligible:USD/one-time 5; identical_duplicate_collapsed 1; invalid_amount:USD/one-time 1; negative_amount:USD/one-time 1; omitted_category:USD/one-time 1; outside_window:USD/one-time 1; unallocated_missing_close_date:USD/one-time 1; unassigned:missing currency 1; unknown_stage:USD/one-time 1; sum 25 of 25 input rows
Helper SHA256: 0b08fe364d4d34f75c6bd0625e7ee801272f48add5fb4ab09e509513a7162b97
pipeline-report-2026-10-16.pdf
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Turn a CRM export into a reviewable pipeline forecast
Pipeline Reporter Pro guides your AI agent through a 12-month sales forecast, win/loss analysis and report preparation. Start with a CSV export. Keep currencies and value bases separate, flag unresolved records, and inspect the assumptions behind each scenario.
What you get
- Conservative, expected and upside forecasts, with monthly, stage and owner views.
- Win/loss themes grounded in the notes and loss reasons you supply, not invented explanations.
- Data-quality warnings for missing dates, invalid amounts, unknown stages and conflicting duplicates.
- Report source and structured JSON; a PDF when your agent host has a suitable renderer.
What the package supplies
Package v1.1.0 includes agent instructions, four reporting references and a Python helper for bounded calculations. The helper is not a complete CRM connector or standalone reporting application. Agensi makes the supporting files available through its agent connection.
Requirements and limits
Your agent needs access to the supplied data and supporting files, plus tools to process data and write reports. Python runs the included helper. CRM API access, PDF rendering, email and scheduling depend on your own host tools and accounts; they are not included services. CSV reporting needs no CRM credentials. External access, sending and scheduling require explicit approval. Forecasts are scenarios, not sales guarantees. Resolve conflicting records and review the report before using it for decisions.
Example below
The demo is the complete Markdown report from a synthetic candidate test in Claude on 16 October 2026, with layout-only HTML wrappers removed. It is not customer data, a sales result or proof of live CRM, email or scheduling integration.
- Forecasting accuracy depends on historical data quality
- Win/loss analysis requires deal notes and stage timestamps
- PDF generation may require system fonts (fallback included)
- Direct CRM sync requires separate API keys with read access
- Automated emails require SMTP credentials
- Weekly snapshots accumulate disk usage (user can clean)
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
2 uses
Times used to date
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 1 month ago
Requires
Permissions
File Scopes
CSV reporting reads only the supplied export and supporting files, and writes report outputs. Terminal/Python runs calculation helpers; a renderer is needed for PDF. Network access and environment variables apply only to separately authorized CRM or email integrations, not the CSV path. CRM, email, scheduling and hosting services are not included. Never send or schedule a report without explicit approval.