A good Facebook ads report template answers three questions in order: did we spend to plan, did we get the result we bought, and what changes next week. Report metrics by objective rather than one universal list, add only the breakdowns that explain the movement, and state the attribution setting on the page. Since 2026, Meta’s click-through counts link clicks only and 7-day and 28-day view windows are gone, so flag that on trend charts.
- Eight sections, one page per objective: Sales, Leads, Traffic and Awareness each get their own KPI row.
- Breakdowns that earn space: placement, age and gender, and creative.
- Commentary in four lines: what happened, why, what we will do, what we need.
- Automate the pull with Ads Reporting schedules or a Google Sheets connector.
The weekly report layout
Say you’re handed a new client on Thursday and the first report is due Monday. Don’t start from a dashboard template with 40 tiles. Start from what the client will do with the report, which is usually approve next week’s changes. This layout works for most Meta accounts:
Facebook ads weekly report: eight sections
| What goes in | Source | |
|---|---|---|
| 1. Headline | Three lines: result vs target, spend vs plan, the one thing that changed | You |
| 2. Spend vs plan | Month-to-date spend, expected spend at this point, projected month end per campaign | Ads Manager plus the media plan |
| 3. KPIs by objective | One row per objective with the primary and supporting metrics below | Ads Manager or Ads Reporting |
| 4. Trend | Last 4 to 6 weeks of the primary KPI, week over week | Ads Reporting |
| 5. Breakdowns | Two or three that explain this week’s movement | Ads Reporting |
| 6. Creative | Top and bottom ads by cost per result, with thumbnails | Ads Reporting creative view |
| 7. Tracking note | Attribution setting, any tracking issue, provisional days | Events Manager, Ads Manager |
| 8. Next week | Actions you will take and decisions you need from the client | You |
Metrics by objective
One totals row across a Sales campaign and a Traffic campaign produces a "cost per result" that means nothing. Keep each objective on its own row.
What to report for each Meta objective
| Primary KPI | Supporting metrics | Don’t lead with | |
|---|---|---|---|
| Sales | Purchases, cost per purchase, purchase ROAS | Conversion rate from landing page view, CPM, adds to cart | CTR or clicks (all) |
| Leads | Leads, cost per lead, qualified leads from the CRM | Cost per qualified lead, CPM, link CTR | Clicks (all) |
| Traffic | Landing page views, cost per landing page view | Link CTR, engaged sessions in GA4 | Clicks (all) |
| Awareness | Reach, frequency, CPM | ThruPlays, ad recall lift where available | Link clicks |
| App promotion | Installs and in-app events from your MMP | Cost per install, cost per event | Clicks |
Clicks (all) includes clicks that never leave Meta, such as on the Page name or to expand text, which is why it flatters weak ads. Use link clicks or landing page views for traffic.
Breakdowns that matter, and ones that mislead
- Placement and platform: shows how much went to Reels, Stories and Feed and where the results came from. The first thing to check when cost per result moves.
- Age and gender: useful when the client has a clear buyer; often shows that spend drifted into a cheap segment that doesn’t convert.
- Creative: Ads Reporting has a creative-level view; pair it with thumbnails so the client sees what worked.
- Region and time of day, with care: Meta’s region and hourly breakdowns don’t return off-Meta (website) conversions, and hourly breakdowns have no reach or frequency. A region chart showing zero purchases is a data limit, not a finding.
Attribution: say it on the page
Every Meta report should name the attribution setting, because it changed in 2026. Meta’s standard attribution now counts click-through events within 1 or 7 days of a link click, view-through within 1 day of an impression, and engage-through within 1 day of a non-link click or a 5-second video play. Meta announced the link-click-only definition in March 2026 and notes some accounts may still use the earlier versions during rollout. Separately, the 7-day view and 28-day view windows stopped returning data in the Insights API from 12 January 2026, so connector templates that used them need rebuilding.
A week-over-week chart that spans the attribution change compares two different definitions of a click conversion. Add a note on the chart, or start the trend after the switch.
Also say which source is the truth for the client: Ads Manager for in-platform optimisation, GA4 for site behaviour, the CRM or MMP for leads and installs. Why they differ is covered in GA4 vs Facebook Ads conversions.
Commentary clients read
Four lines per section, in this order:
- What happened: the KPI against target and last week, in one sentence.
- Why: the driver you found in the breakdowns (a creative, a placement, a market, a tracking issue).
- What we will do: the change, with the date.
- What we need: approvals, new creative, stock or landing page fixes.
Example, with no numbers invented: "Cost per lead rose this week because the two newest videos took most of the spend in Reels and converted worse than the static. We will cap them by moving budget back to the static ad set on Tuesday. We need two new static concepts by Thursday."
Build it in Ads Manager
Schedule a weekly Facebook ads report in Ads Reporting
Meta’s Ads Reporting can build, export, share and email a recurring report.
- 01
Create the report
Open Ads Reporting from Ads Manager and create a custom report for the ad account.
- 02
Add metrics and breakdowns
Pick the KPIs for each objective from the table above and the two or three breakdowns you need.
- 03
Filter and sort
Filter by objective or campaign name so each section is one objective; sort by spend or cost per result.
- 04
Schedule the email
Set the report to be emailed on a recurring basis, for example every Monday morning, to you and the team.
- 05
Export when needed
Export to a spreadsheet for the client deck, or share a link with people who have access to the ad account.
Scheduled emails work on single-account reports, and Ads Reporting doesn’t hold your plan or your commentary. Most agencies end up in a spreadsheet for that, which is where the next section comes in.
Where this goes wrong
- Averaging ratios. The average of seven daily CTRs is not the week’s CTR. Recalculate ratios from summed clicks and impressions.
- Names instead of IDs. A renamed campaign shows up as two rows. Join on campaign ID and display the current name.
- Final numbers for the last two days. Conversions keep arriving after the click, and server events can arrive days later. Mark the latest days as provisional.
- One blended cost per result. Mixing lead, traffic and sales results hides every problem. Keep objectives apart.
- Platform conversions as the business number. If the client counts leads in a CRM or installs in an MMP, report that number first and Meta’s second.
Do it faster with Whathead
Whathead is our product. The Whathead Google Sheets add-on pulls Facebook and Instagram data into a sheet: 286 Meta metrics and 104 dimensions, up to 100 ad accounts per query, with breakdowns such as age, gender, country, region, placement and device. The conversion window defaults to each ad set’s own attribution setting, as in Ads Manager, and ratios are recalculated from their parts so totals add up. Queries refresh on a schedule (up to five per spreadsheet, run on Whathead’s servers), so the Monday sheet is ready before you open it. TikTok, Snapchat, Google Ads and GA4 sit in the same spreadsheet, and the same data reaches Looker Studio through the Looker Studio connector. The public Marketplace listing is pending, so access is through Whathead support for now.
For the commentary, Claude or ChatGPT can draft from live data through the Whathead MCP server:
- "For this Meta ad account, compare last week with the week before by campaign: spend, results, cost per result, CPM and conversion rate. Then break the biggest change down by placement and by ad, and draft the four-line commentary for each objective."
This is read-only: Whathead reads insights and changes nothing in Meta. If the commentary leads to a change, any edit you ask for comes back as a dry-run preview first. For the Snapchat version of this report, see the Snapchat ads report template.
Facebook ads report template: common questions
What should be in a Facebook ads report?
A headline, spend against plan, KPIs by objective, a 4 to 6 week trend, two or three breakdowns, top and bottom creative, a tracking and attribution note, and next week’s actions and client asks.
Can I schedule Facebook ads reports by email?
Yes. Meta’s Ads Reporting lets you create a report and schedule it to be emailed on a recurring basis to you and colleagues with access to the ad account.
What is the difference between link clicks and clicks (all)?
Link clicks are clicks to the ad’s destination. Clicks (all) also counts clicks that stay on Meta, such as on the Page name or to expand text, so it is always higher.
Why don’t Ads Manager numbers match GA4?
They count differently: Meta attributes conversions to ad clicks, engagements and views within its windows, while GA4 uses its own attribution and only sees tagged sessions it can match. Pick one source of truth per KPI and say so in the report.
Which attribution setting should the report use?
The one each ad set optimises on, which is what Ads Manager shows by default. Write it on the report, and note that Meta’s click-through counts only link clicks since its 2026 change.
Sources
- Meta Business Help Centre: About the attribution setting, About Meta Ads Reporting
- Meta for Developers: Insights API breakdowns
- Meta: Click attribution update; Meta for Developers: Ads Insights API metric availability updates
- All checked 19 November 2026.
Written by Ahmed Shahin, founder of Whathead. Last reviewed 19 November 2026.
Put the Monday report on a schedule
Pull Meta, TikTok and Snapchat into one Google Sheet with Ads Manager-matching attribution and refreshes that run without you.



