Sales KPI Playbook

The definitive weekly sales dashboard system for revenue operators. Done-for-you KPI templates, automation stack playbooks, and battle-teste...
Quezon City, PH
Created byProfile picturegumbelmiller
1 joined
Profile picture
@gumbelmillerProfile pictureJun 28
Pinned post

Welcome to the Sales KPI Playbook — Start Here 🚀

Welcome to the Sales KPI Playbook 👋


You made it. This community is for sales leaders, RevOps professionals, and SDR/AE managers who are serious about running their sales operation with data — not guesswork.


---


What You Have Access To


📚 The Course — 5 modules, 16 lessons, built for immediate implementation:

  • Module 1: The 7 non-negotiable KPIs and how to define your weekly reporting cadence

  • Module 2: Done-for-you dashboard templates (pipeline health, rep scorecard, forecast, activity metrics)

  • Module 3: Automation stack playbooks (Zapier, Make, Slack, Google Sheets + CRM)

  • Module 4: Sales SOPs library (pipeline review, forecast call, rep check-ins, leadership reporting)

  • Module 5: Troubleshooting guide — 27 fixes for data problems, automation failures, CRM sync issues, and reporting blind spots


💬 Members Chat — Ask questions, share wins, get feedback on your dashboard setup.


📢 Weekly Updates — New frameworks, templates, and case studies drop here every week.


---


Your First 7 Days


Day

Action

Day 1

Complete Module 1 — define your 7 core KPIs

Day 2

Customize the Pipeline Health Dashboard (Module 2)

Day 3

Set up your first automation — Zapier or Make (Module 3)

Day 4

Run your first Pipeline Review using the SOP (Module 4)

Day 5

Run your first Forecast Call using the SOP (Module 4)

Day 6

Audit your reporting blind spots (Module 5, Lesson 4)

Day 7

Post your dashboard setup in chat and get feedback


---


One Rule


Implementation beats perfection. A 70% dashboard running live is worth 10x more than a 100% dashboard still in planning.


See you inside the course. 🚀

Profile picture
@gumbelmillerProfile pictureJun 28
Pinned post

The 7 Sales KPIs Every Revenue Leader Must Track Weekly (Most Teams Get #4 Wrong)

The 7 Sales KPIs Every Revenue Leader Must Track Weekly


Most sales dashboards are built around what's easy to export from a CRM — not what actually predicts revenue. After studying the habits of high-performing sales teams, the leaders who consistently hit their number track the same 7 KPIs every single week.


Here they are, with the one most teams measure incorrectly.


---


KPI 1: Pipeline Coverage Ratio


Formula: Total open pipeline value / Quota for the period


Healthy benchmark: 3x — but only if your win rate is ~33%. The correct benchmark is actually 1/Win Rate.


Why it matters: This is your early warning system. If coverage drops below 2.5x before mid-period, you'll miss your number barring extraordinary luck.


---


KPI 2: Stage Conversion Rates


Formula: (Deals entering Stage N+1) / (Deals entering Stage N) over rolling 30 days


What to look for: Where deals stall. Every pipeline has one stage where conversion rate is significantly lower — that's your bottleneck.


Common pattern: Discovery → Demo converts at 80%, but Demo → Proposal converts at 30%. That means your demo-to-proposal process is broken, not your prospecting.


---


KPI 3: Average Sales Cycle Length by Stage


Formula: Average days a deal spends in each stage — not just end-to-end


Why stage-level matters: "47-day average sales cycle" tells you almost nothing. "17-day average in Negotiation stage" tells you exactly where to focus coaching.


---


KPI 4: Win Rate (The Way 80% of Teams Get It Wrong)


Wrong formula: Won Deals / All Deals in CRM


Correct formula: Won Deals / (Won Deals + Lost Deals) — same time period


Why it matters: A team with 40 won, 60 lost, and 200 still-in-progress deals has:

  • Wrong calculation: 40/300 = 13% (looks terrible)

  • Correct calculation: 40/100 = 40% (actual competitive win rate)


Your win rate should tell you how well you compete when it's decision time. Include open deals and you're measuring noise.


---


KPI 5: Forecast Accuracy


Formula: 1 - (|Actual Closed - Called Forecast| / Called Forecast)


World-class benchmark: 90%+ consistently


Why it matters: Forecast accuracy determines how much leadership trusts your number. A manager wrong by 30% every quarter never gets the resources they need — leadership builds in a discount before they even plan.


Track this weekly. Trend it over quarters.


---


KPI 6: Rep Activity Quality Score


Formula: (Activities that led to a stage advancement or booked next step) / (Total logged activities)


Why quality over quantity: A rep making 200 calls that go to voicemail is less productive than one making 80 calls with 40 live conversations.


Benchmark: 30%+ quality activity rate.


---


KPI 7: Time-to-First-Response on Inbound Leads


Formula: Average minutes between lead submission and first sales contact


Why it belongs on a weekly dashboard: Contacting an inbound lead within 5 minutes vs. 30 minutes can improve conversion dramatically. Most teams don't track this because the real average is 4+ hours — and that's uncomfortable to see.


The benchmark: Under 5 minutes for hot leads. Under 1 hour for all inbound.


---


How to Start Tracking These


You don't need a $50K BI tool. A Google Sheet connected to your CRM is enough to track all 7 on a weekly refresh.


The first step: define the formulas and agree on them as a team before building anything. The most common reason sales dashboards fail is that leadership and managers calculate the same metric differently.


---


What's the one KPI your team has the hardest time tracking accurately? Drop it in the comments — I'll share exactly how to fix it.