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
Filter to what you can make this week
In the Swipe file tab, choose a group, a maximum effort and your product type. Every matching format shows 'Yes'. Sort by Test-first score: formats that are fast to launch and cheap to make come first. In the swipe file, 22 of the 50 formats score effort 1 and speed 5.
Write three hooks per format
Use each format's hook line template to write three different openings, then shoot or design one body. Three formats with three hooks each gives nine ads from a few hours of work, and you learn whether the format or the opening made the difference.
Find live examples before you shoot
Open the Meta Ad Library, choose your country and All ads, search a category word, then filter to active ads and video or image. Each card shows when the ad started running. Log long-running examples in the Ad Library log and map each to a format number; study the structure, never copy the ad.
Log every test and let the verdict wait
Add each ad to My tests with its format number. The sheet calculates hook rate, CTR, CPA and ROAS, and says 'Too early' until the ad has spent your minimum (twice target CPA by default). The Format scorecard then shows which groups and formats work for your product.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| # | Format | Group |
|---|---|---|
| 1 | Founder-to-camera story | People on camera |
| 2 | Founder explains the price | People on camera |
| 3 | UGC testimonial | People on camera |
| 4 | UGC day-in-the-life | People on camera |
| 5 | Street interview | People on camera |
| 6 | Expert explainer | People on camera |
| 7 | Podcast-style clip | People on camera |
| 8 | Green screen reaction | People on camera |
| 9 | Us vs them | Argument and comparison |
| 10 | Comparison table | Argument and comparison |
| 11 | Myth vs fact | Argument and comparison |
| 12 | Problem-agitate-solve | Argument and comparison |
| 13 | 3 reasons | Argument and comparison |
| 14 | Listicle: things I wish I knew | Argument and comparison |
| 15 | Stop doing this | Argument and comparison |
| 16 | Objection handler | Argument and comparison |
| 17 | Before and after | Proof |
| 18 | Review stack | Proof |
| 19 | Press and badge bar | Proof |
| 20 | Results timeline | Proof |
| 21 | Torture test | Proof |
| 22 | Side-by-side test | Proof |
| 23 | One-number proof card | Proof |
| 24 | Unboxing | Product demo |
| 25 | Satisfying sound demo | Product demo |
| 26 | How-to tutorial | Product demo |
| 27 | Macro detail | Product demo |
| 28 | What's inside breakdown | Product demo |
| 29 | Hands-only POV demo | Product demo |
| 30 | Use it 3 ways | Product demo |
| 31 | Price anchor | Offer and price |
| 32 | Offer card | Offer and price |
| 33 | Bundle builder | Offer and price |
| 34 | Countdown and deadline | Offer and price |
| 35 | Free gift reveal | Offer and price |
| 36 | Guarantee-led | Offer and price |
| 37 | Cost per use | Offer and price |
| 38 | Notes app list | Native and lo-fi |
| 39 | Text-message chat | Native and lo-fi |
| 40 | Social post style | Native and lo-fi |
| 41 | Forum question | Native and lo-fi |
| 42 | Meme | Native and lo-fi |
| 43 | Handwritten note | Native and lo-fi |
| 44 | POV skit caption | Native and lo-fi |
| 45 | Skit or mini-drama | Story and entertainment |
| 46 | Things that just make sense | Story and entertainment |
| 47 | How it's made | Story and entertainment |
| 48 | Gift guide | Story and entertainment |
| 49 | Trend adaptation | Story and entertainment |
| 50 | Customer mini-documentary | Story and entertainment |
Worked review example
Illustrative test: a burr-grinder brand runs format 12 (problem-agitate-solve) with the hook 'If your coffee tastes bitter at home, it's not your fault.' After $180 of spend it has 21,500 impressions, 6,235 three-second plays (29% hook rate), 7 purchases and $616 revenue: ROAS 3.42 against a 2.0 target, so the verdict is 'Good: scale or iterate'.
A second ad using format 38 (notes app list) has spent $45 with one sale. With a $30 target CPA the minimum spend before judging is $60, so the verdict is 'Too early' even though its ROAS looks low. The rule stops one lucky or unlucky sale from deciding the test.
What this template does and does not establish
Formats, effort scores, speed scores and product-fit flags are GaaS editorial judgement, not measured performance. Nothing here says a format will work for your product; your own tests decide. The verdict rule is a simple spend threshold, not a statistical test. Ad Library run time is a clue that an advertiser keeps paying for an ad, not proof that it is profitable. Check platform policies for your category (health claims, before-and-after images, fake interface elements) before you publish.
Primary references
- Meta Ad Library
- Meta Ad Library API: what it covers
- Meta Advertising Standards: non-existent functionality
- Meta: 3-second video plays
- Meta: About the learning phase (ad volume)
- FTC: Rule on consumer reviews and testimonials (16 CFR 465)
- FTC: Guides Against Deceptive Pricing (16 CFR 233)
