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
Set your lists
On the Lists tab, replace the example formats, hooks, creators and ratios with your own. One word per value, no spaces or underscores, and a one-sentence definition for each hook so everyone tags ads the same way.
Build each name before you publish
On the Name builder, pick the date, format, hook, creator, ratio and version. The sheet writes 261104_UGC_PainPoint_SarahK_9x16_v2 and checks that nothing is missing or off-list. Paste it as the ad name, or set up an Ads Manager name template. Rename duplicates before publishing.
Paste your export
In Ads Manager, at ad level, export ad name, amount spent and purchase conversion value, and paste them into the Report tab. Each name is split into its six parts and any name that doesn't parse is flagged.
Read ROAS by hook
The Summary tab totals ads, spend, revenue and ROAS by hook, format and creator, and marks each one: make more of these, around average, or move budget away. Compare hooks with each other, not with your bank balance.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Part | Example | Allowed values |
|---|---|---|
| Date | 261104 | The day the ad was made, YYMMDD |
| Format | UGC | UGC, Static, Carousel, Demo |
| Hook | PainPoint | PainPoint, SocialProof, Founder, Unboxing, Price, Myth |
| Creator | SarahK | First name and initial, or InHouse |
| Ratio | 9x16 | 9x16, 4x5, 1x1 |
| Version | v2 | v1, v2, v3… |
Worked review example
Fictional 512-ad account (from our video): $295,064 of spend; 253 old names contained 'Copy' and 54 said 'FINAL'. With clean names, ROAS by hook ran from 3.41x (PainPoint) to 0.92x (Myth), and Myth had taken the most spend, $57K.
Motion's Creative Benchmarks 2026: roughly 5% of Meta creatives spend at least 10x their account median, across 578,750 creatives and $1.29B of spend. Knowing which hook those few share is the point of the name.
What this template does and does not establish
Works only for ads named with the convention; old ads need renaming or tagging first. ROAS uses Meta's reported conversion value, which depends on the attribution setting. Hooks with few ads or little spend aren't proven either way. Ads Manager's name template menu has moved over time; check where it is in your account. Example data is fictional.
Primary references
- Motion (Runneth): Creative Benchmarks 2026, winners are rare
- Meta Business Help Center: Apply a name template in Meta Ads Manager
- Meta Marketing API: name template settings
