Free editable template

Competitor ad tracker (Ad Library playbook)

Find the ads competitors keep paying for and keep re-making, then brief original ads around the same customer problems. The workbook turns weekly Ad Library checks into days running, a four-way signal (proven and scaled, being tested, quiet keeper, too early), a pattern summary by format, hook and offer, and a brief builder with originality checks.

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

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.

BrandPlatformAd link or library ID
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary ID from the ad
Competitor A (example)MetaLibrary 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

Continue the work