Facebook ads report template: weekly and monthly, ready to copy
A good Facebook ads report has four parts: the setup (dates, account, attribution), a short table of spend, results and cost per result, a breakdown by campaign and ad, and a plain 'what we did, what we learned, what we do next' section. Copy the weekly and monthly templates below.
A useful Facebook ads report template has four parts: the setup (which account, which dates, which attribution setting), one small table of the numbers that matter, a breakdown by campaign and ad, and a short written section that says what you did, what you learned and what you will do next. Below are a weekly and a monthly version you can copy into a doc, a spreadsheet or an email, plus prompts that get ChatGPT or Claude to fill them in from your exported data.
Most report templates online are dashboard files tied to a paid connector. This one is plain text and tables, so it works whatever tool you use, and the same structure works as a Google Ads report template or any other PPC report template if you swap the numbers.
Start with the setup block
Every report should open with four lines. Without them, numbers from two reports cannot be compared, and someone will eventually ask why your totals differ from what they see in Ads Manager.
Account: [ad account name]
Period: [start date] to [end date], [time zone]
Compared with: [previous period]
Attribution setting: [for example 7-day click, 1-day view]
Goal: [leads / online sales / bookings / traffic]
AdManage's guide to Facebook ads reporting tools makes the same point: record the account, date range, time zone, currency and attribution setting so periods and tools are comparable.
The numbers that go in (and what each means)
Pick the rows that match your goal. A report with 30 metrics hides the three that matter.
| Number | What it means in one line | Include when |
|---|---|---|
| Amount spent | What you paid Meta in the period | Always |
| Results | The thing you want: leads, purchases, bookings | Always |
| Cost per result | Amount spent divided by results | Always |
| Purchase value | Sales value Meta tracked from the ads | You sell online |
| Return on ad spend (ROAS) | Purchase value divided by amount spent | You sell online |
| Reach | How many different people saw the ads | Always |
| Frequency | Average times each person saw them | Always |
| Impressions | Total times the ads were shown | Optional |
| Link click rate (CTR) | Share of impressions that led to a link click | Always |
| Cost per link click (CPC) | Amount spent divided by link clicks | Traffic or lead goals |
| Cost per 1,000 impressions (CPM) | What it costs to be seen | Awareness goals |
Two rules keep this table honest. First, calculate cost per result as total spend divided by total results, not as an average of each row's cost per result; the AdManage guide above flags the same trap. Second, if leads are your goal, add a line for qualified leads from your CRM or inbox. Meta counts form fills, not good customers.
There is no single "good" cost per result. It depends on your industry, offer and country. Compare each period with your own previous period and with what a customer is worth to you. Our guide to how much Facebook ads cost explains how to work out the number you can afford.
Weekly report template
Keep it to one screen. The weekly report answers one question: is anything wrong, and is the money going to the right places?
FACEBOOK ADS: WEEK OF [DATE]
Summary
- Spent [$X] and got [N results] at [$Y] per result (last week: [$Y2]).
- Best ad: [name], [N results] at [$Y].
- Problem: [ad or ad set] spent [$X] with [no / few] results.
Changes made this week
- [Paused / launched / changed budget on ...]
Next week
- [One to three actions]
| Campaign | Spent | Results | Cost per result | CTR | Frequency | Note |
|---|---|---|---|---|---|---|
| [name] | [scale / keep / watch / stop] | |||||
| [name] | ||||||
| Total |
The Note column is where a weekly report earns its keep. Use four or five short labels such as scale (cheap results, could take more budget), keep (doing its job), watch (frequency climbing or clicks falling), stop (spent enough to judge with nothing to show) and too early (not enough spend to judge yet).
Monthly report template
The monthly report is for decisions. It adds trends, the best and worst ads, and who the ads reached.
FACEBOOK ADS: [MONTH YEAR]
1. Summary (3 to 5 sentences)
2. Results vs last month (table)
3. Campaign breakdown (table)
4. Top 3 and bottom 3 ads (table with ad name, spend, results, cost per result)
5. Audience and placement: who saw the ads (age, gender, country, placement)
6. What we did
7. What we learned
8. What we do next month (with budget)
| Number | This month | Last month | Change |
|---|---|---|---|
| Amount spent | |||
| Results | |||
| Cost per result | |||
| ROAS (if online sales) | |||
| Reach | |||
| Frequency | |||
| CTR |
Whatagraph's Facebook ads report template suggests the same order: insights and recommendations first, then the period comparison, then breakdowns by campaign, ad set, creative and placement. Match the extra sections to the goal: lead quality for lead campaigns, ROAS for shops, reach and frequency for awareness.
How to write "what we did, what we learned, what we do next"
This is the part your boss or client actually reads. Write it in full sentences, with one number per sentence at most.
What we did. List the real changes, with dates. "On the 8th we paused two ads that had spent $60 with no bookings and moved that budget to the spring offer ad."
What we learned. One to three findings, each tied to evidence. "The spring offer ad brings bookings at about half the cost of the others. People aged 45 and over book more than younger people at the same spend." Avoid guesses dressed up as findings. If a test has not run long enough, say "too early to tell."
What we do next. Specific, with a budget and an owner. "Next month: raise the spring offer ad from $20 to $30 a day, test two new images against it, and review on the 15th."
A finished example for a small business:
In October we spent $612 and got 41 booking requests at about $15 each, a little cheaper than September. The spring offer ad did most of the work. We paused two ads that spent $60 with no bookings. Next month we will raise the spring offer budget and test two new images against it.
(The figures in this example are made up to show the format.)
Common mistakes
- Mixing settings between reports. A different date range, time zone or attribution setting changes every number. Keep the setup block the same each time.
- Leading with vanity numbers. Impressions and reach look big but do not pay bills. Put results and cost per result first.
- Averaging averages. Recalculate cost per result and CTR from totals.
- Judging too early. An ad with $5 spent and no results is not a failure yet. Mark it "too early."
- Ignoring frequency. When the same people see an ad again and again, results usually get more expensive. Note it before it shows up in cost.
- No next step. A report that ends with a table and no decision gets read once and forgotten.
- Reporting Meta's numbers as sales. Check results against your real sales or bookings when you can.
Build the report with ChatGPT or Claude from an export
You do not need a paid reporting tool to fill in the templates above. In Ads Manager, open the campaigns view for your date range, add the columns from the table above, and export the report as a CSV or Excel file. Do it at campaign level and again at ad level. Then upload the files to ChatGPT or Claude and use prompts like these:
- "This is my Facebook ads export for [dates]. Fill in this weekly report template with it. Calculate cost per result as total spend divided by total results. [paste template]"
- "Compare these two exports, last month and this month, and fill in the 'This month, Last month, Change' table."
- "From the ad-level file, list the 3 ads with the lowest cost per result and the 3 that spent the most with the fewest results."
- "Label each ad scale, keep, watch, stop or too early, and give one plain reason for each."
- "Write the summary in 4 sentences for a business owner with no marketing background. Use at most one number per sentence."
- "Write 'what we did, what we learned, what we do next' from these notes: [your notes on changes made]."
Always check the AI's totals against the file. Language models can misread columns or round numbers, and a client who spots one wrong figure stops trusting the rest. Ask "Show me how you calculated the total spend" if anything looks off.
Skip the export: ask your ad account directly
If you do this every week, the export step gets old. AskAds connects your Meta ad account to ChatGPT or Claude, so you can ask "How are my Facebook ads doing this week?" and get spend, results, cost per result, click rate, frequency and more for any date range up to 3 years, in the ad account's own time zone. Every campaign, ad set or ad gets a verdict with a plain reason: scale, keep, watch, stop or too early.
You can then paste the answer into the templates above. A few limits to know: AskAds does not send scheduled or emailed reports, has no dashboards or exports, and has no built-in comparison (ask "Compare this month with last month" and the AI runs two reports and compares them). If you act on a "stop" verdict, pausing happens right away; raising a budget waits for you to press Approve. Setup steps are on the ChatGPT and Claude pages, and plans are on the pricing page.
The bottom line
Keep the setup block fixed, report a handful of numbers tied to your goal, label every campaign with a clear next step, and put the plain-words summary first. Whether you fill it in by hand, from an export with ChatGPT, or by asking your ad account directly, the structure is what makes the report useful. For the Google side of your account, use the same structure alongside our Google Ads audit checklist.
Availability: connecting Meta (Facebook and Instagram) is not open to the public yet. Each ad platform reviews AskAds before it allows public connections, and we switch each one on the day that review is done. See what is open today.
Questions
What should a Facebook ads report include?
The date range and attribution setting, spend, results, cost per result, return on ad spend if you sell online, click rate, cost per click, reach and frequency, a breakdown by campaign and ad, and a short written section on what happened and what you will do next.
How do I write a Facebook ads report for a client?
Lead with three to five plain sentences: what you spent, what it brought in, what worked, what did not and what you will change. Put the tables after the summary so the client reads the conclusions first.
How often should I send a Facebook ads report?
Weekly for a short check on spend and results, monthly for a fuller review with trends and decisions. Small accounts often get a monthly report only, because a week of data is too thin to judge.
Can ChatGPT make a Facebook ads report?
Yes. Export your campaign and ad data from Ads Manager as a CSV file, upload it to ChatGPT or Claude and ask for a report in the structure below. Check every number it gives you against the file.
Is there a free Facebook ads report template?
Yes. The weekly and monthly templates on this page are free to copy into a doc, a spreadsheet or an email.
Ask your ads anything
Add AskAds to ChatGPT or Claude and ask your first question. Nothing spends until you press Approve.
Free for 7 days. No card needed to start.