From SQL to Pipeline: Cost per Opportunity, Pipeline per Dollar, Expected Revenue with Win Rates and SUMPRODUCT
Lessons in this course
- LinkedIn Audience Sizing: Job-Title Clusters, Company-Size and Industry Filters and an Audience That Is Neither Too Narrow nor Too BroadFree
- What Attention Costs: CPM, CTR and CPC per Campaign, the Blended CPM and the CTR You Need for a Target Cost per Click Locked
- From Click to Lead: Click-to-Lead Rate, Cost per Lead by Offer, a Target Check and the Blended CPL Locked
- Lead Gen Forms vs Landing Pages: CPL per Destination, the Form Saving, the Conversion Multiple and a Side-by-Side Chart Locked
- Lead Quality: Lead-to-MQL and MQL-to-SQL Rates, Cost per SQL and Why the CPL Ranking Flips Locked
- From SQL to Pipeline: Cost per Opportunity, Pipeline per Dollar, Expected Revenue with Win Rates and SUMPRODUCT Locked
- Account Lists for ABM: Match Rate, Members per Matched Account, the Minimum Audience and How Many Accounts a List Needs Locked
- Planning Forwards: From Budget and CPM to Impressions, Expected Leads, Expected CPL and Frequency in a Small Audience Locked
- Who Got the Budget? Spend, Leads, CPL and Cost per SQL by Seniority with SUMIFS and a Conditional Format Locked
- Lead Quality Check: Testing Leads Against the Target Profile with IF and AND, the On-Target Rate and the Cost per Usable Lead Locked
- Creative Fatigue in a Small Audience: Weekly CTR, the Trend with SLOPE, a Forecast and the Week to Refresh the Ad Locked
- Testing Lead Gen Forms: Submit-Rate Difference, Pooled Standard Error, z-Score, p-Value and a Verdict per Test Locked
- Scaling the Budget: Average CPL vs the Marginal Cost of an Extra Lead with SLOPE, a Forecast and a Scatter Chart Locked
- The Sales Cycle: Days from Lead to Opportunity and to Close with DAYS, AVERAGEIFS by Destination and the Median Locked
- Account-Based Reporting: Penetration per Account, Tier Goals with XLOOKUP, Multi-Threaded Accounts and Concentration with LARGE Locked
- Allocating the Budget: Ranking Segments by Cost per SQL and Filling Each up to Its Maximum Spend with SUMIFS, MIN and MAX Locked
- What-If Grid: Expected Revenue per Dollar for Every CPL and Lead-to-SQL Rate, a Heat Map and the Highest Affordable CPL Locked
- Lead Scoring: A Weighted Score with SUMPRODUCT, Grades with IFS, the Cost per A Lead and Average Scores by Destination Locked
- Budget Pacing: Running Totals, the Plan Line with DAY and EOMONTH, the Pace Index and the Month-End Projection Locked
- Final Project: LinkedIn Programme Dashboard by Campaign Group with CPL, Cost per SQL, Pipeline per Dollar, a Verdict and a Combo Chart Locked