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.
- 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
- 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
Learner reviews
Be the first to review this course.