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

The Point Of Today

Sales dashboards often tell you what already happened. You need one that tells you what to do next.

Closed revenue matters, but it arrives late. By the time you know the month is weak, the actions that would have fixed it needed to happen weeks earlier.

Today you will build a personal weekly sales dashboard. Not a management report. Not a CRM compliance view. A simple operating tool that helps you see pipeline health, choose priorities, and prevent avoidable surprises.

AI helps by tailoring the metrics to your role, cycle length, and consistency problem. A dashboard for an SDR should not look like a dashboard for an enterprise AE. A dashboard for expansion revenue should not look like a new-logo outbound dashboard.

Leading Indicators Matter Most

Leading indicators are metrics that predict future results and can still be changed.

Examples:

• New qualified conversations started.
• Target accounts researched.
• Discovery calls with confirmed pain.
• Proposals with identified decision process.
• Stalled deals re-engaged.
• Referrals requested after client wins.
• Follow-ups completed within agreed timing.
• Deals with next step and owner confirmed.

These numbers help you act before the outcome is final.

Lagging indicators still matter, but they should not dominate your weekly attention. Closed revenue, win rate, and quota attainment tell you whether the system worked. Leading indicators tell you where to adjust the system.

Track What Changes Decisions

A metric is useful if it changes what you do.

If tracking call volume helps you identify prospecting inconsistency, track it. If it only makes you feel busy, stop overvaluing it.

If tracking proposals sent does not tell you whether those proposals have economic buyer access or next steps, it may create false confidence.

Better metric:

"Proposals sent with confirmed decision process and next meeting scheduled."

That is a metric with judgment built in.

The Friday Review

Friday is where the dashboard earns its keep.

A good Friday review asks:

• What moved this week?
• What did not move and why?
• Which deal is at risk?
• Which follow-up did I avoid?
• Which leading indicator is weak?
• What did I learn from calls or losses?
• What must be true by next Friday?

This review should take 15 minutes. If it takes an hour, you will not do it consistently.

The Monday Plan

Monday planning turns review into action.

Use a short structure:

1. What is the highest-risk part of my pipeline?
2. Which three actions would improve it this week?
3. Which existing deal needs movement?
4. Which new opportunity must be created?
5. What will I stop doing because it does not matter?

Then put actions on the calendar.

A plan that stays in your head is fragile. A plan with time assigned is more likely to happen.

Pipeline Health Score

A simple score can be useful if it summarizes the right signals.

For example:

• 8-10: enough active pipeline, next steps clear, leading indicators healthy.
• 5-7: some risk, one major area needs attention.
• 3-4: pipeline may miss unless behavior changes immediately.
• 1-2: current activity and deal health do not support the target.

The number is less important than the conversation it creates with yourself.

Use The Dashboard To Choose Tradeoffs

A dashboard should help you decide what not to do. Sales weeks are full of plausible activities: research more accounts, write better emails, prepare for a demo, chase a quiet deal, update CRM, ask for referrals, review a call. All may be useful. Not all are equally urgent.

When your dashboard shows weak early-stage pipeline, prospecting and list quality move up. When it shows many proposals but few decisions, follow-up and stakeholder alignment matter more. When it shows enough activity but poor conversion, qualification or messaging may be the issue. The dashboard is valuable because it turns vague pressure into a specific tradeoff.

Avoid Metric Theater

Metric theater is tracking numbers that make you look active without helping you sell better.

Examples:

• Raw calls without target quality.
• Emails sent without reply or meeting quality.
• Pipeline value without close probability discipline.
• Meetings booked without fit.
• Proposals sent without decision process.

AI can help identify which metric you are overvaluing. Be honest. Most sellers have at least one.

Today's Practice

Run the prompt. Build the dashboard in a tool you already open.

Do not create a complicated spreadsheet you will abandon. A simple note, Notion page, CRM view, or recurring calendar prompt is enough if you actually use it.

Schedule:

• Friday review.
• Monday planning.

The weekly rhythm matters more than the dashboard design.

The goal is not perfect measurement. The goal is earlier awareness and better action. A useful dashboard gives you time to fix the week before the week is gone.