Why a lead form deserves numbers of its own
Almost every business that sells something with a long decision, such as solar panels, a heat pump, a loft conversion, a mortgage or a language course, depends on a small piece of web page: the lead form. A visitor types a name, an email address and a few facts about the project, presses send, and from that moment a salesperson has somebody to call. The form is the narrowest point of the whole funnel. Everything you pay for upstream, every advert and every article, has to squeeze through it.
Yet many teams look at a form only through one number: how many submissions came in last month. That number cannot tell you whether the form is the problem or the page around it, whether a change helped or whether the new leads are any good. To answer these questions you need to count what happens before the submission, and the first lesson of this course is exactly that: split a form into views, starts and completed submissions, and read three simple ratios.
The example is Tindlewood Home Energy, a fictional installer of solar panels, heat pumps and insulation with ten lead forms on its website. All forms, people and numbers are invented for learning, and every benchmark in this course is illustrative. You will use the same ten forms as in the lab above, with the counts of one month (March).
The three moments of a form: view, start, completion
A lead form has three moments that a form analytics tool, or even a simple event setup in your web analytics, can count. A form view is counted when the form was shown to a visitor on the screen. A form start is counted when the visitor touched the first field. A completed submission, a lead, is counted when the form was sent and accepted. Each moment is a subset of the one before it, so the numbers can only go down from left to right.
Why separate the starts from the views? Because they answer different questions. Whether a visitor starts the form depends on the page: the promise in the headline, the trust signals, the position of the form and the first impression of its first field. Whether a visitor who has started also finishes depends on the form itself: the number of questions, how clear they are, whether error messages help and whether the page works on a phone. A single conversion rate mixes both stories together.
Three ratios: start rate, completion rate and view-to-lead rate
Three ratios describe the form, and each one is a simple division. All of them are shares between 0% and 100%, and the denominator is always the step directly before:
- Start rate = form starts ÷ form views. It shows how many of the people who saw the form were willing to begin.
- Completion rate = completed submissions ÷ form starts. It shows how many of the people who began were willing, and able, to finish.
- View-to-lead rate = completed submissions ÷ form views. It is the number that decides how many leads a visit to the page brings.
The three ratios are connected: the view-to-lead rate is the product of the other two, start rate × completion rate. For the heat pump quote form in Figure 1 this is 32.0% × 35.0% = 11.2%. This is not just a curiosity. It tells you that a form can improve in two independent ways, and that a gain of ten percent in either ratio gives the same ten percent gain in leads. Often one of the two is cheaper to improve than the other.
A fully worked example: ten forms at Tindlewood Home Energy
Here are the ten forms of the lab with their counts for March and the three calculated ratios. The last row has the totals and the ratios calculated from the totals, which is a point we return to below.
| # | Form | Views | Starts | Completed | Start rate | Completion rate | View-to-lead rate |
|---|---|---|---|---|---|---|---|
| 1 | Solar quote form (homepage) | 4,200 | 1,470 | 588 | 35.0% | 40.0% | 14.0% |
| 2 | Solar quote form (landing page) | 3,100 | 1,364 | 682 | 44.0% | 50.0% | 22.0% |
| 3 | Heat pump quote form | 2,600 | 832 | 291 | 32.0% | 35.0% | 11.2% |
| 4 | Insulation survey request | 1,800 | 666 | 333 | 37.0% | 50.0% | 18.5% |
| 5 | Battery storage enquiry | 1,500 | 420 | 126 | 28.0% | 30.0% | 8.4% |
| 6 | Callback request (short form) | 5,200 | 1,300 | 1,066 | 25.0% | 82.0% | 20.5% |
| 7 | Brochure request | 2,400 | 912 | 730 | 38.0% | 80.0% | 30.4% |
| 8 | EV charger quote form | 1,900 | 589 | 224 | 31.0% | 38.0% | 11.8% |
| 9 | Boiler upgrade grant check | 3,600 | 1,620 | 648 | 45.0% | 40.0% | 18.0% |
| 10 | Commercial solar enquiry | 900 | 207 | 62 | 23.0% | 30.0% | 6.9% |
| All forms | 27,200 | 9,380 | 4,750 | 34.5% | 50.6% | 17.5% |
Two things stand out immediately. First, the forms differ enormously: the view-to-lead rate runs from 6.9% for the commercial solar enquiry to 30.4% for the brochure request, a factor of 4.4. Second, the rate of the whole website is 17.5%, because 4,750 of the 27,200 form views ended in a lead. Neither number alone says what to do. The comparison of start rate and completion rate does.
Step by step in a spreadsheet
The lab asks you to build exactly this table. Put the form names in column A, the views in B, the starts in C and the completed submissions in D, with the data starting in row 4. Then you need only five formulas.
- Start rate in E4:
=C4/B4, then copy the formula down to E13. A spreadsheet adjusts the row numbers by itself, so every row divides its own starts by its own views. - Completion rate in F4:
=D4/C4, copied down to F13. - View-to-lead rate in G4:
=D4/B4, copied down to G13. As a check,=E4*F4must give the same value. - Totals in B14:D14 with
=SUM(B4:B13)copied to the right. SUM adds every cell from B4 to B13. - Overall view-to-lead rate in G14:
=D14/B14, which is 4,750 ÷ 27,200 = 17.5%.
Format the rate columns as percentages. A cell that holds 0.3498 and shows 35.0% is the same number; the format only changes how it is displayed. If you see 0.35 instead of 35.0%, apply the percentage format and keep one decimal place, which is enough for forms with a few hundred starts.
Why you never average the rates
A tempting shortcut for the last row is =AVERAGE(G4:G13). It is wrong, and in this example the error is not small: the average of the ten view-to-lead rates is 16.2%, while the real overall rate is 17.5%. The reason is weight. The commercial solar enquiry, with only 900 views, counts as much in the average as the callback request, which was seen 5,200 times. The sum of the leads divided by the sum of the views gives every visitor the same weight, which is what you want.
This rule is one of the most important in the whole course: add first, divide afterwards. It applies to every ratio you will meet, from the cost per qualified lead to the contact rate. When someone shows you an average of rates, ask for the counts behind it.
Reading the result: is it the page or the form?
Now use the two separate ratios as a diagnosis. Look at the scatter plot in Figure 3, which places every form by its start rate and its completion rate. The dashed lines mark the rates of the whole website, so that the plot splits into four zones.
- Low start rate, high completion rate. The callback request (form 6) starts only 25.0% of its views, but 82.0% of the starters finish: the form is easy, so look at the page. Is the form visible without scrolling? Does the headline explain why a callback is useful?
- High start rate, low completion rate. The boiler upgrade grant check (form 9) is started by 45.0% of its visitors, which says the topic attracts people, but only 40.0% finish. Here the form is the problem: look at the number and type of questions and at the error messages.
- High on both. The brochure request (form 7) combines a start rate of 38.0% with a completion rate of 80.0%. It has the highest view-to-lead rate of all ten forms, but it also asks for the least commitment, so its leads are probably the least ready to buy. Lessons 5 and 6 show how to check that.
- Low on both. The commercial solar enquiry (form 10) has 23.0% and 30.0%. Its audience is small and each lead is valuable, so a low rate may be acceptable; check the quality before you decide to change it.
Be careful with small numbers. The commercial solar enquiry has 207 starts; one more or one fewer completed submission moves its completion rate by half a percentage point. Before you rebuild a form because of a rate, check that the counts behind it are large enough, and compare the same form over several months.
Common mistakes and how to spot them
Four mistakes account for most wrong form reports:
- Swapping numerator and denominator. The start rate is starts ÷ views, not views ÷ starts. A result above 100% is the warning sign.
- Dividing the completed submissions by the views for the completion rate. That gives the view-to-lead rate. The completion rate looks only at the people who started.
- Averaging the rates of several forms. Use the totals, as shown above.
- Mixing periods or definitions. If the views come from March and the submissions from the CRM for April, or if one form counts a start at the first click and another at the first keystroke, the rates cannot be compared. Write the definitions down once and use them everywhere.
Quick reference: functions and shortcuts in this lesson
These are all the tools you need for the first lab:
=C4/B4: a division of two cells; format the result as a percentage.=SUM(B4:B13): adds all cells of a range; use it for the totals row.=D14/B14: a ratio of two totals, the correct overall rate.- Copy a formula down: select the cell, drag the fill handle or use Ctrl/Cmd + C and Ctrl/Cmd + V on the range below.
=AVERAGE(G4:G13): the average of the rates, shown here only as the example of what not to use for an overall rate.
Real-world uses
The same three ratios work wherever people fill in something before they get something:
- Monthly form review. Export the counts per form from your analytics tool, paste them into the sheet and sort by view-to-lead rate. The forms in the red zone are your agenda for the month.
- Landing page tests. If a new headline raises the start rate but leaves the completion rate unchanged, the test did what it should. If the completion rate drops, the new headline attracts people the form cannot hold.
- Agency and freelancer reports. Ask for views, starts and completions, not only submissions. A report that contains only submissions cannot tell a good page from a lucky month.
- Checkout and booking forms. The same funnel exists in a booking request, a demo request or a membership sign-up. Replace the names and keep the logic.
- Setting targets. A target such as 'raise the callback request start rate from 25% to 30%' is concrete and measurable, unlike 'get more leads'.
What you will build in the rest of this course
The first lab is the foundation. The remaining nineteen labs follow a lead from the first view to the paying customer:
- Lessons 2 to 4: multi-step forms and the drop-off between steps, the trade-off between the number of fields and the conversion rate, and a field-by-field analysis of abandonment and errors.
- Lessons 5 to 8: lead quality grades from A to D, the cost per qualified lead, follow-up speed and whether a faster response pays.
- Lessons 9 to 11: quiz funnels with an email gate, quiz outcome segments and savings calculators.
- Lessons 12 to 14: results by device, A/B tests of form changes with a z-score and an audit of duplicate and bot leads.
- Lessons 15 to 19: lead-to-customer rates and net contribution, arrival times, forecasts and adviser capacity, a what-if profit grid and a weighted scorecard of lead tools.
- Lesson 20: a final project, a lead programme dashboard with a verdict for each tool and a chart.
Summary
A lead form is measured in three moments: views, starts and completed submissions. The start rate is =C4/B4, the completion rate =D4/C4 and the view-to-lead rate =D4/B4, which is the product of the other two. At Tindlewood Home Energy the ten forms range from 6.9% to 30.4%, and the overall rate, calculated from the totals with =D14/B14, is 17.5%; the average of the ten rates would wrongly show 16.2%.
Now scroll up to the lab and build the sheet yourself. It takes about fifteen minutes, the Coach checks each step, and you will end up with a form report you can apply to your own export today.
Frequently asked questions
What is the difference between the completion rate and the conversion rate of a form?
The completion rate divides the completed submissions by the people who started the form. The conversion rate (here called view-to-lead rate) divides them by everyone who saw the form. The conversion rate is always the lower of the two, because the starters are a part of the viewers.
What is a good form completion rate?
There is no universal figure. Short forms such as a callback request often reach 70% to 80% of starters, while long quote forms may finish at 30% to 50%. Compare your forms with each other and with their own history, and treat any outside benchmark as illustrative.
How do I count a form start?
Most form analytics tools count a start when a visitor first touches a field. Whatever definition you use, use it for every form and keep it unchanged, otherwise the start rates cannot be compared.
Why is the overall rate not the average of the form rates?
Because a form with few visitors would count as much as a form with many. Add the leads and the views of all forms first, then divide the two totals.
Do I need special software to follow this lesson?
No. The lab runs in your browser and checks your formulas instantly. In your own work you need the counts of views, starts and submissions, which most form builders and web analytics tools can provide.
Does a high view-to-lead rate mean a form is good?
Not by itself. A form that asks for very little can have a high rate and still bring leads who never answer the phone. Later lessons add lead quality grades and the cost per qualified lead to complete the picture.
Keep going: Lead Generation with Forms, Quizzes & Calculators: Completion Rates, Field Counts, Lead Quality, Cost per Qualified Lead & Follow-up Speed
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Multi-Step Forms: Continuation Rate per Step, Drop-off Counts and the Share of Starters Remaining
- How Many Fields? Conversion Rate, Qualified Rate and Qualified Leads per 1,000 Views by Form Length
- Field-Level Analysis: Abandonment Rate, Error Rate and a Review Flag for Every Form Field
- Lead Quality Grades: Points for Fit and Intent, Grades A to D with IFS and the Grade Mix
- Cost per Lead vs Cost per Qualified Lead: Why the Cheapest Leads Are Often the Most Expensive
- Follow-up Speed: Minutes to First Response, an SLA Flag, the Share within the SLA, Average and Median
- Does Speed Pay? Leads, Contact Rate and Average Quote Value by Response Time Bucket
- Quiz Funnels: Question-by-Question Reach, the Email Gate and Qualified Leads per 1,000 Starts
- Quiz Outcome Segments: Leads, Qualified Rate, Pipeline Value and Value per Lead by Result
- Savings Calculators: Band Each Run by Estimated Saving, Then Count Runs, Report Requests and the Request Rate
- Mobile, Desktop or Tablet? Form Conversion by Device with SUMIFS and a Weak-Spot Highlight
- Testing a Form Change: Relative Uplift, Pooled Rate, z-Score and a Significance Verdict for Six Tests
- Fake, Duplicate and Bot Leads: Flag Duplicates, Mark Usable Leads and Compare the Cost per Submission with the Cost per Usable Lead
- From Lead to Customer: Lead-to-Customer Rate, Cost per Customer, Revenue per Lead and Net Contribution by Lead Tool
- When Do Leads Arrive? Weekday and Time-of-Day Totals, Share of the Week and a Heat Map
- Forecast and Capacity: A Linear Trend for the Next Quarter, Advisers Needed and the Staffing Gap
- What-If: A Profit Grid of Monthly Spend and Cost per Qualified Lead, Break-even CPQL and Counting the Profitable Cells
- Lead Tool Scorecard: Min-Max Scores, a Reversed Cost Score, Weighted Totals with SUMPRODUCT and Ranks
- Final Project: A Lead Programme Dashboard with Cost per Qualified Lead, Cost per Customer, Net Contribution, a Verdict per Tool and a Chart