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 budget, target and restart date
On Settings, your normal weekly budget, target cost per purchase, the restart date (Dec 26 by default), how many new creatives to launch and the budget lift while CPMs are low.
See what your budget buys
The CPM tab holds Gupta Media's weekly Meta CPMs for Nov 2025 to Jan 2026 and works out impressions for your budget each week. Type your own account's CPMs next to them and it uses yours.
Run the Planner
Twelve tasks from Dec 20 to late January with dates that move with your restart date. Give each an owner; rows go amber when due within 7 days and red when overdue.
Judge January after Jan 15
Type spend, impressions, link clicks and purchases for Dec 1 to 24 and Dec 26 to Jan 15. The Judge tab compares CPM, click-through rate, purchases per click and cost per purchase, and says whether January was cheaper per sale or only per impression.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Date | Task | Detail |
|---|---|---|
| Sun 20 Dec | Everything built and approved | Ads, new-year offer, audiences and budgets ready; campaigns scheduled to start Dec 26 |
| Sun 20 Dec | Holiday ads scheduled off | Anything that says Christmas, gift or ships-by stops on Dec 25 |
| Sat 26 Dec | Prospecting back on, budget up | Weekly budget 30% above normal while impressions are cheap (example default) |
| Sat 26 Dec | New creatives into testing | 20 new ads, at least half new angles, launched together |
| Fri 1 Jan | New-year offer live | A starter kit, routine or bundle, not a leftover holiday discount |
| Sat 2 Jan | Retarget holiday buyers | Second-product ads and how-to content for every first-time holiday buyer |
| Fri 15 Jan | Keep the winners, cut the rest | Judge on cost per purchase against target, not CPM |
Worked review example
Gupta Media's tracker, 2025-26 season: weekly Meta CPM fell from $12.48 (week of Dec 1) to $4.93 (week of Dec 29), 60% cheaper, so $10,000 bought 801,282 impressions on Dec 1 and 2,028,398 the week of Dec 29. Every January week was $6.59 to $6.99.
Fictional store with a $45 target: CPM fell 40% from December to early January, but click-through rate fell 10% and purchases per click 32%, so cost per purchase went only from $50.00 to $49.18. Verdict: cheaper than December, still above target; keep testing creative, don't raise the budget yet.
What this template does and does not establish
Gupta's tracker doesn't publish its size and its CPMs run below other US trackers; use it for the season's shape, and your own CPMs for dollars. Last season's dates and depth aren't a promise for this one. Cheaper impressions don't guarantee cheaper sales. The plan, the 30% lift and the 20 creatives are our recommendations, not Meta guidance. No account connection, macros or automatic changes.
Primary references
- Gupta Media: What Is Q5 in Marketing? (weekly Meta CPM tracker)
- Bïrch: Meta ad costs analysis (US, 2021 to 2023)
- GeistM: Meta rate trends Q1 2025
- SuperAds: US Facebook CPM
