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
Do the margin maths first
Type your sale order value, product cost, shipping and payment fees. The workbook shows contribution per order, break-even ROAS (order value divided by contribution) and max CPA. In the worked example a $60 sale order leaves $26.20, so break-even ROAS is 2.29 and max CPA is $26.20.
Pick the offer on margin, not habit
Enter each offer you are considering on the same product. The calculator shows how many orders each one needs to earn the same contribution as 100 full-price orders. Deep percentage discounts usually need far more orders than a gift, bundle or spend threshold of similar perceived value.
Plan budgets and boosts before the peak
Paste last year's daily spend and impressions so the sheet can show how CPM moved around Black Friday. Set base budgets that step up days before the sale and add scheduled boosts for the peak days. The planner flags base-budget jumps bigger than your step rule and boosts above Meta's 8x high-demand-period cap.
Run the calendar and checklist
Assign an owner to every day and every checklist row: tracking, inventory, site speed, promo codes, customer service, ad account, email and SMS. During the sale, type actual spend and revenue each day; the planner colours each day against target and break-even.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Days from Black Friday | Date (2026) | Phase |
|---|---|---|
| -11 | Mon 16 Nov | Prep |
| -10 | Tue 17 Nov | Prep |
| -9 | Wed 18 Nov | Prep |
| -8 | Thu 19 Nov | Prep |
| -7 | Fri 20 Nov | Warm-up |
| -6 | Sat 21 Nov | Warm-up |
| -5 | Sun 22 Nov | Warm-up |
| -4 | Mon 23 Nov | Warm-up |
| -3 | Tue 24 Nov | Warm-up |
| -2 | Wed 25 Nov | Warm-up |
| -1 | Thu 26 Nov | Peak |
| 0 | Fri 27 Nov | Peak |
| 1 | Sat 28 Nov | Peak |
| 2 | Sun 29 Nov | Peak |
| 3 | Mon 30 Nov | Peak |
| 4 | Tue 1 Dec | Extension |
| 5 | Wed 2 Dec | Wind-down |
Worked review example
Illustrative store: an $80 product costing $24, $8 shipping, 3% payment fees. At full price each order leaves $45.60 (break-even ROAS 1.75). At 25% off it leaves $26.20 (break-even ROAS 2.29), so the sale needs 174 orders to earn what 100 full-price orders earned. A free gift costing $6 leaves $39.60 per order and needs 115.
The example budget starts at $300 a day, steps to $345 and then $400 before the sale, and adds scheduled boosts so Black Friday plans $1,000 (2.5x the base). Planned spend is $8,135 over 17 days. Using an invented CPM pattern, Black Friday's expected ROAS (2.31) barely clears break-even, which is why the plan watches that day most closely.
What this template does and does not establish
The workbook does arithmetic on your inputs; it cannot predict auctions, competitor behaviour or demand. The CPM history tab ships with invented example numbers to show the method; replace them with your own export. Contribution excludes fixed costs, so it is not net profit. The 'big jump' rule is a practitioner rule of thumb you set yourself; Meta does not publish a percentage. US holiday dates are assumed (Thanksgiving is the fourth Thursday of November).
Primary references
- Meta: About the learning phase
- Meta: Significant edits and learning phase
- Meta: About daily budgets (spend flexibility)
- Meta Marketing API: high-demand periods (budget scheduling)
- Google Ads: About seasonality adjustments
- Google Ads: About bid strategy statuses
- Google Ads: Overdelivery and average daily budget
- Google: Email sender guidelines
- web.dev: Core Web Vitals thresholds
- FTC: Guides Against Deceptive Pricing (16 CFR 233)
