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 Dr. Squatch snapshot
The first data tab holds what the Meta Ad Library showed on 17 November 2026: 462 live US ads, 322 started on 27 and 28 October, 149 opening '... | Final Days', 250 saying '% off', 304 using 'sold out' or 'limited', zero partnership ads, and a thank-you video live for 1,030 days.
Write the offer first
The Ad template tab breaks the Dr. Squatch ad into parts: the offer in the first words, a deadline, proof, a limited product, plus an evergreen welcome ad. Write yours in the blank column.
Check every deadline line
In the Deadline check tab, list each urgency ad with when it started and when the offer really ends. The sheet looks for 'final', 'last' and 'ends' and marks each ad: fine, refresh (old ad), swap the copy (deadline line too early) or turn off (offer ended).
Log any competitor the same way
Open their Page in the Ad Library (US, active ads) and log each live ad. Days running and age calculate from the check date. In a one-batch brand, the ads older than the batch are the ones worth studying.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Started | Days running (to 17 Nov 2026) | Format |
|---|---|---|
| 22 Jan 2024 | 1,030 | Video |
| 27 Oct 2026 | 21 | Not recorded |
| 27 Oct 2026 | 21 | Not recorded |
| 27 Oct 2026 | 21 | Not recorded |
| 27 Oct 2026 | 21 | Not recorded |
Worked review example
Real Dr. Squatch data, 17 Nov 2026: 462 live US ads (680+ versions). 214 started on 27 October and 108 on 28 October. 108 ads open 'FREE TRAVEL BAG + 39% OFF | Final Days' and 41 the same with 50% off; the oldest of those started 27 October, 21 days earlier. The oldest live ad is a 'Thanks for ordering' video from 22 January 2024.
Fictional deadline check: of 5 urgency ads, 2 need changing now: a 'Final Days' ad for an offer with 14 days left, and a 'Last chance' ad whose offer ended 12 November.
What this template does and does not establish
Dr. Squatch data was read from the public Meta Ad Library on one day, 17 November 2026 (US, active ads). Outside the EU the library shows only running ads, so days running are 'so far'. The library shows no spend, results or targeting; that the thank-you ad speaks to new buyers is our read of its copy. Some 'Final Days' ads may be newer than 27 October. Deadline-check numbers are fictional.
Primary references
- Meta Ad Library: Dr. Squatch Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- FTC: Bringing Dark Patterns to Light (2022)
