Sales

Home Forecast Attainment % in Excel (Booked vs Forecast) Learn how to compare your team’s live pipeline forecast against what actually gets booked. In this lesson, you’ll build a clear month-by-month view of forecast vs actuals, spot where deals slip or fall out, and use the results to coach reps and improve forecasting discipline. Download

Home How to Track Pipeline Coverage Ratio in Excel Learn how to turn your pipeline into a simple warning system for hitting next month’s revenue target. In this lesson, you’ll build a monthly view of expected revenue vs. target, visualize your coverage ratio in one clear chart, and break down which reps (or job types)

Home Pipeline Creation Rate: Track Future Bookings Before They Happen Learn how to track pipeline created each week so you can forecast next month’s bookings with confidence. In this lesson, you’ll build a clear weekly view that helps you spot rep inconsistency, seasonality, and channel issues early, so your team can course-correct before revenue slips.

Home How to Track Accessory Attach Rate by Month and Rep A strong close rate can still hide missed revenue. In this lesson, you’ll learn how to measure Accessory Attach Rate (%) so you can see whether reps are consistently packaging the right add-ons, track improvement month over month, and spot coaching opportunities by job

Home Financing Adoption Rate: Track It by Month, Tech, and Job Type See how to measure whether financing is truly part of your sales process (or just happening by chance). In this lesson, you’ll learn how to track financing adoption month by month, compare performance across techs/sales reps, and break results down by job type

Home Find Hidden Discounting: Quote-to-Sold Price Realization in Excel If your close rate looks great but profit still feels light, this KPI helps explain why. In this lesson, you’ll learn how to track the gap between what your team quotes and what you actually sell, spot where concessions are happening, and visualize trends by month

Home Average Sold Job Value by Month (with Pivot Tables + Slicers) Learn how to uncover what’s really driving your Average Sold Job Value by breaking it down over time and slicing performance by rep, system type, equipment tier, territory, and lead source. You’ll build a clean trend view, then create an interactive setup that

Home Revenue Booked per Rep per Week: Track Sales Consistency Sales can look “up” and still hide problems. In this lesson, you’ll learn how to break down booked revenue by rep and by week so you can spot top producers, identify inconsistency, and make forecasting decisions based on real performance trends, not gut feel. Download

Home Reactivated Lead Close Rate: How to Win More Deals From Your Existing Pipeline New leads are great, but your fastest growth often comes from the leads you already earned. In this lesson, you’ll learn how to measure your Reactivated Lead Close Rate (%), spot what’s working by month, lead source, and follow-up method, and

Home Measure Sales Cycle Length in Excel Learn how to measure how long your deals actually take to close and identify what’s slowing your sales process down. In this lesson, you’ll build a visual that reveals delays by rep, lead source, and month so you can improve scheduling, forecasting, and cash flow. Download the Excel