Tabellab

Copywriting by the Numbers: Headline Formulas & Length, Readability Scores, CTA Variants, Message Match & Split-Test Reading

Measure copy instead of arguing about it in 20 hands-on labs. You will check headline and subject line length against limits, tag headlines by formula and compare their pooled click-through rate, calculate Flesch readability scores and reading grades before and after a rewrite, compare CTA button texts by click rate and by revenue per view, score message match between ads and landing pages and show what weak match costs per order, read copy split tests with a minimum-data rule and a z-score, plan how many visitors and days a test needs, put a yearly value on a winning headline, score a swipe file with weighted criteria, build a what-if grid for subject line against body copy, run a pre-flight check on ad copy, rank a backlog of test ideas and finish with a copy testing scorecard. 20 hands-on labs, fictional stationery shop Quillhaven Paper Co., 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 treats copywriting as something you can count. In 20 interactive spreadsheet labs you work for Quillhaven Paper Co., a fictional online stationery shop, and check its headlines, subject lines, buttons and landing pages with formulas. You measure length against limits with LEN, tag headlines by formula and compare their click-through rates, calculate Flesch readability scores and reading grades before and after a rewrite, compare CTA button texts by click rate and by revenue per view, score how well a landing page repeats the promise of its ad, and read split tests with a minimum-data rule and a z-score. Later labs plan how long a test must run, put a yearly value on a winning headline, score a swipe file, build a what-if grid, run a pre-flight check on ad copy and rank a backlog of test ideas, before a final copy testing scorecard brings the skills together. Every formula is explained when it first appears. All companies, campaigns and numbers are fictional.

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. Headline Length by the Numbers: Characters with LEN, Word Counts, a Fit Check Against a Limit and a Summary of the DraftsLabFree
  2. Headline Formulas: Tagging Headlines by Type, Pooled Click-Through Rate per Formula with SUMIFS and an Index Against the AverageLab Locked
  3. Readability Scores: Words per Sentence, Syllables per Word, the Flesch Reading Ease with ROUND and a Plain-English VerdictLab Locked
  4. CTA Variants: Click Rate per Button Text, Relative Lift Against the Control, a Ranking with RANK.EQ and the Best Button with INDEX and MATCHLab Locked
  5. Message-Match Scores: Scoring Ad and Landing Page on Four Criteria, a Percentage Score, Labels with IFS and Bounce Rate per LabelLab Locked
  6. Reading a Copy Split Test: Conversion Rate per Version, Relative Lift, a Minimum-Data Rule with MIN and a Side-by-Side ChartLab Locked
  7. Swipe-File Scoring: Weighted Scores with SUMPRODUCT, a Ranking, a Keep-or-Archive Rule and a Row HighlightLab Locked
  8. Subject Line Length and Open Rate: Length Bands with IFS, Sends per Band and the Pooled Open Rate with SUMIFSLab Locked
  9. Headline Ingredients: Finding Words with SEARCH and ISNUMBER, Splitting Headlines into Two Groups and Comparing Their Pooled CTRLab Locked
  10. Measuring a Rewrite: Flesch-Kincaid Grade Before and After, the Change per Page, a Target Check and a Before-and-After ChartLab Locked
  11. CTA Variants Beyond the Click: Click Rate Against Revenue per View and Two Different Winners with INDEX and MATCHLab Locked
  12. What Weak Message Match Costs: Bands from the Match Score, Pooled Order Rate and Cost per Order per BandLab Locked
  13. Is the Lift Real? Pooled Rate, Standard Error with SQRT, the z-Score of a Copy Test and a 95% VerdictLab Locked
  14. Planning a Headline Test: Smallest Lift Worth Finding, Visitors per Version with ROUNDUP, Days Needed and a Run-or-Rethink DecisionLab Locked
  15. Headline Length and Click-Through Rate: Correlation with CORREL, a Trend Line with SLOPE, R² and a Forecast with FORECAST.LINEARLab Locked
  16. What a Winning Headline Is Worth: Extra Orders, Extra Revenue, a Haircut on the Lift and a 12-Month Value per TestLab Locked
  17. Subject Line or Body Copy? A What-If Grid of Revenue per Send with Mixed References, a Heat Map and a Target CountLab Locked
  18. Copy Quality Checks Before Upload: Character Limits with LEN, Counting Exclamation Marks, an OR Rule and Duplicate HeadlinesLab Locked
  19. Prioritising Copy Tests: Expected Extra Orders, Expected Value per Hour, a Ranking and the Hours of the Top IdeasLab Locked
  20. Final Project: The Copy Testing Scorecard with Lift, z-Score, Winner-Loser Verdicts, Wins per Asset Type, a Row Highlight 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