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.
- 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
- Headline Length by the Numbers: Characters with LEN, Word Counts, a Fit Check Against a Limit and a Summary of the DraftsFree
- Headline Formulas: Tagging Headlines by Type, Pooled Click-Through Rate per Formula with SUMIFS and an Index Against the Average Locked
- Readability Scores: Words per Sentence, Syllables per Word, the Flesch Reading Ease with ROUND and a Plain-English Verdict Locked
- CTA Variants: Click Rate per Button Text, Relative Lift Against the Control, a Ranking with RANK.EQ and the Best Button with INDEX and MATCH Locked
- Message-Match Scores: Scoring Ad and Landing Page on Four Criteria, a Percentage Score, Labels with IFS and Bounce Rate per Label Locked
- Reading a Copy Split Test: Conversion Rate per Version, Relative Lift, a Minimum-Data Rule with MIN and a Side-by-Side Chart Locked
- Swipe-File Scoring: Weighted Scores with SUMPRODUCT, a Ranking, a Keep-or-Archive Rule and a Row Highlight Locked
- Subject Line Length and Open Rate: Length Bands with IFS, Sends per Band and the Pooled Open Rate with SUMIFS Locked
- Headline Ingredients: Finding Words with SEARCH and ISNUMBER, Splitting Headlines into Two Groups and Comparing Their Pooled CTR Locked
- Measuring a Rewrite: Flesch-Kincaid Grade Before and After, the Change per Page, a Target Check and a Before-and-After Chart Locked
- CTA Variants Beyond the Click: Click Rate Against Revenue per View and Two Different Winners with INDEX and MATCH Locked
- What Weak Message Match Costs: Bands from the Match Score, Pooled Order Rate and Cost per Order per Band Locked
- Is the Lift Real? Pooled Rate, Standard Error with SQRT, the z-Score of a Copy Test and a 95% Verdict Locked
- Planning a Headline Test: Smallest Lift Worth Finding, Visitors per Version with ROUNDUP, Days Needed and a Run-or-Rethink Decision Locked
- Headline Length and Click-Through Rate: Correlation with CORREL, a Trend Line with SLOPE, R² and a Forecast with FORECAST.LINEAR Locked
- What a Winning Headline Is Worth: Extra Orders, Extra Revenue, a Haircut on the Lift and a 12-Month Value per Test Locked
- Subject Line or Body Copy? A What-If Grid of Revenue per Send with Mixed References, a Heat Map and a Target Count Locked
- Copy Quality Checks Before Upload: Character Limits with LEN, Counting Exclamation Marks, an OR Rule and Duplicate Headlines Locked
- Prioritising Copy Tests: Expected Extra Orders, Expected Value per Hour, a Ranking and the Hours of the Top Ideas Locked
- Final Project: The Copy Testing Scorecard with Lift, z-Score, Winner-Loser Verdicts, Wins per Asset Type, a Row Highlight and a Chart Locked
Learner reviews
Be the first to review this course.