Free Facebook Ads Report Template: Excel Download

A Facebook Ads report template saves you from rebuilding the same layout every week and keeps every report answering one question for whoever reads it: did the money work, and what changed. You can download the Meta Ads report workbook, an Excel file that fills from an export you paste in from Ads Manager. To see what a finished report looks like first, there is a sample report, a PDF with made up numbers, and a demo export, a CSV of made up rows you can paste in to try the workbook. The rest of this guide walks through every section of a good report and the exact Meta Ads KPIs that belong in each one, so you can fill it in confidently whether you run ads for your own business or for clients.

What the free template includes

The template is built around the sections a strong report actually needs, not every column Meta will hand you. The three files do different jobs, and only the Excel one is a template you fill.

• PDF. The sample report holds two finished monthly reports for fictional companies, and every number in it is made up. It shows a layout to aim for. You do not fill it in, and it is not a DashOps export. To send your own report as a PDF, save your finished tab as a PDF from Excel.
• Excel. The Meta Ads report workbook has a Monthly report tab and a Weekly report tab, among others. In Ads Manager, export from the Campaigns tab, paste that into the workbook’s Paste your export tab, and the report tabs fill. The line at the top of each report tab says what is ready and what is missing. The monthly charts and the whole Weekly report tab need an export broken down by day, and the period before and change columns need that export to cover two whole months, or both weeks on the Weekly report tab. The How to use tab gives the steps. The file does not update itself, so you paste a fresh export each time. Excel may open a downloaded file in Protected View, so choose Enable Editing before you paste.
• CSV. The demo export is made up rows laid out like an Ads Manager export. Paste them into the workbook to try it before you use your own numbers.

A common pattern is to send a PDF for the narrative and attach your Excel file for anyone who wants to dig in.

Start with the headline numbers

Open the report with the metrics tied to the goal. For most advertisers that is three lines, not thirty.

• Spend and results. What you spent and what you got, side by side. Results means the action you optimized for: purchases, leads, messages, installs.
• Efficiency. Cost per result. That is cost per lead for lead gen (cost per lead = spend / leads) or cost per purchase for e-commerce (cost per purchase = spend / purchases).
• Return. ROAS for sales (ROAS = conversion value / spend), or total pipeline value for lead gen.

Resist the urge to lead with impressions or reach. Those explain the headline; they are not the headline.

Show the trend, not just the total

A single total hides the story. The template includes a trend section because a period-over-period comparison answers the question the reader actually has: is this period better or worse than the last, and by how much.

• Put this month next to last month, or this week next to last week, for every headline metric.
• Add a small trend chart of daily spend against daily results so a spike or a drop is visible at a glance.
• Flag the direction with plain language. “Cost per lead down, lead volume up” tells the reader more than two raw numbers.

If you want a deeper read on which numbers belong together, the Meta Ads KPIs to track post groups all 17 by the story they tell.

Fill in the supporting KPIs

Below the headline, a short supporting set explains why the top numbers moved. In the workbook these sit in the Key numbers table on the Monthly report tab.

• CTR (click-through rate). Link clicks divided by impressions (CTR = clicks / impressions). A falling CTR on a long-running ad is a fatigue signal.
• CPC (cost per link click). Spend divided by link clicks (CPC = spend / clicks). The fastest read on whether traffic is getting expensive.
• CPM (cost per 1,000 impressions). CPM = spend / impressions times 1000. A useful gauge of how competitive your audience and placements are.
• Frequency. Average times each person saw your ad. Rising frequency with falling results is the classic fatigue pattern. The workbook works out frequency once you type in reach from Ads Manager, because reach cannot be added up across rows.

Add breakdowns only where they earn their place

The workbook’s Monthly report tab lists your campaigns, highest spend first, and has a placement table that fills when your export is broken down by placement. It has no age and gender table, so read that breakdown in Ads Manager if you need it. Use these to explain the headline, not to pad the report.

• Top campaigns. The handful of campaigns carrying the spend, with results and cost per result beside each. This is where most of the “what changed” lives.
• Demographic breakdown. Where age or gender performance diverges enough to act on.
• Placement breakdown. Where one placement is quietly draining budget or quietly winning.

If a breakdown does not change a decision, leave it out. A focused report reads as more confident than a long one.

How to judge whether the numbers are “good”

The template deliberately does not print a “good” benchmark next to each metric, because a universal number would mislead you. A ROAS that is profitable for a high-margin product can be a loss for a thin-margin one. The honest way to judge is against your own goal, your own margin, and your own prior period.

• Compare each metric to your break-even, not a generic average. Break-even ROAS = 1 / profit margin is the line that matters for sales.
• Compare to last period’s trend to see direction.
• Note your attribution window and time zone on the report. If the numbers ever look off against Ads Manager, those two settings plus iOS privacy undercounting are the usual reasons, so the What changed box on the workbook’s Monthly report tab is a good place to write them down.

For more on building the report end to end versus pulling exports by hand, the Facebook Ads Manager vs reporting dashboard comparison is a useful companion.

When a template stops scaling

A template is the right starting point. It starts to cost you time once you run more than a couple of ad accounts, or once you send the same report on a schedule, because every send means re-pulling columns, re-formatting, and re-checking the date range. At that point a dashboard reads your key KPIs across your ad accounts in one place with period-over-period comparison built in, and exports a PDF report, with Excel and CSV on higher plans, without the manual rebuild. DashOps does exactly this, including scheduled email digests and, on Growth and Enterprise, white-label client reports. See what each plan includes on the pricing page, and the help center covers setup.

Build your first report from the template, keep only the sections that change a decision, and let the layout stay the same so every report reads the same way.