Marketing ROI Calculator
Find out if a channel pays for itself. Try one channel here, then have your own AI score every channel side by side and tell you where to move budget. Prefer a spreadsheet? Take the Google Sheet.
Every $1 spent returns $3.15 in gross profit.
On target: 215% ROI against your 200% goal
- ROI
- 215%
- ROAS
- 4.2x
- Cost per lead
- $143
- CAC
- $3,333
Run it in your own AI
Enter your website, press Run and pick ChatGPT, Claude, Gemini or another tool. It opens in your own account and asks for your channel numbers: spend, leads, customers and revenue. Paste a table or type short notes. It then scores every channel and tells you where to move budget.
Your company
Your email and the details you enter in this form are processed by MNB Teknoloji Danışmanlık Sanayi ve Ticaret Limited Şirketi when you run, copy or download the prompt, so we can follow up on your request. The answer your AI tool gives stays in your own account; we do not receive it. This does not add you to our newsletter. Privacy Policy
The sheet scores every channel at once
Enter spend, leads, customers and revenue for each channel. The Status column compares each one with your target ROI, so the channels to cut and the ones to scale are obvious. These are the example rows the template ships with.
| A | B | D | F | H | K | M |
|---|---|---|---|---|---|---|
| Channel | Spend | Customers won | Revenue | ROI | CAC | Status |
| Google Ads | $12,000 | 4 | $36,000 | 125% | $3,000 | Below target |
| LinkedIn Ads | $10,000 | 3 | $42,000 | 215% | $3,333 | On target |
| Meta Ads | $5,000 | 1 | $6,000 | -10% | $5,000 | Losing money |
| SEO / Content | $6,000 | 4 | $40,000 | 400% | $1,500 | On target |
| Outbound (email + LinkedIn) | $5,000 | 2 | $24,000 | 260% | $2,500 | On target |
| Events / Webinars | $9,000 | 1 | $15,000 | 25% | $9,000 | Below target |
| Partnerships | $1,500 | 1 | $12,000 | 500% | $1,500 | On target |
Shaded cells are the ones you fill in. Gross margin 75%, target ROI 200%.
How to use it
Set your margin and goal
Gross margin turns revenue into profit. Target ROI is the return you expect from a channel worth keeping.
Fill in last quarter
For each channel: spend, leads, customers won and first-year revenue per customer.
Read the Status column
On target, below target or losing money. The summary names your best and weakest channel.
Move budget
Shift spend from losing channels toward the ones on target, then check again next quarter.
The formulas inside
- ROI
- (Gross profit − Spend) ÷ Spend, where gross profit is revenue × gross margin
- ROAS
- Revenue ÷ Spend
- Cost per lead
- Spend ÷ Leads
- CAC
- Spend ÷ Customers won
Revenue counts the first year only. With multi-year contracts the real return is higher, so treat the result as a floor.
About the Marketing ROI Calculator
The Marketing ROI Calculator is a free Google Sheets tool for marketers and founders who need to know which channels pay for themselves. For each channel you enter spend, leads, customers won and first-year revenue per customer, and the sheet works out revenue, gross profit, ROI, ROAS, cost per lead, CAC and lead-to-customer rate.
Set your gross margin and the ROI you want each channel to reach, and the Status column flags every channel as on target, profitable but below target, or losing money. The summary names your best and weakest channel and shows gross profit per dollar spent, so you can move budget toward what works before the next planning cycle.
Questions people ask
What is a good marketing ROI?
A marketing ROI of 5:1 (500%) is often cited as strong for B2B campaigns, meaning five dollars in profit for every dollar spent, while 2:1 is closer to break even once overhead is factored in. The right target varies by channel, sales cycle, and margin, so compare your ROI against your own historical campaigns as well as industry benchmarks.
How do you calculate marketing ROI?
Marketing ROI equals net profit from a campaign, revenue minus marketing cost, divided by marketing cost, then multiplied by 100 to get a percentage. For example, if a campaign cost 10,000 dollars and generated 40,000 dollars in profit, ROI is 300%. Track spend and attributed revenue closely so the input numbers stay accurate.
Why is my marketing ROI negative?
A negative marketing ROI means the campaign cost more than the profit it generated, which usually points to weak targeting, a long sales cycle not yet reflected in revenue, or attribution that misses delayed conversions. Check your cost per lead, conversion rate, and average deal size to find where the spend is leaking before cutting the channel entirely.
Score every channel in your own AI
Give your AI your channel numbers and get ROI, CAC and the budget moves to make next. Prefer a spreadsheet? Take the sheet.