Tabellab

ABM Pipeline Forecast: SLOPE, RSQ and FORECAST.LINEAR for the Next Quarter

Lesson 16 of 20 Lab 🔒 Locked

Lessons in this course

  1. ICP Fit Scoring: Industry Points, Size Bands, a Capped Site Score and the Target ListLabFree
  2. Target Account Tiers: One-to-One, One-to-Few and One-to-Many with AND, COUNTIFS and a Tier BudgetLab Locked
  3. Weighted Fit Model: SUMPRODUCT Scores, RANK.EQ and a Capacity Cut-Off with LARGELab Locked
  4. Account Engagement Score: Weighted Activities, Hot-Warm-Cold Status and Score per Active ContactLab Locked
  5. Engagement Recency: a 30-Day Window with SUMIFS and Half-Life Decay with SUMPRODUCTLab Locked
  6. Buying-Committee Coverage: Engaged Contacts, Roles Covered and the Single-Threaded RiskLab Locked
  7. Account Stage Progression: Stage Numbers with XLOOKUP, Forward-Held-Back and the Progression RateLab Locked
  8. Pipeline Velocity: Opportunities, Win Rate, ACV and Cycle Length by ProgrammeLab Locked
  9. ABM vs Broad Demand Gen: ROI per Programme, SUMIFS and SUMPRODUCT Group TotalsLab Locked
  10. Account Funnel: Step Rates, ABM Advantage, the Weakest Step with INDEX-MATCH and a Formula RuleLab Locked
  11. Win Rate and ACV by Tier: COUNTIFS, AVERAGEIFS and the Expected Value of a DealLab Locked
  12. Sales Cycle Length: Date Differences, AVERAGEIFS, MAXIFS and the Share of Fast ClosesLab Locked
  13. ABM Budget Allocation: Shares by Tier, SUMPRODUCT Tier Costs and Cost per Account, Engaged Account and OpportunityLab Locked
  14. ABM Play Performance: Advance Rate, Cost per Advanced Account, RANK.EQ and a Keep-or-Review RuleLab Locked
  15. Intent Signals: Precision, Recall and Lift for Three Score ThresholdsLab Locked
  16. ABM Pipeline Forecast: SLOPE, RSQ and FORECAST.LINEAR for the Next QuarterLab Locked
  17. Expansion ABM: Whitespace, Net and Gross Revenue Retention with SUMPRODUCT and INDEX-MATCHLab Locked
  18. Account Attribution: Linear and U-Shaped Credit per Touch and SUMIFS Channel TotalsLab Locked
  19. Budget Mix Scenarios: a Two-Way Grid with Mixed References, a Required Share and a Heat MapLab Locked
  20. Final Project: an ABM Account Readiness Dashboard with Weights, Next Actions, Tier Summaries, Chart and Heat MapLab Locked