Free editable template

Ad naming convention: name builder and hook report

Answer 'which hook makes us money?' in minutes. The workbook keeps a fixed list of values for each part of the name, builds valid names from dropdowns, and reads them back from a pasted Ads Manager export to total spend, revenue and ROAS by hook, format and creator, with a reading for each. It comes prefilled with a fictional 512-ad account so you can see the report before you use it.

By GaaS editorial · Sources checked · 6 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

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.

PartExampleAllowed values
Date261104The day the ad was made, YYMMDD
FormatUGCUGC, Static, Carousel, Demo
HookPainPointPainPoint, SocialProof, Founder, Unboxing, Price, Myth
CreatorSarahKFirst name and initial, or InHouse
Ratio9x169x16, 4x5, 1x1
Versionv2v1, 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

Continue the work