Facebook Ads Report Template: What to Include
A Facebook ads report template works when it fits on one page and answers three questions: what did we spend, what came back, and what are we changing. Everything past that is an appendix, and most clients never open the appendix.
Below is the structure that survives, the metrics worth the space, and the part almost every template misses.
What should a Facebook ads report include?
Four blocks, in this order: headline numbers, creative, what changed, what is next.
| Block | Contents | Why it earns the space |
|---|---|---|
| Headline | Spend, revenue, ROAS, CPA, vs last period | The three questions, answered immediately |
| Creative | Top and bottom ads, as images | The only part the client can act on |
| What changed | Tests run, ads cut, budget shifts | Shows the account is being managed |
| Next | Two or three specific actions | Turns a report into a plan |
Page one should be readable in ninety seconds. A client who needs to hunt for the ROAS figure stops reading reports, and a report nobody reads is a report you can stop writing.
Which metrics belong on page one?
Six, and no more.
- Spend. The input. Always shown against the agreed budget.
- Revenue or leads. The output, in the client's own language.
- ROAS or CPA. The efficiency number, whichever one the business runs on.
- CPM. The cost of reaching people, which explains most sudden swings.
- CTR or hook rate. The creative signal, and the earliest warning of fatigue.
- Frequency. The audience signal, and the usual cause of a slow decline.
Those last three exist to explain the first three. When ROAS drops, the cause is nearly always visible in CPM, CTR, or frequency, and having them on the same page turns a bad number into a diagnosis. The definitions and thresholds are in Meta ads KPIs explained.
What to leave off page one: reach, impressions, link clicks, post engagements, video plays at every threshold, and anything with "estimated" in the name. They are diagnostic, not decisive. Put them in an appendix tab if anyone asks.
What benchmarks should the report compare against?
The account's own history first, category benchmarks a distant second.
Every report should show the current period next to the previous one and, where the data exists, the same period last year. Seasonality moves Meta costs more than most optimisations do, and a January-to-December comparison flatters or damns an account for reasons nobody controlled.
How do you show creative in the report?
As images, next to their numbers, on the same page.
This is the block most templates skip and the one clients respond to most. A spreadsheet row saying "Ad 4092837 — ROAS 4.2" means nothing. A thumbnail of the ad, with the hook line typed out underneath and its ROAS next to it, means everything, because it tells the client what kind of creative to make more of.
A workable creative block:
The last step is the whole point. Five thumbnails is data; the sentence naming what they have in common is analysis, and it is what gets the next month's creative brief written.
If the client also wants to see what competitors are doing, that is a separate section and a separate discipline — presenting a competitor ad audit to a client covers how to structure it without turning the monthly report into a research paper.
How do you build the template so it survives?
Structure it once, then only ever change the numbers.
Meta exports do most of the work. Ads Manager has a built-in export to CSV or Excel, and custom columns let you save the exact metric set your template needs so every export arrives in the same shape. Setting that up is covered in custom columns in Meta Ads Manager, and the export mechanics in downloading a Facebook ads report.
A few rules that keep a template alive past month three:
- One tab per period, identical columns. Never insert a column mid-year.
- Formulas reference the raw export tab, so pasting a fresh export updates everything.
- Currency and attribution window stated on the page. Both change, and both invalidate comparisons silently.
- The commentary lives in the file, not in the covering email. Emails get lost; the file gets forwarded.
What about competitor context?
Add it quarterly, not monthly.
Once a quarter it is worth showing what the category is doing: which competitors are running more ads than last quarter, what creative formats they have moved to, and which of their ads have been live long enough to be working. The Meta Ad Library is free and shows every active ad from any advertiser, with a start date on each card, so this costs an hour rather than a budget.
Pulling that into a report is easier if the ads come out as files rather than screenshots. Our free Meta Ad Library Downloader exports a whole Ad Library search as one ZIP with a searchable index and a CSV of every ad's advertiser, copy, and dates, which drops straight into a slide or a sheet.
Keep it to one page. The monthly report is about the account; the quarterly section is about the market, and mixing the two makes both harder to read. The measurement side of the account itself is covered in how to measure Facebook ad performance.
FAQ
What should a Facebook ads report include?
Headline numbers (spend, revenue, ROAS or CPA, versus last period), the top and bottom creative shown as images, a summary of what changed in the account, and two or three specific next actions.
What metrics matter most in a Facebook ads report?
Spend, revenue, and the efficiency metric the business runs on. CPM, CTR, and frequency belong alongside them because they explain why the efficiency number moved.
How often should you report on Facebook ads?
Monthly for clients, weekly for internal review. Anything more frequent encourages reacting to noise, since daily swings on most accounts are variance rather than signal.
How do I show ad creative in a client report?
Screenshot the top performers, put the first line of copy underneath each one, add the single metric that made it a winner, and write one sentence naming what the winners have in common.
Can you export Facebook ads data to Excel?
Yes. Ads Manager exports the current view to CSV or Excel, and saved custom columns keep the export in a consistent shape so the same template works every month.
The Klipio extension adds a download button to every ad in the Meta Ad Library: one click per ad, or bulk-save a whole search as a ZIP with a searchable swipe file inside. Free, no sign-up.
Get the free extension
