Day 20: Build a Weekly Sales Dashboard You Can Actually Use

The Concept

There are two kinds of metrics in sales. Lagging indicators tell you what happened: revenue closed, quota attained, deals won. They're accurate and important and entirely useless for changing the month you're already in. You find out in the last week that the month was bad, and there's nothing left to do about it. Leading indicators tell you what's coming: number of active conversations at each stage, quality of pipeline entering the funnel, days since last contact on key deals. These are the metrics that let you intervene before the problem is locked in.

Most CRM reporting is built around lagging indicators, because that's what management needs to report to leadership. Most rep dashboards — to the extent they exist at all — are copies of what the manager asks for. The result is that reps get accurate historical data and no early warning system. A rep who closes 60% of quota in month one isn't behind on most team dashboards. A rep who runs their own dashboard knows by week two whether they have the pipeline to recover.

Leading vs Lagging: A Practical Distinction

The key question for any metric is: does tracking this number change what I do tomorrow? If the answer is no, it's informational but not operational. Lagging metrics pass this test at the team level — a VP needs to know revenue closed to make resource decisions. They often fail at the rep level, because a rep can't close more revenue this week by knowing last week's revenue number. They can change how many targeted prospects they contacted, how many proposals they followed up on, and how many stalled deals they re-engaged.

The specific leading indicators that matter depend heavily on your role and cycle length. An SDR whose job is booking meetings has different leading metrics than an enterprise AE with a six-month cycle. This is why the prompt asks for your role, your quota, your cycle, and your current metrics — generic advice here is nearly useless.

The Friday Review Habit

The Friday check-in is the single highest-leverage weekly habit in sales. Done right, it takes fifteen minutes and surfaces: what actually happened this week vs what you planned, which deals moved and which went quiet, what follow-ups you missed that you need to action before next week, and whether your pipeline heading into next week is healthy enough to hit your number. Most reps skip it because Friday afternoon feels like a natural stopping point, not a time to reflect. That's exactly why doing it compounds so sharply over time — the reps who do it consistently are the ones who never get surprised at month end.

What a Good Weekly Rhythm Looks Like

The structure that works for most reps is simple: Monday morning planning (15 minutes — where is my pipeline, what are my three priorities this week, who do I need to move?), mid-week pulse check (5 minutes — am I tracking against the plan?), Friday review (15 minutes — what happened, what do I carry into next week?). That's 35 minutes a week of structured self-management. The reps who do this aren't working harder. They're working in a direction they can actually see.

AI helps you design the dashboard once, and then it becomes a template you fill in yourself. The value isn't in running the prompt every week — it's in building the system once and making it a habit.