Copy Quality Checks Before Upload: Character Limits with LEN, Counting Exclamation Marks, an OR Rule and Duplicate Headlines
Lessons in this course
- 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