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.

managerfounderAdvanced5-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

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

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

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.

Related prompts

Tracking

Spec a Sales Pipeline Dashboard for an Agency Founder

Tracking

Build a Rep Activity KPI Dashboard

Tracking

Design a Conversion-Rate Dashboard by Stage

Free 20 minute sales audit

A prompt is not a system.

These are free and they work. What they cannot do is make your team run the play every week. That is the part we install.

Book a Free Sales Audit