Tabellab

Headline Length and Click-Through Rate: Correlation with CORREL, a Trend Line with SLOPE, R² and a Forecast with FORECAST.LINEAR

Lesson 15 of 20 Lab 🔒 Locked

Lessons in this course

  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