Tracking · Dashboard & KPI Spec

Spec a Forecast Roll-Up Dashboard for Managers

Spec a forecast roll-up dashboard so managers can submit a defensible number, not a guess.

managerfounderAdvanced⏱ 5-7 hours
When to use
Use when you're forecasting on gut feel and your forecast accuracy is below 80%. Run before introducing a forecast call cadence so the manager has a structured view to defend the number to the founder. Best when you've defined commit / best-case categories in your CRM.
The prompt
You are a RevOps lead spec'ing a forecast roll-up dashboard. You build forecasts the manager can defend, not just submit.
Agency: [AGENCY_NAME] — [SERVICES] | BI: [BI_TOOL] | CRM: [CRM_TOOL] | Audience: sales manager rolling up [REP_COUNT] reps to a founder | Forecast categories: [FORECAST_CATEGORIES] (e.g., Commit / Best Case / Pipeline) | Quota: [QUOTA] | Forecast cadence: [FORECAST_CADENCE]
Spec the forecast roll-up dashboard widget-by-widget — chart type, metric, filter, refresh cadence, action threshold, owner. The dashboard must show commit vs best-case vs weighted, forecast accuracy trend, and per-rep contribution to the number.

- Max 8 widgets
- Must include forecast accuracy trend (last 4 quarters) — no accuracy = no credibility
- Must show variance between forecast call and current week
- Per-rep roll-up breakdown
- No vanity metrics (no 'total pipeline' without a quota comparison)

Markdown table: Widget # | Widget Name | Chart Type | Metric | Filter | Refresh | Action Threshold | Owner. Add a 3-bullet 'how the manager defends the number on the founder call'.
Variables
  • [AGENCY_NAME] — Agency name
  • [SERVICES] — Services sold
  • [BI_TOOL] — BI tool
  • [CRM_TOOL] — CRM
  • [REP_COUNT] — Number of reps rolling up
  • [FORECAST_CATEGORIES] — Your forecast bucket names
  • [QUOTA] — Team quota for the period
  • [FORECAST_CADENCE] — Weekly / bi-weekly call cadence
Example input
Agency: PaidHaus — paid social + creative | BI: HubSpot Reports | CRM: HubSpot | Manager of 4 AEs rolling up to founder | Categories: Commit / Best Case / Pipeline | Quota: $200k new MRR/Q | Cadence: weekly Thursday forecast call
Example output
| # | Widget | Chart | Metric | Filter | Refresh | Action Threshold | Owner |
|---|---|---|---|---|---|---|---|
| 1 | Commit vs Quota | Single value | Commit $ / $200k | This Q | Daily | 10% slip = call out | Manager |
| 6 | Per-Rep Roll-Up | Stacked bar | Commit/Best/Pipe per rep | This Q | Weekly | Any rep <70% commit ratio | Manager |
| 7 | Aging Commit Deals | Table | Commit deals past close date | Open | Daily | Any = remove from commit | Manager |
| 8 | New Pipe Added (Qtr) | Line | New $ created weekly | This Q | Weekly | <$40k/wk = lead gen | Founder |

Defend the number: 1) Open with widget 4 (your track record). 2) Walk widget 1 + 5 to show commit and variance. 3) Use widget 6 to assign accountability per rep.
Pro tips
  • Forecast accuracy is the only metric that earns you credibility — pin widget 4 at the top.
  • Lock 'Commit' deals to specific deal IDs each week and track slip — vibe forecasts die fast.
  • Add a snapshot table that captures the forecast each Thursday so you can compare next week.
Works with
ClaudeChatGPTGemini
Done with prompts? Time to install the system
Book a STAOS call
Related prompts