Free editable template

Competitor Meta Ad Library tracker: 10 brands, 10 minutes a week

See your competitors' rhythm instead of a single day. Once a week you log five numbers per competitor from the public Meta Ad Library; the workbook builds each brand's library link from its Page ID, compares the week with the last, and colours the rows where a brand is launching, on sale, keeping a long-runner or growing fast. An ad log tab holds individual ads when a row is worth a closer read.

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

Add your competitors once

On the Brands tab, type each competitor and its Facebook Page ID (the number after view_all_page_id= in its Ad Library URL). The sheet builds a link with active ads, the US and all formats selected.

Log five numbers every week

Open each link, scroll to the end, and add one row: live ad cards, ads started in the last 7 days, the oldest 'Started running on' date, ads containing '% off' (search the page), and the most-used opening line. About a minute per brand.

Read the flags

The Dashboard shows this week per brand and the change on last week. Rows light up when more than half the ads are new (launching), more than half say '% off' (sale on), an ad has run over 90 days (keeper) or live ads are up 50% on last week (growing). Thresholds are editable.

Go deeper on flagged brands

Log individual ads in the Ad log tab (Library ID, start date, format, offer, opening line) to study a launch or a keeper, then brief your own version in your own words.

Preview the worksheet

Every row shown here is included in the download. Scroll the table horizontally on a small screen.

BrandLive adsNew this week
Quince1,520+91
Ridge954334
AG1572378
Vuori53470
Dr. Squatch46237
Hims428195
Huel42143
Jones Road408248
True Classic22582
Gymshark7270

Worked review example

Real data, 17 Nov 2026: 5,596+ live US ads across 10 brands. Gymshark had launched 70 of its 72 live ads on 15 and 16 November, 70 with '% off'. Hims had 428 live and none with '% off' (195 offered free shipping). Dr. Squatch's oldest live ad, a 'Thanks for ordering' welcome video, had run 1,030 days.

Fictional 'Example Co' rows show the growth flag: 40 live ads on 10 November, 72 on 17 November, up 80%.

What this template does and does not establish

Counts are read by hand from the public Meta Ad Library; the library shows no spend or results, so the tracker shows what competitors run, not what works. Outside the EU only running ads are shown, so the week-on-week log is the only record of ads that stop. '% off' counts copy only; bundles, gifts and image-only offers are missed. Very large pages take longer: Quince was capped at its first 1,520 ad cards. The Ad Library API covers political and issue ads and ads delivered to the EU, not US-only product ads.

Primary references

Continue the work