Free editable template

Black Friday ad playbook and BFCM calendar template

Plan the 17 days around Black Friday in one place. The Excel workbook works out break-even ROAS and the most you can pay per order at your sale price, compares % off, $ off, bundles and free gifts on margin, lines up last year's CPMs by days from Black Friday, and turns your budget plan into expected orders and ROAS. The dates move with the year you type, so it works every November.

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

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 FridayDate (2026)Phase
-11Mon 16 NovPrep
-10Tue 17 NovPrep
-9Wed 18 NovPrep
-8Thu 19 NovPrep
-7Fri 20 NovWarm-up
-6Sat 21 NovWarm-up
-5Sun 22 NovWarm-up
-4Mon 23 NovWarm-up
-3Tue 24 NovWarm-up
-2Wed 25 NovWarm-up
-1Thu 26 NovPeak
0Fri 27 NovPeak
1Sat 28 NovPeak
2Sun 29 NovPeak
3Mon 30 NovPeak
4Tue 1 DecExtension
5Wed 2 DecWind-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

Continue the work