Ryan Deiss (presenter) explains how to build a CEO dashboard in Google Sheets that lets a CEO manage a portfolio from a single sheet. Core rules: every metric must have a locked pre-month target proposed by the metric owner and approved by the CEO (if uncertain, defer to the owner); use a three-color status system—green = on/ahead, yellow = behind but with a recovery plan, red = behind with no plan; “close” doesn’t count (a numeric miss without a plan is treated as a failure). Examples given: 6,000 new leads, 15 booked calls, NPS 60. Advice is aimed at owners scaling small businesses into $10–20M firms.
Questions this video answers
17 companies
$200 million
6,000 new leads; 15 booked calls; an NPS of 60
Chapters
I run 17 companies inside a $200 million portfolio, and I see most two to $5 million businesses become 10 to $20 million businesses after implementing something that they can build in half a day. This is part five of how to build a CEO dashboard, so powerful that you can manage your business on a single Google sheet. If you don't define what winning looks like before the month starts, you simply won't hit that goal and be like, yeah, we didn't hit the goal, but we sure did learn a lot. Look, that is not leadership. That is called revisionist history. So here's the rule. Before the month begins, every metric gets a target. 6,000 new leads, 15 book calls, an NPS of 60. Whatever it is, lock it in. The owner of that metric should propose the target. The CEO should approve it, and if in doubt, let the owner have their way. You can't ask somebody to own a metric and then dictate the number to them. Once you got those targets, then the color system really comes alive. Green means you're on track or ahead. Red means you are behind, and yellow means that you're behind. But there is a plan to get back on track. So let's talk about the idea of close. Close doesn't count. This isn't hand grenades, all right? I don't care if you hit 5,800 leads. If the goal was 6,000, then it's a miss. If there's not a plan, then it's red. If there is a plan, then it's yellow. When you combine targets with this color coding system, suddenly you don't need to study every line on the sheet at a glance. You. You know if the company's winning or losing. It's sort of like looking at a stoplight. Now that you get everything on your dashboard. The metrics, the owners, the targets, and the colors you need to effectively implement. So follow along for part six, and we'll talk about how to do that.
