Skip to content

Templates & Plans

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.

  1. 01

    Report details

    • Store or account
    • Report month
    • Prepared by
  2. 02

    KPI table

    Enter both months in the boxes. Derived KPIs and change are calculated for you.

    KPILast monthThis monthChange %
    Ad spend (SAR)40,00046,000auto
    Revenue (SAR)128,000172,500auto
    Orders640780auto
    + 11 more rows
  3. 03

    Platform performance

    This month’s numbers from each platform’s ads manager. Each platform credits itself, so the total can exceed store revenue.

    PlatformSpendRevenueOrdersROASCPA
    Snapchat16,00052,000260autoauto

    Calculated for you: Total

  4. 04

    Top campaigns and creatives

    Campaign or creativePlatformWhat worked?
    Size try-on videoSnapchatA direct question as the two-second hook
  5. 05

    What worked and what needs fixing

    • Wins this month
    • Problems and challenges
  6. 06

    Recommendations

    RecommendationOwnerDue
    Move 20% of the TikTok budget to Google ShoppingCampaign managerWeek one
  7. 07

    Executive summary

    Three lines management reads first.

    • What happened
    • Why
    • What next

How to fill in the template

  1. 01

    Enter both months

    Spend, revenue, orders, impressions, clicks and customers. Derived KPIs calculate themselves.

  2. 02

    Add each platform

    This month’s numbers from each platform’s ads manager.

  3. 03

    Write what worked and what needs fixing

    Top campaigns and creatives, and the problems, plainly.

  4. 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.

01Report details

02KPI table

Enter both months in the boxes. Derived KPIs and change are calculated for you.

KPILast monthThis monthChange %
Ad spend (SAR)—
Revenue (SAR)—
Orders—
Impressions—
Clicks—
New customers—
Returning customers—
ROAS———
Cost per order, CPA (SAR)———
Average order value, AOV (SAR)———
Click-through rate, CTR %———
Conversion rate %———
Cost per click, CPC (SAR)———
Returning customer share %———

03Platform performance

This month’s numbers from each platform’s ads manager. Each platform credits itself, so the total can exceed store revenue.

PlatformSpendRevenueOrdersROASCPA
——
——
——
——
Total—————

04Top campaigns and creatives

Campaign or creativePlatformWhat worked?

05What worked and what needs fixing

06Recommendations

RecommendationOwnerDue

07Executive summary

Three lines management reads first.

Download your template in Takteek branding

Free after you add your name, email, mobile, role and country once; we also email you a copy.

Guide and examples

What should a campaign performance report include?

SectionQuestion it answersWhat goes in it
Executive summaryWhat happened, why, what next?Three lines a manager reads in a minute.
Key metricsIs the account better than last month?Spend, revenue, ROAS, orders, CPA, AOV, CTR, conversion rate, new and returning customers.
Platform performanceWhere does the money go, and where does it come back?Snapchat, TikTok, Google and Meta: spend, revenue, ROAS, CPA and share of spend.
Top campaignsWhat should we repeat?The campaign, its platform, its return and why it worked.
Wins and problemsWhat changed in execution?Short points, not paragraphs.
RecommendationsWho 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.

MetricFormulaBetter if
ROASrevenue ÷ spendHigher
CPAspend ÷ ordersLower
AOVrevenue ÷ ordersHigher
CTRclicks ÷ impressionsHigher
Conversion rateorders ÷ clicksHigher
Change %(this month − last month) ÷ last monthDepends on the metric

Worked example: a hypothetical abaya store in Ramadan

MetricLast monthThis monthChange
SpendSAR 40,000SAR 46,000+15.0%
RevenueSAR 128,000SAR 172,500+34.8%
ROAS3.20x3.75x+17.2%
Orders640780+21.9%
CPASAR 62.50SAR 58.97−5.6%
AOVSAR 200SAR 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.

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
Message us on WhatsApp
Tell us about your business
What do you want to achieve?

Approximate monthly ad budget

Pick at least one option, then your approximate budget.

How can we reach you?
+966
You are
Review your request

The consultation is free, with no commitment.

Free download

Get the file

We send the file to your e-mail. Please use an address you read.

+1
You are
Free consultation×