Tabellab

Lead Magnets & Content Upgrades: Opt-in Rates by Magnet and Placement, Cost per Lead, Lead-to-Customer Conversion, Nurture Timing & Magnet Scorecards

Find out which free downloads actually build a list that buys, in 20 hands-on spreadsheet labs. You will calculate opt-in rates by magnet and by form placement, spread production costs into a fair cost per lead, clean sign-ups down to confirmed net leads, follow cohorts to their first order and work out acquisition cost, ROI and the break-even cost per lead. Then you score magnets on a weighted scorecard, compare content upgrades with generic forms, summarise a sign-up log by magnet and placement, time a welcome sequence, measure days to first purchase, forecast list growth, build a what-if grid, read A/B tests of forms, spot magnet fatigue, clean a list, split a promotion budget and find payback months, and finish with a quarterly magnet dashboard. 20 hands-on labs, fictional planner 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 numbers behind lead magnets and content upgrades in 20 interactive spreadsheet labs. You work as the analyst of Mossgate Planners, a fictional online shop for paper planners and digital templates, and type every formula yourself while a grader checks each cell. You start with opt-in rates by magnet and by form placement, build a fair cost per lead that includes production and tools, reduce sign-ups to confirmed net leads and follow cohorts to their first order. From there you calculate cost per customer, ROI and the break-even cost per lead, score magnets on a weighted scorecard, compare content upgrades with generic forms, time a welcome sequence, measure days to first purchase, forecast list growth, read A/B tests of forms, detect magnet fatigue, clean a list, split a promotion budget and find payback months. The final project is a quarterly magnet scorecard with a chart. All companies, people and numbers are fictional, and benchmarks are illustrative.

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. 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

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