Lead Generation with Forms, Quizzes & Calculators: Completion Rates, Field Counts, Lead Quality, Cost per Qualified Lead & Follow-up Speed
Turn forms, quizzes and calculators into a measured lead engine. You will split every form into views, starts and submissions, follow multi-step drop-off and field-level abandonment, weigh the number of fields against lead quality, grade leads from A to D, and compare the cost per lead with the cost per qualified lead. You then measure follow-up speed and its effect on contact rates, read quiz funnels, email gates and outcome segments, band calculator runs by estimated saving, split results by device, test form changes with a z-score, audit duplicate and bot leads, follow leads through to customers, map arrival times, forecast volume against adviser capacity, build a profit grid of spend against cost per qualified lead, score lead tools with weights and finish with a programme dashboard: 20 hands-on labs, fictional lead data from a home energy installer, 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 lead forms, quizzes and calculators in 20 interactive spreadsheet labs. You work as the analyst of Tindlewood Home Energy, a fictional installer of solar panels, heat pumps and insulation, and type every formula yourself while a grader checks each cell. You start with view, start and completion rates, follow multi-step drop-off and field-level abandonment, and weigh the number of fields against lead quality. You grade leads from A to D, calculate the cost per qualified lead, measure follow-up speed and test whether faster calls pay. Then you read quiz funnels, email gates and outcome segments, band calculator runs, split results by device, evaluate form A/B tests with a z-score, audit duplicate and bot leads, follow leads through to customers, map arrival times, forecast adviser capacity, build a profit grid and score lead tools on a weighted scorecard. The final project is a lead programme dashboard with a verdict per tool and a chart. All companies, people and numbers are fictional, and 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
- Form Funnel Basics: Start Rate, Completion Rate and View-to-Lead Rate of Every Lead FormFree
- Multi-Step Forms: Continuation Rate per Step, Drop-off Counts and the Share of Starters Remaining Locked
- How Many Fields? Conversion Rate, Qualified Rate and Qualified Leads per 1,000 Views by Form Length Locked
- Field-Level Analysis: Abandonment Rate, Error Rate and a Review Flag for Every Form Field Locked
- Lead Quality Grades: Points for Fit and Intent, Grades A to D with IFS and the Grade Mix Locked
- Cost per Lead vs Cost per Qualified Lead: Why the Cheapest Leads Are Often the Most Expensive Locked
- Follow-up Speed: Minutes to First Response, an SLA Flag, the Share within the SLA, Average and Median Locked
- Does Speed Pay? Leads, Contact Rate and Average Quote Value by Response Time Bucket Locked
- Quiz Funnels: Question-by-Question Reach, the Email Gate and Qualified Leads per 1,000 Starts Locked
- Quiz Outcome Segments: Leads, Qualified Rate, Pipeline Value and Value per Lead by Result Locked
- Savings Calculators: Band Each Run by Estimated Saving, Then Count Runs, Report Requests and the Request Rate Locked
- Mobile, Desktop or Tablet? Form Conversion by Device with SUMIFS and a Weak-Spot Highlight Locked
- Testing a Form Change: Relative Uplift, Pooled Rate, z-Score and a Significance Verdict for Six Tests Locked
- Fake, Duplicate and Bot Leads: Flag Duplicates, Mark Usable Leads and Compare the Cost per Submission with the Cost per Usable Lead Locked
- From Lead to Customer: Lead-to-Customer Rate, Cost per Customer, Revenue per Lead and Net Contribution by Lead Tool Locked
- When Do Leads Arrive? Weekday and Time-of-Day Totals, Share of the Week and a Heat Map Locked
- Forecast and Capacity: A Linear Trend for the Next Quarter, Advisers Needed and the Staffing Gap Locked
- What-If: A Profit Grid of Monthly Spend and Cost per Qualified Lead, Break-even CPQL and Counting the Profitable Cells Locked
- Lead Tool Scorecard: Min-Max Scores, a Reversed Cost Score, Weighted Totals with SUMPRODUCT and Ranks Locked
- Final Project: A Lead Programme Dashboard with Cost per Qualified Lead, Cost per Customer, Net Contribution, a Verdict per Tool and a Chart Locked
Learner reviews
Be the first to review this course.