Free editable template

Creative fatigue tracker and refresh calendar

Replace winners before they die instead of after. Each live ad is compared with its own first-week cost per result and CTR, gets a status, a projected tired date and a 'brief by' date (tired date minus days to make and days to test). The refresh calendar tracks each replacement, and the lifespan tab turns your past ads into a weekly testing target.

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

Set the review date and thresholds

On the Settings tab, type the Monday you run the review, the days it takes you to make a new ad and to test one, and how many winner slots you want filled. Defaults: WATCH at 1.3x an ad's first-week cost per result, TIRED at 2x (Meta's Creative fatigue line), early signs at CTR down 30% with frequency 3.5+.

Add each winner to the Tracker

One row per live ad you care about: launch date, its cost per result and CTR in its first 7 days, its cost per result two weeks ago, and last 7 days' cost per result, CTR and frequency from Ads Manager. Formulas give a status, the weekly rise in cost, a projected tired date, a 'brief by' date and the action for this week.

Fill the refresh calendar

Every tracked ad appears with its dates. Pick a refresh type (new hook, format, angle or offer), write the replacement idea, an owner and the live date. Rows go amber when a brief is due within 7 days and red when it is overdue; the top line counts replacements to start this fortnight.

Log past ads once a month

On the Lifespan tab, log launch and stop dates and whether each ad became a winner. The tab works out your hit rate, how long your winners last, and how many new ads to test each week to keep your winner slots full.

Preview the worksheet

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

RuleConditionDefault
BaselineCost per result and CTR in the ad's first 7 daysIts own numbers
FRESHCost per result below the WATCH multiple of its baselineBelow 1.3x
WATCH (cost)Cost per result at or above the WATCH multiple1.3x
WATCH (early signs)CTR down from the first week AND frequency high30% down and 3.5+
TIREDCost per result at or above the TIRED multiple2x (Meta's Creative fatigue line)
Weekly riseSquare root of (last 7 days ÷ two weeks ago) minus 1Projected only above 2% a week
Projected tired dateReview date + 7 × ln(TIRED line ÷ current cost) ÷ ln(1 + weekly rise)From the review date you type
Brief byProjected tired date − days to make − days to test7 + 4 days
Refresh typeHow different the replacement isNew hook, format, angle or offer
SwapTest the replacement before retiring the originalKeep the tired ad at the same budget
Winners needed per weekWinner slots ÷ median winner lifespan in weeksFrom your Lifespan log
New ads to test per weekWinners needed per week ÷ hit rateFrom your Lifespan log

Worked review example

Fictional coffee brand, review on 16 November 2026: of 8 live ads, 2 are TIRED (2.05x and 2.19x their first-week cost per result), 2 are WATCH (one at 1.39x, one on early signs: CTR down 35% at frequency 3.8) and 4 are FRESH. The UGC unboxing ad is rising 14.7% a week, so it is projected to be tired on 5 December and its replacement must be briefed by 24 November.

From 20 logged past ads, 5 became winners (25% hit rate) and the median winner lasted 38 days. To keep 6 winner slots full the brand needs 1.1 new winners a week, which means testing about 4.4 new ads a week.

What this template does and does not establish

Uses platform-reported results, which depend on Meta's attribution setting; a rising cost per result can also come from tracking, site or seasonal changes. The 2x TIRED line mirrors Meta's label; the other thresholds are starting points, not Meta rules or benchmarks. The projected date extrapolates two weeks of change and moves every week. Lifespan maths is shaky with fewer than about 20 logged ads. No account connection, macros or automatic changes.

Primary references

Continue the work