Black Friday Facebook Ads Report: Free Excel Sheet
Once the sale ends, someone will ask what it delivered against a normal week and against last year, and this free Black Friday Facebook Ads report answers both, per day and campaign by campaign. It is an Excel file with no signup. It stays empty until you paste an Ads Manager export, and that export must be broken down by day. A default export has no days in it, so read the setup below before you pull your numbers.
Why it compares per day
Black Friday to Cyber Monday is four days. The period you compare it with is four weeks. Totals tell you nothing across windows that different.
For example, if spend was 4,000 across the 4 sale days and 7,000 across the 28 days before, the totals say the weeks before were bigger. Per day, the sale ran at 1,000 against 250.
So the tab shows both, and it compares amounts on the per day figure. Its own wording: “Days and Per day count only the days your export holds in each window.” A window only partly in your export gets a note saying how many of its days are there.
The three windows
| Window | What the tab uses for 2026 | How to change it |
|---|---|---|
| Sale days | 27 to 30 November 2026, Black Friday to Cyber Monday | Type in Sale starts and Sale ends |
| Weeks before | 30 October to 26 November 2026 | Type a number in Weeks before to compare, set to 4 |
| Last year’s sale | 28 November to 1 December 2025 | Type in Last year’s sale starts and ends |
If your sale runs on other dates, or you only want Cyber Monday, overtype the yellow cells and the rest follows. Blank cells go back to the dates above. The Year cell works the same way: blank means the latest year in your export.
Black Friday moves every year. Last year’s Cyber Monday fell on 1 December 2025, so an export of “the same dates a year earlier” that stops on 30 November 2025 misses a day. Run last year’s export through 1 December. Otherwise the tab tells you it holds 3 of 4 days.
Set it up before the sale
Do these while there is still time to fix anything.
- Paste last year in now. Use the export steps below, with the same settings and dates that cover last year’s sale, 28 November to 1 December 2025. That is all the last year columns read. It goes in the Paste last year tab. If you have no sale to compare with, skip this: the last year columns stay empty and the rest fills. Meta’s page on exporting says the maximum reporting window is 37 months from the date of your request, so last year’s sale is still inside it.
- Keep your campaign names steady. The last year columns match campaigns by exact name, so “Demo Sale 2025” and “Demo Sale 2026” do not match. If you can use the same names this year, do.
- Note what you change during the sale. The file has no box for it. Keep a dated list of budget changes and new ads, because the numbers will show that something moved and not why.
- Set your budgets, if you have not. The Black Friday budget plan covers that side. This file only reports afterwards.
Get your numbers after the sale
- Tab. The Campaigns tab of the ad account, because the sale tables are built on Campaign name.
- Dates. Everything from the first day of the weeks before to the last sale day. For 2026, that is 30 October to 30 November.
- Columns. Open Columns, then Customize columns, and tick Amount spent, Impressions, Reach, Link clicks, Results, Landing page views, Leads, Purchases and Purchases conversion value.
- Breakdown. By time, then Day. The sale tables cannot run without it.
- Export. Reports, Export table data, CSV, as Meta’s help page on exporting describes.
- Paste. Open the CSV in Excel and copy all of it, top row too. In the report file, press Enable Editing if you see Protected View, clear the Paste your export tab, and paste at cell A1.
- Check. The line under the Black Friday title says what is ready and what is missing.
If a menu name has changed by the time you read this, pick the closest one.
Do not treat the first export as final. Meta’s page on attributed actions explains that a purchase on your website is credited to your ad if it happens within a certain number of days after someone viewed or clicked. Meta’s attribution page says its click-through setting counts events that occurred within 1 day or 7 days after a link click on your ad. So if your ad sets use the longer setting, someone who clicks on Cyber Monday and buys days later can still be counted. Take a first look straight away if you want one, then export and paste again after that window has passed. Neither page says which day a late purchase lands on in a by day export, so compare your two exports to see what moved. Put the export date in your report so nobody wonders why the numbers moved.
While you are there, compare the attribution setting behind your two exports, in the Attribution setting column, which the exports we read held. If yours has none, tick it under Customize columns and export again. If it changed between the years, the two are not counting the same thing, and the report should say so.
What each table tells you
All campaigns
Ten rows: Spend, Impressions, Link clicks, CTR, CPC, CPM, Purchases, Purchase value, ROAS and Cost per purchase. Made up numbers, to show the layout:
| Number | Sale days | Per day | Weeks before | Per day |
|---|---|---|---|---|
| Spend | 4000 | 1000 | 7000 | 250 |
| Purchases | 120 | 30 | 140 | 5 |
| ROAS | 2.4 | 2.9 | ||
| Cost per purchase | 33.33 | 50 |
The columns carry on to the right with Change per day, Last year’s sale, its Per day and its own Change per day. A rate such as ROAS has no per day figure, so its change compares the two rates directly.
The All campaigns table answers what the sale delivered. Read its lines together:
| What you see | What it suggests |
|---|---|
| Spend per day up, cost per purchase up | The extra budget bought sales at a higher cost each. Weigh that against your margin at the sale price |
| Spend per day up, cost per purchase flat or down | The extra budget held up. Your plan for next year can start from this |
| Spend per day flat, purchases per day up | The budget did not do the lifting, so look at the offer and at demand on those days |
| Weeks before look low against the sale | People may have waited for the sale, so read the two windows together before calling either one a problem |
By campaign
Up to 20 campaigns, highest sale spend first, with Sale spend, Per day, Weeks before per day, Change, Result type, Results, Cost per result, Last year’s sale spend and Change per day. Results stay per campaign, because leads and purchases cannot be added together.
The last year comparison works only for campaign names used in both years. Every other name goes in one last row, “Last year, other campaign names”. So a big figure in that row means last year’s spend sits under names not listed above, because the names changed or those campaigns did not run again. It does not mean last year’s campaigns did better or worse.
If a campaign was only renamed, you can fix that in the file. On the Paste last year tab, use Excel’s Find and Replace to change last year’s name to this year’s, since the match is on the exact name. Note in your report that you did.
By placement
This table needs a day and placement breakdown together. In Breakdown, pick Day and Placement: Ads Manager allowed both on the Campaigns tab when we tried it on 5 November 2026. If yours will not, keep Day: this table stays empty and the rest fills. A placement export with no days cannot stand in for it on this tab, because the sale windows need one row per day, so for those numbers read the Placement breakdown in Ads Manager on the sale dates. The table counts purchases only, because results of different kinds are not added together.
When the tab stays empty
| The line says | What to do |
|---|---|
| This export is not broken down by day, so this tab stays empty. | Export again with Breakdown, By time, Day |
| This export came from the Ads or Ad sets tab of Ads Manager | Export from the Campaigns tab |
| Your paste went into one column. | Select column A, open Data, then Text to Columns, choose Delimited, press Next, tick Comma and press Finish |
| Missing column, followed by a name | Add that column in Customize columns and export again |
Turning it into a report
The table gives you numbers, and your client wants a sentence. Lead with one line on what the sale delivered per day against the weeks before, then one on last year, then what you would change. The finished report example shows that shape on a full report, and for the ordinary months either side of the sale, see how to compare Facebook Ads month over month.
If you run sale campaigns across several clients, one file per ad account adds up quickly. The overview in DashOps lists every Meta ad account you switch on, with the key numbers for the dates you pick and the change from the period before. The comparison with last year stays in this sheet.
Frequently asked questions
Why does the report compare per day?
Why is the Black Friday tab empty after I paste my export?
Why is the By placement table empty?
What happens if my campaign names changed since last year?
Can I use this report for Cyber Monday alone, or for another sale?
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.