GuidesMeta ads

How to build a Facebook ads report

A good Facebook ads report answers one business question at one level, with the right columns, a consistent attribution setting, and a comparison to last period. Build it in Ads Manager, save it as a custom report, schedule it by email, and add two lines on what changed and what you will do next.

Updated November 16, 20266 steps5 min read

Audit my Meta ads →

$1 today. Cancel anytime before day 7.

A weekly Meta ads report
  1. 1Write the questionAre ads producing profitable sales or leads this week?
  2. 2Verify trackingConfirm purchase or lead events fire before reading numbers.
  3. 3Choose columns and levelPick campaign, ad set, or ad, then results, spend, and cost.
  4. 4Add a breakdownSplit by placement, age, or day only if it answers the question.
  5. 5Save and scheduleSave the report and email it on a fixed day.
  6. 6Write the takeawayTwo lines: what changed, and the next action.
On this page
  1. Start with the question, not the dashboard
  2. Check tracking before you trust the numbers
  3. Build the report in Ads Manager
  4. Read it the same way every week
  5. Reporting mistakes to avoid
  6. Automate the routine part
  7. Questions

Start with the question, not the dashboard

A report that lists every metric is a spreadsheet, not a report. Write the question first: is spend turning into profitable sales or leads, which campaign is most efficient, and what changed since last week. Everything you add after that either answers it or comes out.

Decide the level of analysis too. Meta reports at the account, campaign, ad set, and ad levels. Compare campaigns when you are deciding where to put budget, ad sets to judge audiences, and ads to judge creative. Mixing levels in one table is how a report becomes unreadable.

Check tracking before you trust the numbers

If the pixel or Conversions API drops events, every cost-per-result figure is wrong in a confident-looking way. In Events Manager, confirm your purchase or lead event is firing, that browser and server events are deduplicated, and that the numbers roughly match your store or CRM. A small gap is normal; a large one needs fixing before you report on it. See Meta Conversions API and Facebook ads vs GA4.

Then fix the attribution setting for the report. Meta’s default is a seven-day click and one-day view window, and your ad sets may be optimizing to a different one. Whichever you choose, use it every week so the trend means something. The options are explained on Meta attribution settings.

Want this checked in your Meta account?

Reads your campaigns, ad sets, ads and pixel health. Every change waits for your approval.

Build the report in Ads Manager

In Ads Manager, open Reports, create a custom report, and choose the date range and level. Pick a short set of columns: amount spent, results, cost per result, and for ecommerce purchase conversion value and ROAS. Add reach and frequency, plus link clicks and CTR, only if they inform a decision. Save the column preset you like so every report starts consistent.

Add breakdowns one at a time. Placement and day are useful for diagnosing; age, gender, and region are useful for budget calls. A breakdown makes the table longer, so use it when it earns the space. Include a comparison to the previous period so a number has context. Then save the report, and use the schedule option to email it on a set day, with an export to a file if someone else needs it.

Read it the same way every week

Start with the headline metric, then look at what drove it. If cost per result rose, check whether CPM rose, whether click-through rate fell, or whether the conversion rate after the click dropped. Each points somewhere different: auction pressure, creative, or the landing page. A short set of checks beats a long list of metrics.

Keep a column for the action you took last week and the one you will take next. Reports that end in a decision get read; reports that end in a table do not. For the full structure of a recurring one, see the weekly marketing report, and for several channels at once, the cross-channel report.

Reporting mistakes to avoid

The most expensive mistake is trusting numbers before checking tracking. If purchase events are duplicated or missing, a report can look healthy while the account bleeds. Spot-check a week of Meta conversions against orders in your store or leads in your CRM before the report goes anywhere.

The second is changing the window or the columns between reports. A seven-day click window one week and a one-day view window the next produces a trend that is just noise. Save the column preset and note the attribution setting on the report itself, so anyone reading it knows what they are looking at.

The third is reporting averages that hide the story. A blended cost per result can look stable while one campaign collapses and another carries it. Check at least the top three campaigns or ad sets by spend, and look at the trend by week rather than one total. Last, avoid vanity: reach and impressions answer whether people saw the ad, and a business report has to answer whether it paid back. Lead with results and cost, and push the rest to an appendix for anyone who asks.

Automate the routine part

A scheduled email gets the numbers to people. It does not tell them what the numbers mean. If you report to a client or a boss, add the interpretation by hand or with an assistant, and keep each takeaway to a couple of sentences. A shared dashboard can work for always-on viewing, but it is no substitute for the weekly note.

The part you can hand off: Sprites can run a weekly performance review on a schedule across your connected ad accounts, covering Meta alongside Google and LinkedIn, and write up what moved. It reads the accounts and proposes changes as approval cards, so the report ends in decisions you can approve. More on marketing dashboards.

Questions

How do I create a custom report in Facebook Ads Manager?

Open Reports in Ads Manager, create a new report, choose the date range and level, pick your columns and breakdowns, and save it. You can then schedule it by email or export it as a file.

What should be in a Facebook ads report?

Spend, results, cost per result, and for stores conversion value and ROAS, compared to the previous period. Add a breakdown only when it answers a question, and finish with what changed and what you will do next.

Why do my Ads Manager numbers differ from my store or CRM?

Attribution windows, view-through credit, blocked tracking, and timing all create gaps. Meta counts conversions it attributes to ads in its window, while your store counts every sale. Use Meta for trends and your own system for the total. See Facebook ads vs GA4.

Can I schedule a Facebook ads report?

Yes. Save a custom report in Ads Manager and use its schedule option to email it daily, weekly, or monthly, so the same view arrives on the same day.

Keep going

Have Sprites do this in your Meta account

  • Reads your campaigns, ad sets, ads and pixel health
  • Drafts budget, audience and creative changes as cards
  • Every change waits for your approval