Why a launch starts long before launch day
Many small teams treat a product launch as a single day: the page goes live, the emails go out, the ads switch on and everybody watches the order counter. The teams that handle launches well know that the order counter on launch day mostly shows the work of the previous ten weeks. By the time the doors open, the people who are going to buy in the first hours either know about the product already or they never will, because nobody has the time to persuade a stranger within a few hours.
That is why most launch plans start with a waitlist (also called a pre-launch list or an interest list): a simple page where people leave an email address to be told when the product goes on sale. The list does three jobs at once. It gives you an audience that has agreed to be contacted. It gives you an early reading of demand, long before you must commit to stock. And it gives you a group on which you can test messages, prices and timing before the public sees them.
This free lesson teaches the four numbers every launch team should look at every Monday while the waitlist grows: the sign-up rate, the cumulative waitlist, the share of the waitlist goal reached and the days to launch. Together they answer the question that matters during the pre-launch: are we on track to reach launch day with an audience large enough to meet the revenue goal?
The example: Kestrelby and the Ember kettle
The example in this lesson is Kestrelby, a fictional small company that sells coffee gear online. It will launch a pour-over kettle called the Ember on 16 March 2027. The marketing team opened a waitlist page twelve weeks earlier, on Monday 21 December 2026, and set a goal of 6,000 confirmed sign-ups. Kestrelby, the Ember, all people and all numbers in this lesson and in the lab above are invented for learning. The same twelve weeks are used in the table, the formulas and the figures below.
What a waitlist is, and what it is not
A waitlist is a promise from the visitor, not from you: "tell me when it is available". It is not a pre-order and it is not a sale, and people who join do not owe you a purchase. Treat it as interest with an email address attached. The strength of that interest differs a lot between members: someone who found the page through a friend's invitation and opened every teaser email is a very different prospect from someone who entered a giveaway to win a prize.
- What it gives you: an audience with consent, a first demand signal, a place to test messages and prices, and a launch-day email list that converts far better than cold traffic.
- What it does not give you: a guaranteed number of orders, proof that the price is right, or permission to send anything other than what the sign-up promised.
- What it costs: a landing page, some traffic and an email tool. The real cost is attention: every email you send to the list spends goodwill that cannot be refilled quickly.
Number 1: the sign-up rate
The first number measures the page. The sign-up rate of a week is the number of sign-ups divided by the number of landing-page visitors of the same week: sign-ups ÷ visitors. In Excel, with visitors in column B and sign-ups in column C, the formula for the first week is =C4/B4, copied down.
Kestrelby's rate starts at 12.0% in week 1. It dips slightly in week 2 (11.0%, the week of New Year) and then rises to 18.0% in the final week. Rising rates are normal. Early visitors come from cold sources such as ads aimed at people who have never heard of the brand. Later visitors come from referrals, creator posts and the first teaser emails, and they arrive already interested.
Number 2: the cumulative waitlist
The second number is the size of the list. The cumulative waitlist of a week is all sign-ups up to and including that week, a running total. In Excel it is =SUM($C$4:C4) in row 4, copied down. The dollar signs lock the start of the range at C4, while the end of the range, C4 without dollar signs, moves down by one row each time you copy the formula. In row 10 the formula has become =SUM($C$4:C10): the first seven weeks.
If you forget the dollar signs the start of the range moves down as well, and every row adds only a single week. If you lock both ends, every row shows the final total. Both slips produce plausible numbers, which is why you should always check one row by hand. Kestrelby's cumulative waitlist reaches 2,274 after week 7 (the sum of the first seven weeks: 216 + 182 + 273 + 336 + 293 + 434 + 540) and 6,567 after week 12.
Number 3: the share of the goal
A list size means little without a target. Kestrelby derived its goal of 6,000 from the revenue plan: with the conversion rates of earlier launches, about 6,000 confirmed members are needed to reach the first-week revenue target (lesson 2 of this course shows that backwards calculation). The share of the goal = cumulative waitlist ÷ goal. The goal sits in one cell (G2), so the formula needs an absolute reference: =SUM($C$4:C4)/$G$2, or =E4/$G$2 if the cumulative column is already filled.
Reading the columns: at the end of week 6 Kestrelby is at 28.9% of the goal, and that week started 50 days before launch; at the end of week 9 it is at 56.1%, and that week started 29 days before launch. The share of the goal is only useful together with the time left, which is why the fourth number sits next to it.
Number 4: days to launch
A launch plan is a countdown. Days to launch = launch date − week start. Excel stores a date as a serial number (16 March 2027 is 46462), so dates can be subtracted, and the function DAYS(end_date, start_date) does the same with clearer intent: =DAYS($C$2,A4). The launch date in C2 is locked with dollar signs. Note the order of the arguments: the later date comes first. Reversed, the countdown would be negative.
Kestrelby had 85 days to launch at the start of week 1 and has 8 days left at the start of week 12. Counting in days rather than weeks makes it easy to compare the plan with fixed dates such as a creator's posting day or a delivery date.
A fully worked example: twelve weeks of Kestrelby data
Here are the twelve weeks as they appear in the lab, with the four calculated columns. The totals over the twelve weeks are 43,100 visitors and 6,567 sign-ups.
| Week starting | Visitors | Sign-ups | Sign-up rate | Cumulative waitlist | Share of goal | Days to launch |
|---|---|---|---|---|---|---|
| 21 Dec 2026 | 1,800 | 216 | 12.0% | 216 | 3.6% | 85 |
| 28 Dec 2026 | 1,650 | 182 | 11.0% | 398 | 6.6% | 78 |
| 4 Jan 2027 | 2,100 | 273 | 13.0% | 671 | 11.2% | 71 |
| 11 Jan 2027 | 2,400 | 336 | 14.0% | 1,007 | 16.8% | 64 |
| 18 Jan 2027 | 2,250 | 293 | 13.0% | 1,300 | 21.7% | 57 |
| 25 Jan 2027 | 3,100 | 434 | 14.0% | 1,734 | 28.9% | 50 |
| 1 Feb 2027 | 3,600 | 540 | 15.0% | 2,274 | 37.9% | 43 |
| 8 Feb 2027 | 3,300 | 462 | 14.0% | 2,736 | 45.6% | 36 |
| 15 Feb 2027 | 4,200 | 630 | 15.0% | 3,366 | 56.1% | 29 |
| 22 Feb 2027 | 5,200 | 832 | 16.0% | 4,198 | 70.0% | 22 |
| 1 Mar 2027 | 6,100 | 1,037 | 17.0% | 5,235 | 87.2% | 15 |
| 8 Mar 2027 | 7,400 | 1,332 | 18.0% | 6,567 | 109.5% | 8 |
The formulas behind the calculated columns, written for row 4 and copied down to row 15, are:
- Sign-up rate (D4):
=C4/B4. - Cumulative waitlist (E4):
=SUM($C$4:C4). The start of the range is locked, the end moves. - Share of goal (F4):
=SUM($C$4:C4)/$G$2, or=E4/$G$2. The goal in G2 is locked. - Days to launch (G4):
=DAYS($C$2,A4), or=$C$2-A4. The launch date in C2 is locked.
Walk through one row to see the logic. In the week starting 1 February 2027 Kestrelby had 3,600 visitors and 540 sign-ups, a rate of 15.0%. The list now holds 2,274 members, 37.9% of the goal, and there are 43 days to go. The row alone does not say whether this is good: only the plan for that week, and the weeks still to come, can answer that.
Figure 1 shows why the share of the goal must be read together with the calendar. More than half of the final list arrived in the last four weeks, while the first eight weeks together produced 2,736 sign-ups. A team that judged the plan after week 8, when the list stood at 45.6% of the goal, could have panicked and spent the budget on weak traffic, although the plan was working.
Figure 2 shows the other side of the same story. The rate rises from 12.0% to 18.0%, so the later weeks add sign-ups twice: with more visitors and with a better rate. When both move in the right direction, growth looks like an acceleration. The honest reading is that it comes from traffic of better quality and from referrals, and that it will not necessarily continue after launch.
How to read the result
A good weekly review of the waitlist asks four questions, in this order. Is the page converting? (sign-up rate). Is the list growing as planned? (cumulative waitlist against the plan). How close are we to the target? (share of the goal). How much time is left? (days to launch).
- Compare this week's sign-up rate with the previous weeks. A sudden fall usually has a mundane cause: a broken form, a slow page or a new traffic source with weak intent.
- Compare the cumulative list with the plan for this week, not only with the final goal. Write the weekly plan into the sheet so that the gap is visible.
- Estimate where the list will be on launch day if the last four weeks continue. Use the average weekly sign-ups of recent weeks, not of the whole period.
- Decide what to change: more traffic, a better page, a referral incentive or a lower goal. Change one thing at a time so that you know what worked.
Common mistakes
Most errors in a waitlist sheet come from references and from dividing by the wrong number. These are the ones to look for first.
- Unlocked references.
=E4/G2copied down divides by G3, G4 and so on, which are empty or contain other numbers. The goal must be$G$2. - Wrong running total.
=SUM(C4:C4)copied down adds one week at a time.=SUM($C$4:$C$15)shows the final total in every row. - Upside-down ratios.
=B4/C4is the number of visitors needed for one sign-up, not the sign-up rate. Check that the result is a plausible percentage. - Reversed dates.
=DAYS(A4,$C$2)gives a negative countdown. The later date (launch) comes first. - Counting unconfirmed addresses. If your tool offers confirmation by email, count only confirmed sign-ups. Lesson 3 shows how large the difference can be.
Where the waitlist goal comes from
A goal such as "6,000" should never be chosen because it is a round number. It comes from the revenue plan, divided back through the funnel. Suppose the team wants a first-week revenue of $180,000 at a price of $129. That needs about 1,396 orders. If 8.5% of the list buys, the list must hold about 16,400 members. If only 14% of the visitors sign up, the page needs about 117,000 visitors. Each of these steps is a rate you can measure from earlier launches or from tests with the first few hundred members. Lesson 2 does this calculation for eight markets, and lesson 5 replaces the single waitlist-to-order rate with segment rates.
The reverse calculation also tells you what to do when the sheet shows that the goal is out of reach. You can raise the traffic, improve the sign-up rate, reduce the revenue goal or extend the pre-launch. Only one of these is free, and it is the one that most teams try last: improving the page.
Sign-up quality matters as much as quantity
Not all sign-ups are equal. Some sources bring people who open every email and buy at launch; others bring people who wanted a prize. Two lists of 6,000 can differ by a factor of three in launch-day orders. Kestrelby therefore tracks where each sign-up came from, whether the person confirmed the address and how they reacted to the first teaser. Lessons 3 to 5 turn those observations into confirmation rates, cost per confirmed sign-up and expected buyers per segment.
A simple rule keeps the incentives honest: measure the success of the pre-launch by confirmed sign-ups from sources that have already shown purchase intent, not by raw sign-ups. A giveaway that adds 2,000 addresses may be worth running for brand reach, but it should not be counted as 2,000 buyers.
Try it yourself in the lab
The lab above this article contains the same twelve weeks. You enter the four formulas yourself, and the Coach checks one cell of each column, so you know immediately whether the references behave. Try changing the waitlist goal in G2 or the launch date in C2 after you finish: the whole column must follow. If any cell does not, a reference is not locked correctly.
As a second exercise, add a column with the sign-ups needed per remaining week to reach the goal: =MAX(0, $G$2-E4)/(G4/7) turns the gap into a weekly target, and shows how steeply the pace must rise when the early weeks were slow.
What the rest of the course covers
The waitlist is the first of five stages. Figure 3 shows the workflow, and the remaining 19 labs follow this order. The list below groups them by lesson number.
- Waitlist and pre-launch (lessons 1 to 5): working backwards from the goal, quality by source, a referral loop with the k-factor, and the forecast of how many members will buy.
- Launch-day forecasts and the calendar (lessons 6 to 8): sessions and orders per channel, the hourly curve with the early-bird stock, and a launch calendar with working-day deadlines.
- Pricing and pace (lessons 9 and 10): early-bird tiers, discounts, unit margin after fees, the blended selling price and the sell-out day with SLOPE and FORECAST.LINEAR.
- Operations and risk (lessons 11 to 16): the email sequence, the allowable cost per order, scenarios, a sensitivity grid, the order log with returns and stock cover.
- Review (lessons 17 to 20): plan against actual, the decay of orders after the spike, forecast accuracy and bias, and a final launch scorecard.
Lesson 1 is free. The full course contains 20 labs, a 20-question exam and a certificate for learners who pass with 75 per cent. Every lab uses a different, fictional data set from Kestrelby, so you practise on realistic tables without risking real money.
Frequently asked questions
What is a product launch waitlist?
A waitlist is a page where people leave an email address to be told when a product goes on sale. It collects an audience with consent, gives an early reading of demand and lets you test messages and prices before launch. It is a statement of interest, not a pre-order.
How do I calculate a sign-up rate?
Divide the number of sign-ups by the number of landing-page visitors of the same period. In a spreadsheet, with visitors in B4 and sign-ups in C4, the formula is =C4/B4. Always use the same period for both numbers.
How do I build a running total of sign-ups in Excel?
Use =SUM($C$4:C4) in the first row and copy it down. The dollar signs lock the start of the range at C4, and the end of the range moves down with every row, so each row adds all weeks up to its own.
Why do I need an absolute reference for the waitlist goal?
The goal is one cell, for example G2. When you copy a formula down, a relative reference moves to G3, G4 and so on. Writing $G$2 keeps the reference on the goal cell in every row.
How many days are left until launch, and how do I count them in Excel?
Subtract the week start from the launch date, or use =DAYS(launch_date, week_start). Excel stores dates as serial numbers, so the difference is the number of days. The later date must come first in the DAYS function.
Is a bigger waitlist always better?
No. Quality matters as much as size. Sign-ups from giveaways often confirm and buy far less than sign-ups from referrals or creators. Count confirmed addresses, track the source of every sign-up and estimate expected buyers per segment before you compare lists.
Keep going: Product Launch & Go-To-Market Planning: Waitlists, Launch-Day Forecasts, Channel Calendars, Early-Bird Pricing & Post-Launch Review
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.
- Working Backwards from the Launch Goal: Orders Needed, Waitlist Needed, Visitors Needed and the Weekly Traffic Target
- Waitlist Quality by Source: Confirmation Rate, Cost per Confirmed Sign-Up, Share of the List and Ranking
- The Referral Waitlist: Invites per Member, Invite Conversion, the k-Factor and the Projected List
- From Waitlist to Orders: Segment Rates, Expected Buyers, Expected Revenue and the Blended Conversion
- The Launch-Day Traffic Forecast: Sessions per Channel, Orders, Channel Mix and the Blended Conversion Rate
- The Launch-Day Curve: Hourly Sessions, Hourly Orders, Cumulative Orders and When the Early-Bird Stock Runs Out
- The Channel Launch Calendar: Go-Live Dates from Day Offsets, Production Starts with WORKDAY, Phases and Workload per Phase
- Launch Pricing: Early-Bird Tiers, Discount against List Price, Unit Margin after Fees and the Blended Selling Price
- Pre-Order Pace: Share of the Early-Bird Cap, the Daily Trend with SLOPE, a FORECAST.LINEAR Projection and the Sell-Out Day
- The Launch Email Sequence: Opens, Clicks, Unsubscribes, the Cumulative List Loss and Clicks per Send
- Allowable Cost per Order: Break-Even CPA, Margin after Ads, Over-Limit Channels and Conditional Formatting
- Launch Scenarios: Pessimistic to Viral, Orders, Revenue, Probability-Weighted Revenue and a Scenario Chart
- Launch Sensitivity Grid: Sessions against Conversion, Profit per Cell, Break-Even Conversion and Loss Zone Formatting
- The Launch Order Log: Orders, Revenue and Average Order by Channel, Revenue Share and Return Rate by Tier
- Stock Cover for the Launch: Units Available, Base-Case Shortfall, Cover Status, Top-Up Orders in Pack Sizes and a Chart
- Plan against Actual: Actual Conversion, Planned Orders, Order Variance, a Status Flag with a Tolerance Band and Row Formatting
- After the Spike: Weekly Orders, Week-on-Week Ratio, Cumulative Orders, the Decay Rate and a Tail Forecast with a Chart
- How Good Were the Forecasts? Absolute Percentage Error, Hit or Miss, MAPE, Bias and a Bias-Adjusted Forecast
- Final Project, the Launch Scorecard: Conversion, Net Revenue after Returns, Net ROAS per Channel, Blended ROAS, Top Channel and a Chart