Tabellab

The Pre-Launch Waitlist: Sign-Up Rate, Cumulative Waitlist, Share of the Goal and Days to Launch

Lesson 1 of 20Lab

All lessons
  1. The Pre-Launch Waitlist: Sign-Up Rate, Cumulative Waitlist, Share of the Goal and Days to LaunchLabFree
  2. Working Backwards from the Launch Goal: Orders Needed, Waitlist Needed, Visitors Needed and the Weekly Traffic TargetLab Locked
  3. Waitlist Quality by Source: Confirmation Rate, Cost per Confirmed Sign-Up, Share of the List and RankingLab Locked
  4. The Referral Waitlist: Invites per Member, Invite Conversion, the k-Factor and the Projected ListLab Locked
  5. From Waitlist to Orders: Segment Rates, Expected Buyers, Expected Revenue and the Blended ConversionLab Locked
  6. The Launch-Day Traffic Forecast: Sessions per Channel, Orders, Channel Mix and the Blended Conversion RateLab Locked
  7. The Launch-Day Curve: Hourly Sessions, Hourly Orders, Cumulative Orders and When the Early-Bird Stock Runs OutLab Locked
  8. The Channel Launch Calendar: Go-Live Dates from Day Offsets, Production Starts with WORKDAY, Phases and Workload per PhaseLab Locked
  9. Launch Pricing: Early-Bird Tiers, Discount against List Price, Unit Margin after Fees and the Blended Selling PriceLab Locked
  10. Pre-Order Pace: Share of the Early-Bird Cap, the Daily Trend with SLOPE, a FORECAST.LINEAR Projection and the Sell-Out DayLab Locked
  11. The Launch Email Sequence: Opens, Clicks, Unsubscribes, the Cumulative List Loss and Clicks per SendLab Locked
  12. Allowable Cost per Order: Break-Even CPA, Margin after Ads, Over-Limit Channels and Conditional FormattingLab Locked
  13. Launch Scenarios: Pessimistic to Viral, Orders, Revenue, Probability-Weighted Revenue and a Scenario ChartLab Locked
  14. Launch Sensitivity Grid: Sessions against Conversion, Profit per Cell, Break-Even Conversion and Loss Zone FormattingLab Locked
  15. The Launch Order Log: Orders, Revenue and Average Order by Channel, Revenue Share and Return Rate by TierLab Locked
  16. Stock Cover for the Launch: Units Available, Base-Case Shortfall, Cover Status, Top-Up Orders in Pack Sizes and a ChartLab Locked
  17. Plan against Actual: Actual Conversion, Planned Orders, Order Variance, a Status Flag with a Tolerance Band and Row FormattingLab Locked
  18. After the Spike: Weekly Orders, Week-on-Week Ratio, Cumulative Orders, the Decay Rate and a Tail Forecast with a ChartLab Locked
  19. How Good Were the Forecasts? Absolute Percentage Error, Hit or Miss, MAPE, Bias and a Bias-Adjusted ForecastLab Locked
  20. Final Project, the Launch Scorecard: Conversion, Net Revenue after Returns, Net ROAS per Channel, Blended ROAS, Top Channel and a ChartLab Locked

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 20 is free. Unlock all 20 hands-on labs, the final exam and your certificate.

Buy course — $9.90
Loading the spreadsheet…

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.

All companies, products and figures in this course are fictional. Benchmarks and rates are illustrative planning assumptions, not statistics about real markets or platforms. Use your own data wherever you have it.

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.
Consent first. Collect addresses only with clear wording about what people will receive, send only to people who signed up themselves, make unsubscribing a one-click action and honour it at once. Never buy lists and never add addresses without the person's own sign-up. Most email tools can send a confirmation message (double opt-in) so that every address on the list is real.

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.

Always divide by the visitors of the same week. A common slip is to divide this week's sign-ups by the total visitors so far, which gives a number that shrinks and tells you nothing about the page.

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 startingVisitorsSign-upsSign-up rateCumulative waitlistShare of goalDays to launch
21 Dec 20261,80021612.0%2163.6%85
28 Dec 20261,65018211.0%3986.6%78
4 Jan 20272,10027313.0%67111.2%71
11 Jan 20272,40033614.0%1,00716.8%64
18 Jan 20272,25029313.0%1,30021.7%57
25 Jan 20273,10043414.0%1,73428.9%50
1 Feb 20273,60054015.0%2,27437.9%43
8 Feb 20273,30046214.0%2,73645.6%36
15 Feb 20274,20063015.0%3,36656.1%29
22 Feb 20275,20083216.0%4,19870.0%22
1 Mar 20276,1001,03717.0%5,23587.2%15
8 Mar 20277,4001,33218.0%6,567109.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.

Cumulative waitlist against the goal of 6,00001,0002,0003,0004,0005,0006,0007,00021621 Dec39828 Dec6714 Jan1,00711 Jan1,30018 Jan1,73425 Jan2,2741 Feb2,7368 Feb3,36615 Feb4,19822 Feb5,2351 Mar6,5678 MarGoal 6,000Week starting (Monday), Dec 2026 to Mar 2027 (fictional data)
Figure 1. Cumulative waitlist at the end of each week. Only the last bar (green) reaches the goal of 6,000 sign-ups.

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.

Sign-up rate by week (sign-ups ÷ visitors)8%10%12%14%16%18%20%12.0%W111.0%W213.0%W314.0%W413.0%W514.0%W615.0%W714.0%W815.0%W916.0%W1017.0%W1118.0%W12Week of the pre-launch (fictional data)
Figure 2. The sign-up rate of each week. Later visitors come from warmer sources and sign up more often.

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).

  1. 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.
  2. 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.
  3. 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.
  4. 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/G2 copied 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/C4 is 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.
After you copy a formula down, press F2 (or double-click) on the last row and look at it. If you can read the pattern of the references in the first and in the last row, the middle rows are almost certainly right.

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.

The launch workflow in this course1 Waitlistsign-ups, sources,referrals, goal2 Forecasttraffic, orders,hourly curve3 Calendardates, emails,channel budgets4 Pricingearly-bird tiers,margin, stock5 Reviewplan vs actual,accuracy, scorecardEach stage ends with numbers the next stage needs
Figure 3. The five stages of a launch plan, each practised in several labs.

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.

Platform names, rates and prices change often. The course teaches arithmetic that stays valid when the numbers change: ratios, running totals, absolute references, lookups, scenarios and variance. Replace the example numbers with your own before you make decisions.

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.

  1. Working Backwards from the Launch Goal: Orders Needed, Waitlist Needed, Visitors Needed and the Weekly Traffic Target
  2. Waitlist Quality by Source: Confirmation Rate, Cost per Confirmed Sign-Up, Share of the List and Ranking
  3. The Referral Waitlist: Invites per Member, Invite Conversion, the k-Factor and the Projected List
  4. From Waitlist to Orders: Segment Rates, Expected Buyers, Expected Revenue and the Blended Conversion
  5. The Launch-Day Traffic Forecast: Sessions per Channel, Orders, Channel Mix and the Blended Conversion Rate
  6. The Launch-Day Curve: Hourly Sessions, Hourly Orders, Cumulative Orders and When the Early-Bird Stock Runs Out
  7. The Channel Launch Calendar: Go-Live Dates from Day Offsets, Production Starts with WORKDAY, Phases and Workload per Phase
  8. Launch Pricing: Early-Bird Tiers, Discount against List Price, Unit Margin after Fees and the Blended Selling Price
  9. Pre-Order Pace: Share of the Early-Bird Cap, the Daily Trend with SLOPE, a FORECAST.LINEAR Projection and the Sell-Out Day
  10. The Launch Email Sequence: Opens, Clicks, Unsubscribes, the Cumulative List Loss and Clicks per Send
  11. Allowable Cost per Order: Break-Even CPA, Margin after Ads, Over-Limit Channels and Conditional Formatting
  12. Launch Scenarios: Pessimistic to Viral, Orders, Revenue, Probability-Weighted Revenue and a Scenario Chart
  13. Launch Sensitivity Grid: Sessions against Conversion, Profit per Cell, Break-Even Conversion and Loss Zone Formatting
  14. The Launch Order Log: Orders, Revenue and Average Order by Channel, Revenue Share and Return Rate by Tier
  15. Stock Cover for the Launch: Units Available, Base-Case Shortfall, Cover Status, Top-Up Orders in Pack Sizes and a Chart
  16. Plan against Actual: Actual Conversion, Planned Orders, Order Variance, a Status Flag with a Tolerance Band and Row Formatting
  17. After the Spike: Weekly Orders, Week-on-Week Ratio, Cumulative Orders, the Decay Rate and a Tail Forecast with a Chart
  18. How Good Were the Forecasts? Absolute Percentage Error, Hit or Miss, MAPE, Bias and a Bias-Adjusted Forecast
  19. Final Project, the Launch Scorecard: Conversion, Net Revenue after Returns, Net ROAS per Channel, Blended ROAS, Top Channel and a Chart

Buy course — $9.90 See the full course