New Plan your 2027 growth with the free Marketing Projection Template

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.

Run it in ChatGPT or Claude

Free. Opens in ChatGPT, Claude, Gemini or the AI tool you use.

One channel, last quarter

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.

ABDFHKM
ChannelSpendCustomers wonRevenueROICACStatus
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

  1. Set your margin and goal

    Gross margin turns revenue into profit. Target ROI is the return you expect from a channel worth keeping.

  2. Fill in last quarter

    For each channel: spend, leads, customers won and first-year revenue per customer.

  3. Read the Status column

    On target, below target or losing money. The summary names your best and weakest channel.

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