View All Resources

Facebook Ads Report Template (Free Google Sheets Download)

A free Google Sheets template for Facebook and Meta ads reporting, with a seven-step setup for tracking spend, ROAS, and creative performance.
Resources
.
31 Oct 2025
.
4 min read
Jesse Pujji, Co-Founder and Chairman of GrowthAssistant
Jesse Pujji
,
Co-Founder and Chairman
Check Badge
Fact checked
Rolled paper scrolls on a blueprint grid, symbolizing a Facebook ads reporting template.Team meeting

A Facebook ads report template is a spreadsheet that pulls your Meta Ads Manager data into one view, so you can track spend, ROAS, CPA, and creative performance without digging through tabs. This guide gives you a free Google Sheets template and shows how to set it up in seven steps.

It is built for founders, media buyers, and marketing leads who manage several campaigns at once and want daily answers to two questions: where is the budget going, and which ads are working?

What Is a Facebook Ads Report Template?

A report template turns raw exports from Meta Ads Manager into a consistent scorecard. Instead of rebuilding a report every week, you paste fresh data into the same sheet, and formulas update the dashboard for you.

A good template covers three layers:

  • Financial results: amount spent, purchases, revenue, ROAS, CPA, and AOV.
  • Funnel metrics: impressions, link clicks, CTR, adds to cart, and checkouts initiated.
  • Creative signals: thumbstop rate, ThruPlays, and video watch time, which explain why an ad wins or loses.

Why Use a Template Instead of Ads Manager Alone?

Meta Ads Manager holds all the data, but it is not built for quick comparisons across periods.

Meta's own Ads Reporting templates help, but many teams still need custom formulas, color-coded comparisons, and a view their leadership can read in a minute.

A shared template also creates one language for the team. When the media buyer and the CEO look at the same scorecard, discussions move from "which number is right?" to "what should we change?"

If you want the bigger picture on reporting workflows, our Meta ads reporting guide covers naming, attribution, and daily reporting norms. This template is the hands-on tool that goes with it.

How to Set Up Your Facebook Ads Report Template

Start by downloading the free template from this page and making a copy in Google Sheets (File, then Make a copy). Then follow these steps.

Step 1: Export Your Data from Meta Ads Manager

In Ads Manager, choose a date range long enough for the comparisons you want. For month-over-month views, export at least the last 60 days, broken down by day.

Click Columns, then Customize Columns, and include:

  • Campaign, ad set, and ad name
  • Amount spent
  • Purchases and purchase conversion value
  • Checkouts initiated, adds to cart, link clicks, and impressions
  • 3-second video plays and ThruPlays

Save the columns as a preset so future exports take seconds. Sort dates from oldest to newest, then export the report as a CSV file.

Thumbstop rate is not a default column. The template calculates it as 3-second video plays divided by impressions, multiplied by 100.

Step 2: Paste Your Data into Google Sheets

Open the raw data tab and paste the CSV. Formulas in the template calculate ROAS, CTR, CPA, and AOV automatically.

Keep the column headers exactly as Ads Manager exports them. If a header changes, the formulas that reference it will break.

Tip: add a small color-coded cell that turns green once the day's data is pasted, so the team knows the report is ready.

Step 3: Build the Performance Dashboard

The dashboard tab compares periods side by side:

  • Yesterday vs. the day before
  • Last 3 days vs. the previous 3 days
  • Last 7 days vs. the previous 7 days
  • Month over month

Use green for improvements and red for metrics that need attention. If you see errors like #DIV/0! or #REF!, check the formula references and the data range first.

Step 4: Review Creative Performance

Data is most useful when it tells you what to change. In the creative benchmarks tab, compare each ad against simple starting thresholds:

Metric Starting benchmark If it is below benchmark How to improve
Thumbstop Rate 25 to 30% The hook is not strong enough Change the first 3 to 5 seconds
Video Play Time 3+ seconds The ad is not engaging Show the product sooner
CTR (Click-Through Rate) 0.8 to 1%+ The message is unclear Add a stronger call to action

Treat these as starting points, not rules. After a few weeks, replace them with your own account averages, which are a better baseline for your audience and offer.

Step 5: Use Consistent Naming Conventions

Clear names make the report easy to filter. Use one format for campaigns, ad sets, and ads, and apply it every time.

Example format: Date_TargetingType_Objective_Theme_Test

Example output: 101423_Prospecting_Purchase_TopAds_Evergreen

With consistent names, you can compare prospecting and retargeting, or one creative theme against another, with a simple filter.

Step 6: Automate Your Date Tracking

In the date legend tab, formulas like =TODAY() update reporting dates automatically. Include yesterday's date, the start and end of the current month, and days remaining in the month.

Days remaining is especially useful for budget pacing: compare spend to date against your monthly budget to see if you are over or under plan.

Step 7: Review and Share with Your Team

Share the template with everyone who makes decisions on ads, and review it on a fixed schedule. Daily checks suit brands spending heavily or scaling fast; weekly reviews suit smaller budgets.

Look for patterns such as:

  • Changes in CTR or ROAS
  • Campaigns spending heavily with weak results
  • Creatives whose performance is fading as frequency rises

What to Include in a Facebook Ads Report

  • Spend and pacing: amount spent against budget for the day, week, and month.
  • Results: purchases or leads, revenue, ROAS, and CPA.
  • Funnel health: CTR, adds to cart, and checkout rate, to show where people drop off.
  • Creative performance: thumbstop rate, watch time, and top and bottom ads.
  • Notes and next steps: what changed, why, and what the team will test next.

The notes section matters most for leadership. Numbers show what happened; a short written takeaway shows what to do about it. To bring Meta data together with other channels, see our guide on how to build a marketing dashboard.

Who Should Maintain Your Facebook Ads Report?

A template saves time only if someone updates it on schedule. Daily exports, pasting, checking formulas, and writing a summary take a few focused minutes each day, and they are easy to skip when the team is busy.

Many teams hand this routine to a dedicated data and reporting analyst or a paid social specialist who also manages the campaigns. For a sense of the budget involved, see our breakdown of Facebook advertising management costs.

For campaign strategy beyond reporting, our guide to social media ads covers launching, testing, and scaling on Meta and other platforms.

Start Tracking Your Facebook Ads Today

Download the free template, run your first export, and you will have a working dashboard the same day. With consistent naming and a regular review, the sheet becomes your single source of truth for where your budget goes and which ads deliver.

Jesse Pujji, Co-Founder and Chairman of GrowthAssistantAndy Wells
Jesse Pujji
Co-Founder and Chairman

I’m Jesse, a founder and investor who bootstrapped my first company, Ampush, to a mid 8-figure exit after managing $1BN+ in media spend and partnering with brands like Uber and Hulu. Today, I build businesses at my venture studio Gateway X, with a portfolio that includes GrowthAssistant, Aux Insights, and Unbloat. I also share insights on sales, finance, and leadership in my newsletter Bootstrapped Giants—follow me on LinkedIn if you’re into entrepreneurship, growth, or ecom.

Table of contents

Frequently asked questions

What is a Facebook ads report template?
What should be included in a Facebook ads report?
Can I build a Facebook ads report in Google Sheets without advanced skills?
How often should I update my Facebook ads report?
Does Meta Ads Manager have built-in report templates?
Green blurred background

Explore more

View all
Green AI robot holding binoculars, symbolizing GEO monitoring and tracking brand visibility in AI searchRight up Arrow
Resources
.
20 Aug 2026

Show Up on LLM Search: The Guide to Win Quick w/ GEO

Influencer outreach playbook cover image for DTC gifting campaignsRight up Arrow
Resources
.
04 Dec 2025

Influencer Outreach Playbook: How DTC Brands Run High-Performing Gifting Programs

Right up Arrow
Resources
.
20 Nov 2025

Meta Ads Reporting Guide: Clean Data, Benchmarks, and Daily Reports