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
Search one competitor and filter to active ads
In the Meta Ad Library, choose your customers' country and All ads, search the competitor's Page, and filter to active ads. Screenshot each ad and note its 'Started running' date, its platforms and whether it has several versions.
Log five things per ad
Format, hook type, offer, days running and variant count. Count variants as versions of the same idea: same customer problem and promise, different face, first line, length or format. Use the dropdowns so the pattern summary can count them.
Check weekly
Outside the EU, an ad that stops usually leaves the Meta library, so update 'last seen active' every week and mark ads that have gone. Days running is a survival signal, not a profit figure: combine it with the variant count before you call anything a winner.
Brief the question, not the answer
Take the customer problem, the format and the type of offer from the proven-and-scaled ads. Write your own hook, use only proof you can show, and leave their footage, script, music, claims and trademarks alone. The brief builder only says ready when all five originality checks are yes.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Brand | Platform | Ad link or library ID |
|---|---|---|
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
| Competitor A (example) | Meta | Library ID from the ad |
Worked review example
Illustrative: 12 ads from one fictional skincare competitor, checked on 16 November 2026. Four are proven and scaled: a UGC problem-agitation video (105 days, 7 variants), a static comparison (76 days, 5), a UGC myth-buster (62 days, 4) and a static review quote (83 days, 3). Two new ads with 4 to 6 variants are being tested.
The pattern: UGC-style videos that name a customer problem or bust a myth, paired with a first-order discount, plus static comparison and review ads. The brief keeps the customer moment (makeup sitting on dry skin by midday) and replaces everything else with the brand's own product, proof and wording.
What this template does and does not establish
The example rows are fictional and show the method, not any real brand's ads or results. Days running cannot reveal spend, profit or results, and a long-running ad may simply be cheap or forgotten. The Meta Ad Library API returns commercial ads only if they reached the EU; elsewhere it covers social issue, electoral and political ads. Meta's terms prohibit automated collection without permission, so the workbook assumes manual checks or the official API.
Primary references
- Meta: about the Meta Ad Library
- Meta Transparency Center: Ad Library tools and retention
- Meta for Developers: Ad Library API (ads_archive)
- Google: the Ads Transparency Center
- TikTok: about Creative Center
- TikTok: Commercial Content API
