Short-Form Hook & Retention Lab
One spreadsheet: rate a short-form hook against a weighted rubric for a Ship / Tighten / Rework verdict, then log 3-second retention against your own baseline — and it flags thin samples instead of crowning a winner on a few hundred views.
TL;DR
Two tools in one .xlsx: a Hook Scorer that returns SHIP / TIGHTEN / REWORK before you post (with an anti-clickbait cap), and a Retention Log that reads 3-second retention against your baseline and refuses to crown a winner under 1,000 views.
instant download · .xlsx · yours to keep
The problem
You find out the hook was weak after the views don't come.
By the time the analytics are in, the footage is spent. And the early “winner” you crowned on a small sample often wasn't one. Both problems are cheaper to catch before and during, not after.
How long a hook has to stop the scroll. Most are scored only after the views don't come.
How long a small-sample 'winner' fools you before the numbers regress.
A great hook to a video that doesn't deliver is a retention trap, not a win.
What's inside
Two tools, one spreadsheet.
Try them live — this is the actual logic from the workbook.
Hook Scorer
Score each 0–5. Weights sum to 100.
Stops the scroll in 1 second
weight 25
Opens a curiosity gap or stakes
weight 20
Specific, not vague
weight 15
Promise matches the payoff
weight 20
Spoken + on-screen reinforce
weight 10
Tight — no wasted words
weight 10
Strong hook. Post it.
Retention check (after posting)
3-second retention vs your own baseline.
No winner is called under 1,000 views.
Your channel's own typical 3s retention.
Losing viewers faster than your norm. The first 3 seconds need work.
Move the scores and the numbers to see verdicts update. Same math as the workbook. Reference 2026-06-18. Resets on reload.
This is the live engine. The full YouTube Packaging & Retention Engine adds a two-proportion significance test — it tells you when an A/B result is statistically real, not just a bump. And it diagnoses CTR × retention together across your whole channel: packaging problem vs content problem.
Get the kit — $69The standard
Three rules it holds to.
Score before you post
A rubric you apply in 30 seconds beats posting and hoping. Fix the weak criteria while it's still cheap to fix.
Your baseline, not a benchmark
Retention is judged against your own typical 3-second hold — a number you enter — not a generic figure that doesn't fit your audience.
No winner on a thin sample
Under 1,000 views, the Lab flags THIN SAMPLE instead of declaring a result. Chasing small-sample noise is how creators pick the wrong hook.
How it works
Four steps, start to signal.
Score the hook
Rate six criteria 0–5 in the blue cells. The weighted total and SHIP / TIGHTEN / REWORK verdict compute live.
Fix or post
TIGHTEN? Fix the lowest rows and re-score. SHIP? Post it. REWORK? Rebuild before you shoot.
Log retention
After posting, enter views, the count still watching at 3 seconds, and your baseline.
Read the result
BEATS / AT / BELOW your baseline — or THIN SAMPLE if it's too early to call. Keep the winners, retire the rest.
What you'll see
The worked example, at a glance.
The Lab ships pre-filled with this example — every retention state represented, so you can see how it reads before you enter your own.
- Hook score: 81.0 / 100 → SHIP
- Hook A (number open): 69.0% at 3s → BEATS BASELINE
- Hook B (question open): 60.0% at 3s → AT BASELINE
- Hook C (slow open): 42.8% at 3s → BELOW BASELINE
- Hook D (new test, 420 views): → THIN SAMPLE — keep running
Who it's for
Clear about the lane. No inflated promises.
Built for you if…
- Short-form creators (Reels, TikTok, Shorts) who want a hook checked before posting
- Anyone tired of guessing why a video didn't take
- Creators running hook A/Bs who keep crowning winners too early
Not for you if…
- Teams needing statistical A/B significance across a channel — that's the YouTube Packaging & Retention Engine
- Long-form-only channels where the first 3 seconds aren't the battle
Pairs well with
Start here, step up when you're testing seriously.
YouTube Packaging & Retention Engine
The step up: a two-proportion significance test and CTR × retention diagnosis across your whole channel.
Organic Social & Short-Form Video System
The creation system — content pillars, a hook engine, and a cadence you can actually keep.
Content Engine for One Person
One spreadsheet to plan, schedule, and repurpose a week of platform-native posts.
Common Questions
The questions creators actually ask before scoring a hook.
Get the Lab
Check the hook while it's still cheap to fix.
Instant download, yours to keep, with 12 months of updates. Score it, post it, log it — and never crown a winner on a thin sample again.
- One .xlsx: Start Here, Dashboard, Hook & Retention Lab
- Weighted hook rubric (Ship / Tighten / Rework) with an anti-clickbait cap
- 3-second retention log vs your own baseline · thin-sample flag
- Works in Excel, Google Sheets, or Numbers · no subscription