Free editable template

Dr. Squatch ad teardown: deadline checker and ad template

See how Dr. Squatch launched its holiday season in one batch and kept a thank-you ad running since 2024, then run the same system with deadlines that stay honest. The Excel workbook holds the real Dr. Squatch counts (start days, keywords, opening lines, oldest ads), the ad broken into reusable parts, an ad log for any brand, and a deadline check that marks each urgency ad fine, refresh, swap the copy or turn off.

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

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.

StartedDays running (to 17 Nov 2026)Format
22 Jan 20241,030Video
27 Oct 202621Not recorded
27 Oct 202621Not recorded
27 Oct 202621Not recorded
27 Oct 202621Not 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

Continue the work