Tabellab

Unsubscribe or Opt Down: Save Rate of the Preference Page, Subscribers Kept, Revenue Retained and a Stacked Chart of Choices

Lesson 10 of 20 Lab 🔒 Locked

Lessons in this course

  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