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.
| Rule | Condition | Default |
|---|---|---|
| Hook rate | 3-second video plays ÷ impressions | Bar: 30% (ours) |
| Hold rate | ThruPlays ÷ 3-second plays | Bar: 25% (ours) |
| Score | 0.5 × hook ÷ hook bar + 0.5 × hold ÷ hold bar | 1.00 = on both bars |
| Grade | Score cut-offs | A 1.15+, B 0.95+, C 0.75+, D 0.55+, F below |
| Scale it | Hook and hold at or above both bars | 30% and 25% |
| Fix the hook | Hook below its bar, hold at or above | |
| Fix the middle | Hook at or above its bar, hold below | |
| Kill it | Both below their bars | |
| Too early | Impressions below the minimum | 5,000 |
| Short video | Video shorter than 15 seconds | 15 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.
