Tabellab

Content Upgrades vs Generic Forms: Group Totals with SUMIFS, Rate per Offer Type and Lift

Lesson 9 of 20 Lab 🔒 Locked

Lessons in this course

  1. Opt-in Rate by Lead Magnet: Sign-ups per Form View, the Overall Rate and Each Magnet's Share of the ListLabFree
  2. Opt-in Rate by Placement: Landing Page, Pop-up, Inline and Footer Forms Compared with the Site RateLab Locked
  3. Cost per Lead: Production, Promotion and Tool Costs, Spreading One-off Costs and the Blended CPLLab Locked
  4. Lead Quality: Confirmation Rate, Bounces, Early Unsubscribes and the Cost per Net LeadLab Locked
  5. Lead-to-Customer Conversion: Cohorts, the 90-Day Window and Revenue per LeadLab Locked
  6. From Lead to Profit: Cost per Customer, Net Result and ROI of Each MagnetLab Locked
  7. Break-even Cost per Lead: Value per Lead, Repeat Orders and Headroom for PromotionLab Locked
  8. The Magnet Scorecard: Weighted Scores with SUMPRODUCT, Ranks and a Scale, Keep or Retire VerdictLab Locked
  9. Content Upgrades vs Generic Forms: Group Totals with SUMIFS, Rate per Offer Type and LiftLab Locked
  10. From Log to Table: Sign-ups by Magnet and Placement with SUMIFS, Mixed References and COUNTIFSLab Locked
  11. Nurture Sequence Timing: Click Rate per Email, Running Totals and the Day the Orders Are InLab Locked
  12. Days to First Purchase: Date Differences, Blank Dates, a Conversion Window and the MedianLab Locked
  13. Forecasting List Growth: Trend per Week with SLOPE and a Four-Week Forecast with FORECAST.LINEARLab Locked
  14. What-if Grid: Opt-in Rate × Lead-to-Customer Rate, Mixed References and the Loss ZoneLab Locked
  15. A/B Tests of Opt-in Forms: Lift, the z-Score and an Honest VerdictLab Locked
  16. Magnet Fatigue: Monthly Opt-in Rate, Cost per Lead, a 3-Month Moving Average and the Trend over a YearLab Locked
  17. Cleaning the List: Consent, Confirmation, Duplicates and the True Cost per Valid LeadLab Locked
  18. Splitting the Promotion Budget: Profit per Lead, Return per Dollar, Ranks and the Expected Profit of a PlanLab Locked
  19. Payback: Cumulative Profit per Lead, the Payback Month and ROI after Six MonthsLab Locked
  20. Final Project: Quarterly Magnet Scorecard with Opt-in Rate, Cost per Lead, Conversion, ROI, a Flag and a ChartLab Locked