Skip to content
Free template

Facebook Ads report template

A free, ready-made Facebook Ads report: amount spent, reach, CPM, CTR, purchases and ROAS, by month, placement and age group. Copy the template into Mammoth, connect your ad account, and get the same report on your own data.

14-day Pro trial · No credit card · Viewers are always free

The template: paste this into Mammoth

Facebook Ads report: amount spent, reach, CPM, CTR, purchases and ROAS as KPIs, amount spent and purchase value by month, purchase value by placement, and ROAS by age

Facebook Ads dashboard built in Mammoth, showing Amount spent, Reach, CPM, CTR, Purchases, ROAS
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

In production at

  • Arla Foods logo
  • Bacardi logo
  • British American Tobacco logo
  • Everest Detection logo
  • Golden Acre logo
  • Handlangers logo
  • Inspired Learning Group logo
  • Kantar logo
  • MUFG logo
  • NielsenIQ logo
  • PTI Digital logo
  • RethinkFirst logo
  • Starbucks logo
  • The Specialist Works logo

What is a Facebook Ads report template?

A Facebook Ads report template is a ready-made report for your Facebook and Instagram ads, with the numbers and charts already chosen. You connect your ad account and it fills in with amount spent, reach, CPM, CTR, purchases and return on ad spend, by month, placement and age. It updates from Meta, so the monthly report is ready without an export.

What's on it

What's in the Facebook Ads report template

Six numbers at the top and three charts below them.

Six numbers at the top

Facebook Ads dashboard: Amount spent, Reach, CPM, CTR, Purchases, ROAS
Amount spent
What you paid Meta for the ads.
Reach
How many people saw an ad, summed across the days in the report.
CPM
Cost per 1,000 impressions: amount spent ÷ impressions × 1,000.
CTR
Link clicks ÷ impressions.
Purchases
Purchases Meta attributed to the ads.
ROAS
Purchase value ÷ amount spent.
Facebook Ads dashboard chart: Spend and purchase value by month

Spend and purchase value by month

Spend as bars and purchase value as a line, one point a month.

Facebook Ads dashboard chart: Purchase value by placement

Purchase value by placement

Purchase value from each placement: Feed, Reels, Stories and the rest.

Facebook Ads dashboard chart: ROAS by age

ROAS by age

Return on ad spend for each age group, highest first.

How it works

How to use this Facebook Ads report template

  1. Step 1

    Connect Facebook Ads

    Connect your Facebook Ads account in Mammoth, or upload a report export.

  2. Step 2

    Paste the template

    Copy the sentence at the top of this page into Mammoth. It builds the same dashboard from your data.

  3. Step 3

    Share or schedule it

    Share a link, or have it emailed every week. Viewers are free.

Compare

Facebook Ads report templates compared

This template in Mammoth, Ads Manager's own reports, and a Data Studio template. Data Studio is Google's free report builder, called Looker Studio until recently.

Mammoth template

For a monthly Facebook Ads report you send to clients or your team.

  • ✓Ready-made template
  • ~FreeFree plan for uploaded files
  • ✓Google Ads or Shopify data in the same report
  • ✓Share a link anyone can open
  • ✓Change it by asking in plain words

Ads Manager reports

For checking campaigns inside Meta.

  • ✕Ready-made template
  • ✓Free
  • ✕Google Ads or Shopify data in the same report
  • ✕Share a link anyone can open
  • ✕Change it by asking in plain words

Data Studio template

For a free report when most of your data is Google's.

  • ✓Ready-made template
  • ~FreeMeta needs a paid partner connector
  • ~Google Ads or Shopify data in the same reportNeeds a paid partner connector
  • ✓Share a link anyone can open
  • ✕Change it by asking in plain words

Facebook Ads report template questions

What should a Facebook Ads report include?
Amount spent, reach, CPM, CTR, purchases and ROAS at the top, then spend and purchase value by month, and a breakdown by placement and by age. Add frequency or cost per purchase when you need to find out why a number moved.
Why is reach higher than in Ads Manager?
The report adds up reach for each day, so a person reached on two days counts twice. Ads Manager removes those repeats. Use reach here to compare months, and Ads Manager for the unique number.
How do I use this Facebook Ads report template?
Connect Facebook Ads to Mammoth, or upload a Ads Manager export with placement and age breakdowns as a CSV or Excel file. Then paste the template sentence from the top of this page. Mammoth builds the same numbers and charts from your data.
Is the template free?
The template is free to copy. Building it from an uploaded Ads Manager export with placement and age breakdowns works on Mammoth's free plan. Connecting your Facebook Ads account directly needs a paid plan.
Can I change the template?
Yes. Ask for the change in plain words, such as "add clicks by device" or "show last month only", and Mammoth updates the dashboard.
Can Mammoth connect to Facebook Ads directly?
Yes. Facebook Ads is one of Mammoth's 100+ tested connectors, so the dashboard reads your account rather than an export.
How often does the dashboard update?
Each refresh pulls the latest Facebook Ads data and every number and chart updates. Daily on Team and every 3 hours on Pro, with no copying and pasting.
Can I combine Facebook Ads with other sources?
Yes. Connect Facebook Ads alongside GA4, a CRM or a spreadsheet, join them in Mammoth, and build one dashboard across all of them, for example ad spend against the deals it produced.
Can I share it with clients?
Yes. Share a link or have it emailed on a schedule, and viewers are free on every plan. On the Mammoth Pro plan you can put your own logo and domain on it.
Is the data on this page real?
No. It is sample data for an invented brand, in the same columns a Ads Manager export with placement and age breakdowns uses. The dashboard itself is real: it was built in Mammoth, and you can open it live.

Use this Facebook Ads report template

Connect Facebook Ads, paste the template, and share the dashboard with a link.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free