Black Friday Facebook Ads Budget Plan: Free Excel
This free Excel Black Friday budget plan has every day from 30 October to 2 December 2026 already laid out, with Black Friday on 27 November and room for six campaigns. Type a total budget and a budget per campaign per day, and it adds up each day, each phase and what is left to spend.
The file holds no holiday cost figure and suggests no split. Every number in it comes from you, which is why the first job below is finding your own.

What the plan tab looks like
The file opens on the Black Friday plan tab. If Excel shows Protected View, click Enable Editing first, or the yellow cells will not take your typing.
At the top sit Year, Sale starts, Sale ends and Total budget, with Left of total budget beside them. Sale starts reads 27 November 2026 and Sale ends reads 30 November, so the Sale phase runs Friday to Monday. Overtype either date if your sale differs, and the rows move with it.
Type your campaign names across the top, exactly as they appear in Ads Manager. For example, a made up Acme Apparel plan with two campaigns could read:
| Date | Weekday | Phase | Acme Apparel prospecting | Acme Apparel sale | Day total | Actual spend | Over or under |
|---|---|---|---|---|---|---|---|
| 25 Nov | Wed | 1 week before | 150 | 0 | 150 | ||
| 26 Nov | Thu | 1 week before | 150 | 100 | 250 | ||
| 27 Nov | Fri | Sale | 100 | 600 | 700 |
Actual spend and Over or under stay blank until you paste an export broken down by day. Under the day rows, a Week summary gives each phase a Budget row and an Actual row for each campaign.
Work out the total from your own numbers
Start from what the sale has to bring in, then work back to money.
- In Ads Manager, read your own cost per result for last year’s sale, or for your most recent sale if you have no Black Friday history.
- Decide how many results this sale needs.
- Multiply them. For example, if your own cost per purchase last year was 25 and you need 400 purchases, the Sale phase needs 25 x 400 = 10000.
- Add what you want to spend in the weeks before the sale.
- Type the total in Total budget. Left of total budget now counts down as you fill the rows.
Last year’s cost is a starting point and this year’s auction can differ. If your costs moved sharply last time, why a CPM can jump on Facebook Ads helps you work out what moved them before you trust the figure.
Split it by phase
The tab already sorts every day into a phase, so you only decide what each phase is for. No percentage split is offered here, because a split borrowed from another advertiser says nothing about your margins or your stock.
| Phase | Dates in 2026 | The question to answer |
|---|---|---|
| 4 weeks before | 30 Oct to 5 Nov | What are you testing, and what can you afford to learn? |
| 3 weeks before | 6 to 12 Nov | Which audiences and creative earn a place in the sale? |
| 2 weeks before | 13 to 19 Nov | Are the sale campaigns built, with time left for review? |
| 1 week before | 20 to 26 Nov | How much goes on reaching people before the offer starts? |
| Sale | 27 to 30 Nov | Which campaign gets the most on each day? |
| After | 1 and 2 Dec | Does anything keep running for late buyers? |
If a phase has already passed when you read this, leave its rows blank. A blank row counts as nothing in every total.
Fill the cells one campaign at a time, then read the Week summary. A phase whose Budget row surprises you is easier to fix now than on the Friday.
Turn the plan into Ads Manager budgets
Ads Manager never sees this file. It spends by the budget you set on the campaign or ad set, so a day on your plan is only your own target. These are Meta’s rules for how that budget gets spent, from its help pages as read on 4 November 2026. They can change, so check them before you rely on a figure.
The sale crosses Meta’s budget week. Meta writes: “Your daily budget tells Meta an approximate amount to spend per day over the course of the week starting on Sunday and ending on Saturday.” Black Friday and the Saturday sit at the end of one week. Sunday and the Monday sit at the start of the next, so read the two halves of your sale separately when you compare them with a weekly limit.
A budget raised on the Friday gets a short week. Meta’s page on changing a daily budget says: “To calculate the spending limit for the rest of the week, Meta takes the new daily budget, multiplies it by the days left in the week, then adds up to 25% of the daily budget for flexibility.” For example, if you raise a daily budget to 500 at the very start of Friday 27 November, two days are left in that week, so the limit for those two days is 500 x 2 + 125 = 1125.
One day can run above its budget. Meta’s page on daily budgets says: “On days when better advertising opportunities are available, Meta may spend up to 75% over your daily budget.” So a positive Over or under on a sale day is not a fault by itself. Read it next to the phase total before you change anything.
A lifetime budget is the option if the sale has a fixed amount. Meta’s budgets page says lifetime budgets are a hard cap and work best when you are flexible about each day’s spend. If you use one, your day cells become your own estimate of how the money might fall, and Over or under shows the gap.
Fewer changes beat many. Meta’s learning phase page advises you to avoid frequent budget changes, which can send an ad set back into the learning phase. Look along each campaign’s row: if the number changes every day, you are planning a lot of edits. Holding a budget steady inside a phase and changing it where the phase changes keeps the count down.
Ads need time in review. Meta’s scheduling page says: “This review process typically takes up to 24 hours, although sometimes, it might take longer.” The same page says you can create an ad in advance and turn it off, or set a schedule while creating the ad set. Either way, pick a day well ahead of 27 November to have your sale ads submitted.
Track the sale once it starts
The budgets work with nothing pasted. To see real spend beside them, you need an export with days in it, and a default export has none. So in Ads Manager, stay on the Campaigns tab, pick dates inside the plan, set Breakdown to By time and Day, and export the table from Reports as CSV. The menu words can differ, and the file’s How to use tab has the steps one by one. Then paste the whole CSV, top row included, at cell A1 of the Paste your export tab, after clearing whatever is there.
Without the Day setting, the top line reads: “This export is not broken down by day, so Actual spend stays empty. Your budgets still work.” With it, Actual spend fills for each date and Over or under shows Actual spend minus Day total. The file does not refresh itself, so repeat this whenever you want the latest numbers.
The Actual columns can mislead. In the Week summary, Actual on a campaign finds it by its exact name. Actual spend on a day row and the Actual total both count every campaign in your export, including any you did not name. So a day that reads over may only mean something outside the plan is spending. Compare the Actual total with your named campaigns in the Week summary before you cut a budget.
On Growth and Enterprise, the top campaigns list in DashOps ranks campaigns by spend, ROAS or leads. The plan by day stays in this file.
For the rest of the year, the ad spend tracker template holds this same tab with a media plan and a plan against actual view. If the words budget, spend and amount spent blur together, this guide to the three terms separates them.
Frequently asked questions
How much should I budget for Black Friday on Facebook?
Should I use a daily or a lifetime budget for the sale?
Why does a sale day show over my plan?
When should I submit Black Friday ads for review?
Can I use the plan again next year?
See it in your own dashboard
DashOps brings Meta Ads reporting, campaign management, and white-label client portals into one place. Pick the plan that fits how you run ads.