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
Start from the 21-brand snapshot
The first data tab holds what the Meta Ad Library showed on 17 November 2026: live US ads per brand, split into age buckets (7 days or less, 8 to 14, 15 to 30, 31 to 90, 91 to 365, over a year), the share under two weeks and over 90 days, each brand's median and oldest live ad, and a link to its library page.
Read the survivors
The Survivors tab lists each brand's oldest live ad with its Library ID, start date, opening line and what kind of ad it is. Days running calculate from the check date, so the sheet stays correct if you re-check later.
Write your own long-runners
Five kinds of ad account for the survivors: thank the buyer, only here, answer the price, one job with one number, and a plain product card. Write one of each that fits your business in the yellow column, in your own words.
Track a competitor
Open their Page in the Ad Library (active ads, your country), scroll to the end and log each ad's start date. The tracker buckets the ads by age and reads the brand as one that keeps winners or one that replaces ads within weeks.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Brand | Library ID | Started |
|---|---|---|
| Dr. Squatch | 2295538227304285 | 22 Jan 2024 |
| Athletic Brewing | 3630020123798545 | 5 Jun 2025 |
| Vuori | 757164004028493 | 20 Oct 2025 |
| Quince | 1604505307549964 | 21 Feb 2026 |
| Huel | 4239632006288183 | 14 Mar 2026 |
| Bombas | 976214191591102 | 10 Apr 2026 |
| Liquid Death | 1694190404912729 | 29 Apr 2026 |
| Poppi | 3379583008909488 | 10 May 2026 |
Worked review example
Real data, 17 Nov 2026 (Grüns 16 Nov): 6,570 live US ads across 21 brands. 3,194 (49%) were two weeks old or less, 245 had run more than 90 days and 4 more than a year. 12 of 21 brands had a median live ad under two weeks; Jones Road, Gymshark, Glossier, SKIMS and Oura had nothing live older than 20 days.
The oldest live ad of all is Dr. Squatch's 'Thanks for ordering' welcome video, live since 22 January 2024 (1,030 days), at a brand where 250 of 462 live ads carry a '% off'.
What this template does and does not establish
Read by hand from the public Meta Ad Library on one day. Outside the EU the library shows only running ads, so 'oldest' means 'oldest still live', not 'longest ever'. The library shows no spend or results: a long run means a brand keeps paying for an ad, not that it is profitable. Quince is its first 1,520 ad cards of a ~5,700-result header. Tracker example rows are fictional.
Primary references
- Meta Ad Library (read 17 Nov 2026)
- Dr. Squatch's oldest live ad in the Meta Ad Library
- Meta Transparency Center: Ad Library tools
