Tabellab

Email List Building & Segmentation: Sign-Up Sources, Form Conversion, Double Opt-In Loss, List Growth Rate, Engagement Segments, Preference Centres & Sunset Rules

Learn where an email list comes from and how to keep it healthy in 20 hands-on spreadsheet labs. You will calculate form conversion by sign-up source, measure double opt-in loss, net new subscribers against unsubscribes, bounces and complaints, and turn the result into growth and churn rates. Then you compare sources on cost and 90-day engagement, evaluate form tests, build Active, Warm, Cooling and Dormant segments, summarise them with COUNTIF and SUMIFS, analyse preference centre choices and save rates, apply a sunset rule, measure its impact, run a re-permission campaign, cost sign-up incentives, forecast list growth, plan from a goal back to sources, audit a sign-up log for duplicates and missing consent, decide between a segmented send and a blast, build a what-if grid of sign-ups against churn and finish with a quarterly list scorecard. 20 hands-on labs, fictional data from one stationery shop, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the arithmetic behind a healthy email list, one spreadsheet lab at a time. You work with the data of Quillfern Paper Co., a fictional stationery shop, and type every formula yourself while a grader checks each cell. In the first labs you calculate the form conversion rate of each sign-up source, the loss at the double opt-in step, net list growth and the monthly growth and churn rates. You then compare sources on cost and engagement, evaluate form tests, sort subscribers into Active, Warm, Cooling and Dormant segments, read a preference centre export and measure how many people opt down instead of unsubscribing. Later labs apply a sunset rule, estimate its effect, evaluate a re-permission campaign, forecast the list, audit a sign-up log for duplicates and missing consent and build a what-if grid of sign-ups against churn. The final project is a quarterly list scorecard. Functions are explained when first used, from SUM and IF to SUMIFS, XLOOKUP and FORECAST.LINEAR. All companies, people and numbers are fictional.

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

  1. Sign-Up Sources and Form Conversion: Views, Sign-Ups, Conversion Rate per Source and Each Source's Share of the ListLabFree
  2. Double Opt-In Loss: Confirmation Rate, Unconfirmed Sign-Ups per Source and the Weighted Loss of the Whole MonthLab Locked
  3. Net List Growth: New Subscribers Minus Unsubscribes, Bounces and Complaints, a Running List Size and the Replacement RatioLab Locked
  4. List Growth Rate and Churn Rate: Monthly Rates, the Compound Average Growth Rate and a Twelve-Month ProjectionLab Locked
  5. Source Cost and Quality: Cost per Confirmed Subscriber, 90-Day Engaged Rate, Cost per Engaged Subscriber and a RankingLab Locked
  6. Form Conversion Tests: Fewer Fields, Incentives and Timing, Relative Lift over the Control and Extra Sign-Ups per MonthLab Locked
  7. Engagement Segments: Days Since the Last Click or Purchase, Active, Warm, Cooling and Dormant with IFS, and Segment CountsLab Locked
  8. Segment Summary: Subscribers, Revenue and Clicks per Segment with COUNTIF and SUMIFS, Revenue per Subscriber and a Revenue ChartLab Locked
  9. Preference Centres: Topic Choices, Frequency Options, Audience Size per Topic and Emails per Subscriber with XLOOKUPLab Locked
  10. Unsubscribe or Opt Down: Save Rate of the Preference Page, Subscribers Kept, Revenue Retained and a Stacked Chart of ChoicesLab Locked
  11. Sunset Rules: Days Inactive, a Two-Condition Rule with IF and AND, Re-Permission Candidates and the Share of the List AffectedLab Locked
  12. What a Sunset Changes: Volume Removed, Clicks Lost, Click Rate and Complaint Rate Before and After, and Sending Cost SavedLab Locked
  13. Re-Permission Campaigns: Re-Confirmation Rate by Source, Addresses Removed, List Size Afterwards and a Weighted Average with SUMPRODUCTLab Locked
  14. Sign-Up Incentives: Confirmed Subscribers, First Orders, Net Margin after the Incentive and the Best Incentive per Sign-UpLab Locked
  15. Forecasting List Growth: SLOPE as Subscribers per Month, FORECAST.LINEAR for the Next Six Months and Months to a GoalLab Locked
  16. From Goal to Plan: New Subscribers per Source from Views × Conversion × Confirmation, Expected Losses, Net Growth and Months to the GoalLab Locked
  17. List Hygiene at the Door: Duplicate Addresses, Missing Consent Records, Unconfirmed Sign-Ups and the Mailable ListLab Locked
  18. Segmented Send or Blast: Expected Margin, the Cost of Unsubscribes, Net Result per Segment and a Send or Skip DecisionLab Locked
  19. What-If Grid: List Size in Twelve Months for Every Mix of Monthly Sign-Ups and Churn, a Heat Map and the Ceiling of a ListLab Locked
  20. Final Project: A Quarterly List Scorecard with Sign-Ups, Form Conversion, Confirmation Rate, Net Growth, a Target Flag and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy