Skip to content
All resources
Meta Ads Facebook Ads Black Friday Cyber Monday Reporting Excel

Black Friday Facebook Ads Report: Free Excel Sheet

The DashOps Team November 15, 2026 9 min read

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

WindowWhat the tab uses for 2026How to change it
Sale days27 to 30 November 2026, Black Friday to Cyber MondayType in Sale starts and Sale ends
Weeks before30 October to 26 November 2026Type a number in Weeks before to compare, set to 4
Last year’s sale28 November to 1 December 2025Type 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.

  1. 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.
  2. 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.
  3. 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.
  4. 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

  1. Tab. The Campaigns tab of the ad account, because the sale tables are built on Campaign name.
  2. Dates. Everything from the first day of the weeks before to the last sale day. For 2026, that is 30 October to 30 November.
  3. Columns. Open Columns, then Customize columns, and tick Amount spent, Impressions, Reach, Link clicks, Results, Landing page views, Leads, Purchases and Purchases conversion value.
  4. Breakdown. By time, then Day. The sale tables cannot run without it.
  5. Export. Reports, Export table data, CSV, as Meta’s help page on exporting describes.
  6. 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.
  7. 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:

NumberSale daysPer dayWeeks beforePer day
Spend400010007000250
Purchases120301405
ROAS2.42.9
Cost per purchase33.3350

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 seeWhat it suggests
Spend per day up, cost per purchase upThe 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 downThe extra budget held up. Your plan for next year can start from this
Spend per day flat, purchases per day upThe budget did not do the lifting, so look at the offer and at demand on those days
Weeks before look low against the salePeople 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 saysWhat 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 ManagerExport 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 nameAdd 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?
The sale days and the weeks before are different lengths, so their totals cannot be set against each other. Dividing each window by the days your export holds in it gives figures you can compare. Rates such as CTR and ROAS have no per day figure, so their change compares the two rates.
Why is the Black Friday tab empty after I paste my export?
The sale comparison needs one row per day, and a default export is one block of dates. In Ads Manager, open Breakdown, then By time, choose Day, and export again. The line under the tab's title says the same thing when this is the cause.
Why is the By placement table empty?
It needs a day and a placement breakdown in one export. Ads Manager allowed both on the Campaigns tab when we tried it on 5 November 2026: pick Day and Placement in Breakdown and export again. Without the placement columns, the table stays empty and everything else on the tab fills.
What happens if my campaign names changed since last year?
The last year columns match on the exact campaign name, so a renamed campaign finds no match. Its spend goes into one row called Last year, other campaign names. If a campaign was only renamed, change last year's name on the Paste last year tab with Excel's Find and Replace.
Can I use this report for Cyber Monday alone, or for another sale?
Yes. Type your own dates in the yellow Sale starts and Sale ends cells, and in the two last year cells. The windows and tables follow them, and the export only needs to cover those dates and the weeks before, broken down by day.

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.