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.
.webp)







