Tabellab
Marketing Analytics Intermediate

LinkedIn Ads for B2B Lead Generation: Audience Sizing, CPM & CPL, Lead Gen Forms vs Landing Pages, Lead Quality, Pipeline & Account Lists

Plan and judge LinkedIn campaigns for B2B in Excel. You will size audiences from job titles, company size and industry, calculate CPM, CTR, CPC and cost per lead, compare Lead Gen Forms with landing pages, follow leads to MQL, SQL and pipeline, check account lists and match rates, forecast leads from a budget, break results down by seniority, test leads against the target profile, measure creative fatigue, test forms for significance, find the marginal cost of scaling, time the sales cycle, report account penetration, allocate a budget with caps, build a what-if grid, score leads, pace a monthly budget and finish with a programme dashboard: 20 hands-on labs, fictional B2B software company, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the numbers behind LinkedIn advertising for B2B lead generation, one spreadsheet lab at a time. You work for Corvanta Systems, a fictional software company that sells warehouse scheduling software, and you build every calculation yourself in an Excel-like sheet that checks each cell. In the 20 labs you size audiences from job titles, company size and industry, calculate CPM, CTR, CPC and cost per lead, compare Lead Gen Forms with landing pages, follow leads to MQL, SQL and pipeline, check account lists and match rates, forecast leads from a budget, test leads against the target profile, measure creative fatigue, test form variants for significance, find the marginal cost of scaling, time the sales cycle, allocate and pace a budget, score leads and finish with a programme dashboard. The focus is on durable arithmetic and judgement rather than on platform settings, which change. All companies, people and numbers are fictional and all benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy