Ad spend and ROAS tracker
A 3x ROAS is not good news if you needed 3.4x to stand still. Log spend, orders and revenue per campaign; the sheet gives you cost per order, ROAS, the ROAS you had to beat and what is left after the goods.
Get the spreadsheet
Free. The file downloads straight away and the link is emailed to you as well, so you can find it again on the laptop you actually work on.
What is inside
- Settings: your gross margin on an average order.
- Campaigns: dates, channel, spend, orders, revenue in; cost per order, ROAS, break-even ROAS and profit out.
- A verdict column per campaign and a totals row for the account.
How to use it
- Open it in Excel, or upload it to Google Drive and open it with Google Sheets. Everything survives the trip: formulas, dropdowns and formats.
- Fill in the sand-coloured cells. They are the only ones meant for typing; every white cell is a formula that keeps itself correct.
- Start with the Settings sheet. The rates there drive every fee calculation in the workbook, and they come from your own account, not from us.
- Keep it open at the end of each week. A spreadsheet you update on the day you remember is worth more than a perfect one you fill in once a year.
Why we give it away
We build real business apps with AI tools and publish what they cost down to the cent, and these sheets came out of doing that: they are the ones we keep open ourselves. Giving them away costs us nothing and puts us in front of the people we write for. How we test explains where the numbers in them come from.
Questions
Where do I get my gross margin?
Revenue minus the goods, the shipping you pay and the payment fees, as a share of revenue. Our product profit spreadsheet works it out per product, and the income tracker gives it for the whole store.
Does it work for Google and TikTok too?
Yes. The channel column is a dropdown with the usual ones; the maths is the same wherever the traffic came from.
Why is the break-even ROAS the same on every row?
Because it comes from your margin, not from the campaign. Change the margin in Settings and every row updates.
The other templates
- Shopify income and expenses tracker — What did my store actually make this month?
- Product profit and pricing calculator — Does this product make money at this price?
- Store launch budget and break-even planner — What will it cost me to start, and when do I break even?
Free calculators if you would rather work it out in the browser than in a spreadsheet.
Read next
Systeme.io Free Plan: What We Measured on a Real Account
We built on a Systeme.io free account on Sept 16, 2026: one automation rule, one campaign, a forced from-address, and two screens that never loaded.
How to Build a Booking App Without Code (We Built Two)
We built two real booking apps on free AI builders and logged every credit. What $0 gets you, what breaks, and the exact feature that makes you pay.