Skip to content
All resources
Black Friday Meta Ads Budgets Excel

Black Friday Facebook Ads Budget Plan: Free Excel

The DashOps Team November 7, 2026 7 min read

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.

image_20261111_204713

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:

DateWeekdayPhaseAcme Apparel prospectingAcme Apparel saleDay totalActual spendOver or under
25 NovWed1 week before1500150
26 NovThu1 week before150100250
27 NovFriSale100600700

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.

  1. 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.
  2. Decide how many results this sale needs.
  3. 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.
  4. Add what you want to spend in the weeks before the sale.
  5. 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.

PhaseDates in 2026The question to answer
4 weeks before30 Oct to 5 NovWhat are you testing, and what can you afford to learn?
3 weeks before6 to 12 NovWhich audiences and creative earn a place in the sale?
2 weeks before13 to 19 NovAre the sale campaigns built, with time left for review?
1 week before20 to 26 NovHow much goes on reaching people before the offer starts?
Sale27 to 30 NovWhich campaign gets the most on each day?
After1 and 2 DecDoes 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?
Work it out from your own numbers: the results the sale needs, multiplied by what a result cost you in your last sale, plus what you want to spend in the weeks before. The file holds no holiday cost figure, because another advertiser's number tells you nothing about your own margins.
Should I use a daily or a lifetime budget for the sale?
Meta describes a daily budget as an average over a Sunday to Saturday week and a lifetime budget as a hard cap on the whole run. If you have a fixed amount for the sale and are flexible about each day, a lifetime budget fits. If you want a set amount each day, use a daily budget and expect some days to run above it.
Why does a sale day show over my plan?
A daily budget is an approximate daily amount and Meta may spend more on days it sees better opportunities and less on others. Actual spend on a day also counts every campaign in your export, so check that nothing outside the plan is spending. Then read Over or under next to the phase total in the Week summary before you change a budget, because one high day may be balanced by the days around it.
When should I submit Black Friday ads for review?
Meta says its review process typically takes up to 24 hours and can take longer, so give your sale ads a margin well ahead of 27 November. You can create an ad in advance and leave it off, or set a schedule when you create the ad set.
Can I use the plan again next year?
Yes. Type the new year in the Year cell and, as long as you have not overtyped Sale starts, the dates move to that year's Black Friday. Clear your budgets and paste a new export. Check the date it gives against your own sale before you plan around it.

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.

Keep reading

Get in touch

Tell us about your setup or ask a question and we usually get back to you within one business day. Running more than 20 ad accounts? We will tailor a custom plan for you.

DashOps
Product updates

Get more from every Meta Ad

New features, product news, and practical Meta Ads tips, straight to your inbox.

Subscribe to product updates

Join our newsletter for new features, tips, and the occasional Meta Ads playbook. We may also send you an invite to our community. No spam, unsubscribe anytime.

We use your email to send these updates, and we may also use it to send you an invite to our community. When you subscribe, we also report the sign-up to Meta, and to Google if your browser has a Google Analytics cookie, as our Privacy Policy explains.