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.
- 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
- Opt-in Rate by Lead Magnet: Sign-ups per Form View, the Overall Rate and Each Magnet's Share of the ListFree
- Opt-in Rate by Placement: Landing Page, Pop-up, Inline and Footer Forms Compared with the Site Rate Locked
- Cost per Lead: Production, Promotion and Tool Costs, Spreading One-off Costs and the Blended CPL Locked
- Lead Quality: Confirmation Rate, Bounces, Early Unsubscribes and the Cost per Net Lead Locked
- Lead-to-Customer Conversion: Cohorts, the 90-Day Window and Revenue per Lead Locked
- From Lead to Profit: Cost per Customer, Net Result and ROI of Each Magnet Locked
- Break-even Cost per Lead: Value per Lead, Repeat Orders and Headroom for Promotion Locked
- The Magnet Scorecard: Weighted Scores with SUMPRODUCT, Ranks and a Scale, Keep or Retire Verdict Locked
- Content Upgrades vs Generic Forms: Group Totals with SUMIFS, Rate per Offer Type and Lift Locked
- From Log to Table: Sign-ups by Magnet and Placement with SUMIFS, Mixed References and COUNTIFS Locked
- Nurture Sequence Timing: Click Rate per Email, Running Totals and the Day the Orders Are In Locked
- Days to First Purchase: Date Differences, Blank Dates, a Conversion Window and the Median Locked
- Forecasting List Growth: Trend per Week with SLOPE and a Four-Week Forecast with FORECAST.LINEAR Locked
- What-if Grid: Opt-in Rate × Lead-to-Customer Rate, Mixed References and the Loss Zone Locked
- A/B Tests of Opt-in Forms: Lift, the z-Score and an Honest Verdict Locked
- Magnet Fatigue: Monthly Opt-in Rate, Cost per Lead, a 3-Month Moving Average and the Trend over a Year Locked
- Cleaning the List: Consent, Confirmation, Duplicates and the True Cost per Valid Lead Locked
- Splitting the Promotion Budget: Profit per Lead, Return per Dollar, Ranks and the Expected Profit of a Plan Locked
- Payback: Cumulative Profit per Lead, the Payback Month and ROI after Six Months Locked
- Final Project: Quarterly Magnet Scorecard with Opt-in Rate, Cost per Lead, Conversion, ROI, a Flag and a Chart Locked
Learner reviews
Be the first to review this course.