Tabellab

From SQL to Pipeline: Cost per Opportunity, Pipeline per Dollar, Expected Revenue with Win Rates and SUMPRODUCT

Lesson 6 of 20 Lab 🔒 Locked

Lessons in this course

  1. LinkedIn Audience Sizing: Job-Title Clusters, Company-Size and Industry Filters and an Audience That Is Neither Too Narrow nor Too BroadLabFree
  2. What Attention Costs: CPM, CTR and CPC per Campaign, the Blended CPM and the CTR You Need for a Target Cost per ClickLab Locked
  3. From Click to Lead: Click-to-Lead Rate, Cost per Lead by Offer, a Target Check and the Blended CPLLab Locked
  4. Lead Gen Forms vs Landing Pages: CPL per Destination, the Form Saving, the Conversion Multiple and a Side-by-Side ChartLab Locked
  5. Lead Quality: Lead-to-MQL and MQL-to-SQL Rates, Cost per SQL and Why the CPL Ranking FlipsLab Locked
  6. From SQL to Pipeline: Cost per Opportunity, Pipeline per Dollar, Expected Revenue with Win Rates and SUMPRODUCTLab Locked
  7. Account Lists for ABM: Match Rate, Members per Matched Account, the Minimum Audience and How Many Accounts a List NeedsLab Locked
  8. Planning Forwards: From Budget and CPM to Impressions, Expected Leads, Expected CPL and Frequency in a Small AudienceLab Locked
  9. Who Got the Budget? Spend, Leads, CPL and Cost per SQL by Seniority with SUMIFS and a Conditional FormatLab Locked
  10. Lead Quality Check: Testing Leads Against the Target Profile with IF and AND, the On-Target Rate and the Cost per Usable LeadLab Locked
  11. Creative Fatigue in a Small Audience: Weekly CTR, the Trend with SLOPE, a Forecast and the Week to Refresh the AdLab Locked
  12. Testing Lead Gen Forms: Submit-Rate Difference, Pooled Standard Error, z-Score, p-Value and a Verdict per TestLab Locked
  13. Scaling the Budget: Average CPL vs the Marginal Cost of an Extra Lead with SLOPE, a Forecast and a Scatter ChartLab Locked
  14. The Sales Cycle: Days from Lead to Opportunity and to Close with DAYS, AVERAGEIFS by Destination and the MedianLab Locked
  15. Account-Based Reporting: Penetration per Account, Tier Goals with XLOOKUP, Multi-Threaded Accounts and Concentration with LARGELab Locked
  16. Allocating the Budget: Ranking Segments by Cost per SQL and Filling Each up to Its Maximum Spend with SUMIFS, MIN and MAXLab Locked
  17. What-If Grid: Expected Revenue per Dollar for Every CPL and Lead-to-SQL Rate, a Heat Map and the Highest Affordable CPLLab Locked
  18. Lead Scoring: A Weighted Score with SUMPRODUCT, Grades with IFS, the Cost per A Lead and Average Scores by DestinationLab Locked
  19. Budget Pacing: Running Totals, the Plan Line with DAY and EOMONTH, the Pace Index and the Month-End ProjectionLab Locked
  20. Final Project: LinkedIn Programme Dashboard by Campaign Group with CPL, Cost per SQL, Pipeline per Dollar, a Verdict and a Combo ChartLab Locked