Sunset Rules: Days Inactive, a Two-Condition Rule with IF and AND, Re-Permission Candidates and the Share of the List Affected
Lessons in this course
- 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