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.
| Brand | Live ads | New this week |
|---|---|---|
| Quince | 1,520+ | 91 |
| Ridge | 954 | 334 |
| AG1 | 572 | 378 |
| Vuori | 534 | 70 |
| Dr. Squatch | 462 | 37 |
| Hims | 428 | 195 |
| Huel | 421 | 43 |
| Jones Road | 408 | 248 |
| True Classic | 225 | 82 |
| Gymshark | 72 | 70 |
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.
