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.
- 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
- Sign-Up Sources and Form Conversion: Views, Sign-Ups, Conversion Rate per Source and Each Source's Share of the ListFree
- Double Opt-In Loss: Confirmation Rate, Unconfirmed Sign-Ups per Source and the Weighted Loss of the Whole Month Locked
- Net List Growth: New Subscribers Minus Unsubscribes, Bounces and Complaints, a Running List Size and the Replacement Ratio Locked
- List Growth Rate and Churn Rate: Monthly Rates, the Compound Average Growth Rate and a Twelve-Month Projection Locked
- Source Cost and Quality: Cost per Confirmed Subscriber, 90-Day Engaged Rate, Cost per Engaged Subscriber and a Ranking Locked
- Form Conversion Tests: Fewer Fields, Incentives and Timing, Relative Lift over the Control and Extra Sign-Ups per Month Locked
- Engagement Segments: Days Since the Last Click or Purchase, Active, Warm, Cooling and Dormant with IFS, and Segment Counts Locked
- Segment Summary: Subscribers, Revenue and Clicks per Segment with COUNTIF and SUMIFS, Revenue per Subscriber and a Revenue Chart Locked
- Preference Centres: Topic Choices, Frequency Options, Audience Size per Topic and Emails per Subscriber with XLOOKUP Locked
- Unsubscribe or Opt Down: Save Rate of the Preference Page, Subscribers Kept, Revenue Retained and a Stacked Chart of Choices Locked
- Sunset Rules: Days Inactive, a Two-Condition Rule with IF and AND, Re-Permission Candidates and the Share of the List Affected Locked
- What a Sunset Changes: Volume Removed, Clicks Lost, Click Rate and Complaint Rate Before and After, and Sending Cost Saved Locked
- Re-Permission Campaigns: Re-Confirmation Rate by Source, Addresses Removed, List Size Afterwards and a Weighted Average with SUMPRODUCT Locked
- Sign-Up Incentives: Confirmed Subscribers, First Orders, Net Margin after the Incentive and the Best Incentive per Sign-Up Locked
- Forecasting List Growth: SLOPE as Subscribers per Month, FORECAST.LINEAR for the Next Six Months and Months to a Goal Locked
- From Goal to Plan: New Subscribers per Source from Views × Conversion × Confirmation, Expected Losses, Net Growth and Months to the Goal Locked
- List Hygiene at the Door: Duplicate Addresses, Missing Consent Records, Unconfirmed Sign-Ups and the Mailable List Locked
- Segmented Send or Blast: Expected Margin, the Cost of Unsubscribes, Net Result per Segment and a Send or Skip Decision Locked
- 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 List Locked
- Final Project: A Quarterly List Scorecard with Sign-Ups, Form Conversion, Confirmation Rate, Net Growth, a Target Flag and a Combo Chart Locked
Learner reviews
Be the first to review this course.