Free editable template

Hook rate and hold rate scorer for Meta video ads

Know which half of each video to fix. Hook rate shows whether people stopped scrolling; hold rate shows whether the ones who stopped stayed to 15 seconds. The scorer plots every video on both, grades it, flags short videos and ads with too few impressions, and gives a fix playbook for each box.

By GaaS editorial · Sources checked · 10 worksheet rows

Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.

How to use the template

Export from Ads Manager

Ads tab, a date range of 7 days or more, columns Impressions, 3-second video plays, ThruPlays, Amount spent and Purchases (Customize columns > Video engagement). Export at ad level.

Paste into the Ads tab

Ad name, video length (optional), impressions, 3-second plays, ThruPlays, spend and purchases from row 5. Hook rate, hold rate, score, grade, action and cost per purchase fill in.

Set your bars

The defaults are 30% hook and 25% hold: our starting points, not Meta benchmarks. Once you have 20+ graded videos, use the medians on the Summary tab instead.

Brief one fix per ad

The Fix playbook tab lists what to change for each action. Change one half of the video per new version, then re-run the scorer a week later.

Preview the worksheet

Every row shown here is included in the download. Scroll the table horizontally on a small screen.

RuleConditionDefault
Hook rate3-second video plays ÷ impressionsBar: 30% (ours)
Hold rateThruPlays ÷ 3-second playsBar: 25% (ours)
Score0.5 × hook ÷ hook bar + 0.5 × hold ÷ hold bar1.00 = on both bars
GradeScore cut-offsA 1.15+, B 0.95+, C 0.75+, D 0.55+, F below
Scale itHook and hold at or above both bars30% and 25%
Fix the hookHook below its bar, hold at or above
Fix the middleHook at or above its bar, hold below
Kill itBoth below their bars
Too earlyImpressions below the minimum5,000
Short videoVideo shorter than 15 seconds15 s

Worked review example

Fictional skincare brand, 8 video ads over 14 days: Founder unboxing (41% hook, 33% hold, A) and Customer selfie review (33%, 27%, B) go to Scale it; Slow product pan and Before/after split need a new hook; Street interview (45%, 18%) and Shock-stat open (38%, 12%) need a new middle; Studio demo and Logo intro (14%, 9%, F) are killed.

Street interview grades B on its huge hook, but the box says Fix the middle: keep the opening, change seconds 3 to 15.

What this template does and does not establish

Hook rate and hold rate are marketer conventions built from Meta's columns, not Meta metrics; some people divide ThruPlays by impressions instead. The bars and grade cut-offs are ours; Meta publishes no benchmark for these ratios. Uses platform-reported numbers. A good hook and hold say nothing about sales on their own. Example data is fictional. No account connection, macros or automatic changes.

Primary references

Continue the work