Monthly ads performance report template
Enter two months of numbers and ROAS, CPA, AOV and month-on-month change calculate themselves. Add platform results and recommendations, then download Excel and Word.
- Excel & Word
- Free
- 7sections
What is the Monthly Ads Performance Report Template?
A monthly ads report answers three questions on its first page: what happened, why, and what we do next.
An Excel file with KPIs and platforms on live formulas, and a Word file with the full report for management.
Who is it for?
- Campaign managers reporting monthly to management or a client.
- Store owners who want to know if their ads are really improving.
- Agencies and freelancers who need the same report structure every month.
What is inside the template?
These are the sections of the file you download, with their fields, table columns and an example for each table.
- 01
Report details
- Store or account
- Report month
- Prepared by
- 02
KPI table
Enter both months in the boxes. Derived KPIs and change are calculated for you.
KPI Last month This month Change % Ad spend (SAR) 40,000 46,000 auto Revenue (SAR) 128,000 172,500 auto Orders 640 780 auto + 11 more rows - 03
Platform performance
This month’s numbers from each platform’s ads manager. Each platform credits itself, so the total can exceed store revenue.
Platform Spend Revenue Orders ROAS CPA Snapchat 16,000 52,000 260 auto auto Calculated for you: Total
- 04
Top campaigns and creatives
Campaign or creative Platform What worked? Size try-on video Snapchat A direct question as the two-second hook - 05
What worked and what needs fixing
- Wins this month
- Problems and challenges
- 06
Recommendations
Recommendation Owner Due Move 20% of the TikTok budget to Google Shopping Campaign manager Week one - 07
Executive summary
Three lines management reads first.
- What happened
- Why
- What next
How to fill in the template
- 01
Enter both months
Spend, revenue, orders, impressions, clicks and customers. Derived KPIs calculate themselves.
- 02
Add each platform
This month’s numbers from each platform’s ads manager.
- 03
Write what worked and what needs fixing
Top campaigns and creatives, and the problems, plainly.
- 04
Close with the summary and actions
What happened, why and what next, then recommendations with an owner and a date.
Fill in the template and download it
Write what you know now and leave the rest. What you type stays in your browser and goes into the file in Takteek branding. Download it empty to get the blank template.
Free after you add your name, email, mobile, role and country once; we also email you a copy.
The file could not be prepared. Refresh the page and try again.
Guide and examples
What should a campaign performance report include?
| Section | Question it answers | What goes in it |
|---|---|---|
| Executive summary | What happened, why, what next? | Three lines a manager reads in a minute. |
| Key metrics | Is the account better than last month? | Spend, revenue, ROAS, orders, CPA, AOV, CTR, conversion rate, new and returning customers. |
| Platform performance | Where does the money go, and where does it come back? | Snapchat, TikTok, Google and Meta: spend, revenue, ROAS, CPA and share of spend. |
| Top campaigns | What should we repeat? | The campaign, its platform, its return and why it worked. |
| Wins and problems | What changed in execution? | Short points, not paragraphs. |
| Recommendations | Who does what, by when? | An action, an owner and a date. |
Reading the arrows: direction is not meaning
The arrow shows which way a number moved; the colour shows whether that is good. Higher revenue is teal, higher CPA is red and lower CPA is teal. Spend is neutral: more spend is neither good nor bad on its own, and the verdict comes from ROAS and CPA.
| Metric | Formula | Better if |
|---|---|---|
| ROAS | revenue ÷ spend | Higher |
| CPA | spend ÷ orders | Lower |
| AOV | revenue ÷ orders | Higher |
| CTR | clicks ÷ impressions | Higher |
| Conversion rate | orders ÷ clicks | Higher |
| Change % | (this month − last month) ÷ last month | Depends on the metric |
Worked example: a hypothetical abaya store in Ramadan
| Metric | Last month | This month | Change |
|---|---|---|---|
| Spend | SAR 40,000 | SAR 46,000 | +15.0% |
| Revenue | SAR 128,000 | SAR 172,500 | +34.8% |
| ROAS | 3.20x | 3.75x | +17.2% |
| Orders | 640 | 780 | +21.9% |
| CPA | SAR 62.50 | SAR 58.97 | −5.6% |
| AOV | SAR 200 | SAR 221.15 | +10.6% |
From these numbers the summary’s “Why” line reads: “Main drivers: average order value up 10.6% and cost per order down 5.6%.” The platform section adds: “Google returned the most (5.17x ROAS), TikTok the least (2.70x).”
Numbers are for a hypothetical store, for illustration only; they are not client results or market averages.
Platform revenue or store revenue?
Each platform credits itself with an order when the buyer saw or clicked its ad inside the attribution window. If a shopper watches a Snapchat ad, then searches on Google and buys, both platforms may count the same order, so platform revenue can add up to more than the store made. Judge the whole account on store or GA4 revenue in the KPI sheet, and use platform numbers to compare platforms with each other. Standardise your campaign links with the UTM link builder so GA4 can see where each order came from.
Want a marketing performance dashboard that updates itself every day? Connect your ad accounts and GA4 to Google’s Looker Studio and use this template as the structure of the monthly report: the dashboard is for daily monitoring, the report is for decisions.
What to do after the report
If ROAS fell, check it is still above break-even with the ROAS & break-even calculator. If you plan to scale, see what the extra budget buys in the ad cost calculator. If CTR dropped, refresh copy with the ad copy generator. For the month ahead, use the marketing plan template.
Notes: example numbers are for a hypothetical store, not client results or market averages. Formulas are standard definitions: ROAS = revenue ÷ spend, CPA = spend ÷ orders.
Frequently asked questions
How do I write an ad campaign performance report?
Open with three lines: what happened in numbers, why, and what you will do next. Then a KPI table against last month, performance by platform, top campaigns, and recommendations with an owner and a date. The template on this page follows that order.
Which metrics belong in the monthly report?
Spend, revenue, ROAS, orders, cost per order (CPA), average order value, click-through rate (CTR), conversion rate, and new versus returning customers where you have them.
Why is platform revenue different from store revenue?
Each platform credits itself with an order when the buyer interacted with its ad, so one order can be counted by more than one platform. Use store or GA4 revenue to judge the whole account.
Is a lower CPA always good?
Usually, but read it next to orders and revenue. A lower CPA with far fewer orders can mean the campaigns stopped reaching new buyers.
Can I use this template with Looker Studio?
Yes. Keep a Looker Studio dashboard for daily monitoring and use this template as the monthly report you send to management; the Excel file keeps each month’s numbers for later comparison.
Is the template free, and is there a blank version?
Yes. Filling it in and the calculations on the page are free. Downloading the Excel or Word file asks once for your name, email, mobile, role and country. Download without filling in to get a blank copy with the formulas.
Related templates and tools
- UTM Link BuilderConsistently named campaign links per platform, so GA4 shows where every order came from.
- ROAS & Break-even CalculatorLowest ROAS that keeps you profitable, your max cost per order and real profit from ads.
- Ad Cost CalculatorWhat your budget buys on Snapchat, TikTok, Google and Meta, or what your target needs.
- E-commerce Feasibility Study TemplateOrder margin, break-even point and a 12-month forecast, on ready formulas.
Takteek services that help here
Talk to Takteek
Want a team that runs your campaigns and writes this report every month?
We run your campaigns on Snapchat, TikTok, Google and Meta, and send a monthly report with numbers and decisions.
- A plan built on your numbers
- One team for ads, content and store
- Free consultation, no commitment


