Pipeline Velocity: Opportunities, Win Rate, ACV and Cycle Length by Programme
Lessons in this course
- ICP Fit Scoring: Industry Points, Size Bands, a Capped Site Score and the Target ListFree
- Target Account Tiers: One-to-One, One-to-Few and One-to-Many with AND, COUNTIFS and a Tier Budget Locked
- Weighted Fit Model: SUMPRODUCT Scores, RANK.EQ and a Capacity Cut-Off with LARGE Locked
- Account Engagement Score: Weighted Activities, Hot-Warm-Cold Status and Score per Active Contact Locked
- Engagement Recency: a 30-Day Window with SUMIFS and Half-Life Decay with SUMPRODUCT Locked
- Buying-Committee Coverage: Engaged Contacts, Roles Covered and the Single-Threaded Risk Locked
- Account Stage Progression: Stage Numbers with XLOOKUP, Forward-Held-Back and the Progression Rate Locked
- Pipeline Velocity: Opportunities, Win Rate, ACV and Cycle Length by Programme Locked
- ABM vs Broad Demand Gen: ROI per Programme, SUMIFS and SUMPRODUCT Group Totals Locked
- Account Funnel: Step Rates, ABM Advantage, the Weakest Step with INDEX-MATCH and a Formula Rule Locked
- Win Rate and ACV by Tier: COUNTIFS, AVERAGEIFS and the Expected Value of a Deal Locked
- Sales Cycle Length: Date Differences, AVERAGEIFS, MAXIFS and the Share of Fast Closes Locked
- ABM Budget Allocation: Shares by Tier, SUMPRODUCT Tier Costs and Cost per Account, Engaged Account and Opportunity Locked
- ABM Play Performance: Advance Rate, Cost per Advanced Account, RANK.EQ and a Keep-or-Review Rule Locked
- Intent Signals: Precision, Recall and Lift for Three Score Thresholds Locked
- ABM Pipeline Forecast: SLOPE, RSQ and FORECAST.LINEAR for the Next Quarter Locked
- Expansion ABM: Whitespace, Net and Gross Revenue Retention with SUMPRODUCT and INDEX-MATCH Locked
- Account Attribution: Linear and U-Shaped Credit per Touch and SUMIFS Channel Totals Locked
- Budget Mix Scenarios: a Two-Way Grid with Mixed References, a Required Share and a Heat Map Locked
- Final Project: an ABM Account Readiness Dashboard with Weights, Next Actions, Tier Summaries, Chart and Heat Map Locked