Softwiro
Free Excel template

Ad Performance Tracker for Excel (ROAS, CPA)

A free Excel tracker for paid ads on Meta, Google, TikTok, Pinterest or any other platform. You copy each day's numbers from the platform reports: spend, impressions, clicks, conversions and the revenue you credit to the campaign. The sheet works out CTR, CPC, CPM, conversion rate, CPA and ROAS for every row, flags what is off, and rolls everything up by campaign, platform and week for the period you choose. It also works out your break-even ROAS from your gross margin, so you judge each campaign against what it must earn, not against a number from a blog post. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 261 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Campaigns” tab, with the numbers and formulas that are in the file.
CampaignPlatformSpendImpressionsClicksConversionsRevenueCTRCPCCPMConv. rateCPAROASProfit after adsVerdict
Fall Collection - ProspectingMeta4,044.00366,4554,0391047,496.001.10%1.0011.042.57%38.881.85-1,045.60Cut
Retargeting - Cart AbandonersMeta1,423.00102,3931,85013710,652.001.81%0.7713.907.41%10.397.492,837.80Scale
Brand SearchGoogle Ads1,195.0042,5452,52921314,481.005.94%0.4728.098.42%5.6112.124,597.40Scale
Shopping - Best SellersGoogle Ads3,274.00364,3953,3001208,907.000.91%0.998.983.64%27.282.72288.80Keep
Competitor KeywordsGoogle Ads2,183.0098,8691,574151,069.001.59%1.3922.080.95%145.530.49-1,755.40Cut
TikTok - Product DemosTikTok2,571.00427,8173,425956,172.000.80%0.756.012.77%27.062.40-102.20Cut
Holiday Gift GuidePinterest1,461.00181,9171,254504,269.000.69%1.178.033.99%29.222.92246.60Keep
Display RemarketingGoogle Ads959.00212,327844443,097.000.40%1.144.525.21%21.803.23279.80Scale
All campaigns17,110.001,796,71818,81577856,143.001.05%0.919.524.13%21.993.285,347.20

Example from the “Campaigns” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Spend, revenue, ROAS, gross profit after ad spend, conversions, CPA, CTR and break-even ROAS for the period, the best campaign by ROAS, how many campaigns to cut, an 8-week table, a platform table, a campaign table with verdicts, and four charts: weekly spend and revenue, weekly ROAS, spend by platform and ROAS by campaign.
  • Daily Log: One row per campaign per day (up to 1,500 rows). You type date, campaign, spend, impressions, clicks, conversions and revenue. It adds the platform, CTR, CPC, CPM, conversion rate, CPA and ROAS, an Alert and a Check column.
  • Campaigns: Every campaign for your period with spend, impressions, clicks, conversions, revenue and all the ratios, the profit after ads, a verdict (Scale, Keep or Cut) and a rank by ROAS.
  • Platforms: The same numbers by platform, with each platform's share of total spend.
  • Weekly: The last 8 weeks, Monday to Sunday, with spend, conversions, revenue, CPA, ROAS and the change from the week before.
  • Settings: Business name, currency symbol, report dates, gross margin, target ROAS, target CPA, target CTR, and your lists of platforms (up to 10) and campaigns (up to 30).

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most ad trackers show ROAS and leave you to decide whether it is good. This one asks for your gross margin, calculates break-even ROAS, and gives every campaign a verdict against both break-even and your own target. In the sample, the account spends 17,110 for a ROAS of 3.28, but three of eight campaigns sit below break-even, which is hidden when you only look at the total.

How do I track ad performance in Excel?

Keep one row per campaign per day with the five raw numbers: spend, impressions, clicks, conversions and revenue. Everything else is a formula on those: CTR is clicks divided by impressions, CPC is spend divided by clicks, CPM is spend divided by impressions times 1,000, CPA is spend divided by conversions and ROAS is revenue divided by spend.

Do not type the ratios, and do not average the daily ratios. Add up the raw numbers first and then divide, as the Campaigns, Platforms and Weekly sheets do. Averaging daily CPAs gives a wrong answer whenever the days have different spend.

What is a good ROAS, and what is break-even ROAS?

There is no ROAS that is good for everyone. Break-even ROAS is 1 divided by your gross margin: at a 40% margin it is 2.50, so each unit of spend must bring back 2.50 in revenue just to cover the product cost and the ad. Below that you lose money on the sale, whatever the dashboard of the ad platform says. Your target should sit above it, high enough to pay for everything else the business costs.

In the sample the margin is 40%, break-even is 2.50 and the target is 3.00. Brand Search returns 12.12, while Competitor Keywords returns 0.49 on 2,183 of spend. Change the margin on Settings and every verdict moves. To go deeper into unit economics, see the ads break-even template.

How do I calculate CPA and ROAS from my ad reports?

Copy spend, impressions, clicks, conversions and the sales value from each platform's report for the day. Revenue is the value you credit to the campaign. It may not match what the platform claims, especially when two platforms both claim the same sale, so use your shop or CRM numbers when you have them.

Pick the campaign from the dropdown. Its platform comes from the list on Settings, so the platform table always matches the campaign table. To tag the links of each campaign consistently, see the UTM naming builder.

How to use it

  1. On Settings type your business name, the period to report on (from and to dates), your gross margin and your three targets: ROAS, CPA and CTR. Break-even ROAS is worked out for you.
  2. Still on Settings, list the platforms you advertise on (up to 10) and your campaigns (up to 30), and pick the platform of each campaign. Give every campaign a unique name.
  3. On Daily Log add one row per campaign per day: date, campaign (dropdown), spend, impressions, clicks, conversions and the revenue you credit to the campaign. Copy the numbers from each platform's report.
  4. The grey columns work out the platform, CTR, CPC, CPM, conversion rate, CPA and ROAS, and an Alert column says what is off: no conversions, CPA over target, ROAS under break-even or target, low CTR.
  5. Campaigns ranks every campaign for your period and gives a verdict: Scale, Keep or Cut. Platforms and Weekly show the same numbers by platform and for the last 8 weeks.
  6. Open Dashboard for the period totals, profit after ad spend, weekly trend and charts.

Before you start:

  • Capacity: 1,500 daily rows, 10 platforms and 30 campaigns. The Dashboard campaign table and chart show the first 12 campaigns on your list.
  • CTR = clicks / impressions. CPC = spend / clicks. CPM = spend / impressions x 1,000. Conversion rate = conversions / clicks. CPA = spend / conversions. ROAS = revenue / spend.
  • Break-even ROAS = 1 / gross margin. Below it, the revenue you credit to ads does not cover the product cost plus the ad spend. It ignores other costs, so treat it as a floor.
  • Verdict: Scale when ROAS is at or above your target, Keep when it is at or above break-even, Cut when it is below break-even.
  • The targets in the sample are examples, not benchmarks. Set them from your own margin and sales.
  • Revenue is what you credit to the campaign. It can differ from what each platform reports, and the sheet does not de-duplicate sales that two platforms both claim.
  • Campaigns, Platforms and the Dashboard totals count only dates between the report from and to dates. Weekly shows the 8 weeks (Monday to Sunday) ending with the week of the "to" date.
  • A row whose campaign is not on the Settings list is flagged in the Check column and left out of the campaign and platform tables.

Excel file (.xlsx) · 261 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this ad performance tracker free?

Yes. Download it, use it for your business or your clients and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS and INDEX/MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

Which platforms does it support?

Any. The sample uses Meta, Google Ads, TikTok and Pinterest, and Settings has room for 10 platforms and 30 campaigns. It does not pull data from the platforms; you paste the daily numbers.

How do the Scale, Keep and Cut verdicts work?

Scale means the campaign's ROAS for the period is at or above your target. Keep means it is at or above break-even. Cut means it is below break-even. They look at ROAS only, so check CPA and volume before you act.

Why is a campaign missing from the tables?

Its name in the Daily Log must match a name on the Settings list exactly. The Check column says Campaign not on Settings. The Dashboard campaign table shows the first 12 campaigns on your list.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Excel templates for paid ads: budget, performance and reports

More free templates for: Marketing and advertising

More free templates

All templates · Free tools