How to build and run a CEO dashboard in one hour per week

Executive overview

Most business dashboards fail because they generate data, not insight. A simple company scorecard in Google Sheets, updated manually each week, outperforms expensive BI tools by forcing team members to own their numbers.

The system has four principles: keep it simple, track weekly, make it manual, and mirror your value engines. Five setup steps get you to a working scorecard in a single session.

The core insight: a human reviewing manually entered numbers produces insight; automated dashboards produce only data.

The four core principles

• Google Sheets beats BI tools — complex tooling breaks, loses trust, and requires dedicated teams to maintain
• Weekly cadence is the sweet spot — daily creates noise, monthly is too slow to act on
• Manual entry is intentional — people who enter their own numbers know and own them
• Metrics must mirror your value engines — each department's tracked metrics should map to how value is actually created

Step 1–2: define and choose metrics

• Evergreen metrics are ongoing financials: revenue, cash collected, revenue per employee, NPS
• North Star metrics are 3–5 highlights set each quarter to focus leadership attention — drawn from existing department metrics, not new ones
• Department metrics (marketing, sales, product, support) should be derived from your growth and fulfilment engines, not just asked from department heads
• Each main department keeps its own deeper scorecard; only 3–5 metrics roll up to the CEO dashboard

Step 3: assign a metric owner

• Every metric needs a named owner — not just for reporting, but for optimisation
• Ambiguity about ownership guarantees the metric won't improve
• The owner should have accountability for moving the number, not just entering it

Step 4: set the monthly target

• Targets must be agreed before the month starts — no revisionist history
• Set collaboratively: CEO, department head, and metric owner all have input
• Prefer targets the team can hit over aggressive stretch goals; consistent misses are more demoralising than modest wins
• If in doubt, go with the team's number

Step 5: track, report, and act weekly

• Team enters data manually every Monday morning for the prior week (Mon–Sun)
• Status is colour-coded manually:
  1. Green — on track or ahead
  2. Light green — slightly behind but catchable
  3. Yellow — behind, but with a documented plan in the notes column
  4. Light red — behind, no clear plan yet
  5. Red — too far behind to recover, or end-of-month miss
• Yellow status requires a written plan in the notes column — no plan means light red
• The notes column provides context for anyone not in the meeting

Scorecard-based leadership

• The leader's job is to scan for red and yellow, then ask questions that help the team turn red to yellow and yellow to green
• If yellow already has a plan in the notes, no intervention needed — trust the team
• Leadership is not about having answers; it is about putting the right people in the right roles and tracking outcomes