Email Marketing ROI Calculator: A Copyable Template for Justifying Your Budget

An email marketing ROI calculator answers two questions: what does email return per dollar spent, and what changes if you invest more or less. The formula itself is simple — ROI = (revenue attributed to email − total email cost) / total email cost — but the hard part is the assumptions behind it: your attribution window, your revenue per conversion, and which costs you actually count. This template gives you the inputs, the arithmetic, and copyable text for the memo that gets the budget approved.

What an email marketing ROI calculator actually needs to answer

Most ROI spreadsheets fail for the same reason: they measure the easy number (list size, sends, opens) and guess at the expensive one (conversion and cost). A useful calculator has to survive a finance review, which means every input must be traceable to a source.

Three assumptions do most of the damage:

• Attribution window. If you count a purchase made 30 days after a click in one month and 7 days in the next, your ROI trend is an artefact of your own settings, not performance.
• Revenue per conversion. Gross revenue flatters the result. Net revenue (after refunds, discounts and fees) is the number that survives scrutiny.
• Cost scope. Subscription only is the most common understatement. Team hours, list acquisition and deliverability tooling are real costs.

One practical note on the cost line: platform pricing models differ. Some vendors charge per contact, some per email sent, some offer unlimited emails on paid plans. Your cost input has to match your actual contract, not a generic average. Mailerflow, for example, includes unlimited emails on every paid plan, so for a high-volume sender the marginal cost per send is effectively zero — which changes the sensitivity analysis later in this article.

On the measurement side, you need delivery, click and conversion data you can trust. Mailerflow's analytics report delivery, bounces, complaints, clicks and approximate opens per campaign and overall, so the engagement inputs come from the same place you send from rather than a manual export.

The email marketing ROI calculator template

Copy this table into a spreadsheet. The example column uses clearly illustrative numbers — they are not benchmarks, and you should replace them with your own last 90 days of data.

Now the formulas, in plain text so you can paste them into cells:

Emails delivered      = emails sent × delivery rate
Clicks                = delivered × click rate
Conversions           = clicks × conversion rate
Revenue               = conversions × revenue per conversion × automation multiplier
Total cost            = SUM(cost block)
ROI %                 = (revenue − total cost) / total cost × 100
Revenue per email sent = revenue / emails sent

With the example numbers:

Delivered   = 80,000 × 0.98        = 78,400
Clicks      = 78,400 × 0.025       = 1,960
Conversions = 1,960 × 0.04         = 78.4
Revenue     = 78.4 × $60 × 1.3     = $6,115
Total cost  = $29.90 + $540 + $200 = $769.90
ROI         = ($6,115 − $769.90) / $769.90 × 100 ≈ 694%
Revenue per email sent = $6,115 / 80,000 ≈ $0.076

Note what dominates: the $540 of team time is 70% of the cost line. If you leave it out, the same campaign reports roughly 1,900% ROI — a number nobody in finance will believe.

Filling in the inputs without guessing

• Delivery and bounce rates: pull them from campaign analytics over a full quarter, not a single send. Mailerflow reports delivery, bounces and complaints per campaign and overall, so a 90-day view gives you a defensible average.
• Click rate: use unique clicks. If your platform separates automated clicks from security scanners, exclude them; otherwise note the caveat.
• Conversion rate: define the event before you measure it (purchase, demo request, trial start) and keep the definition fixed across periods.
• Revenue per conversion: net of refunds and discounts.
• Costs: include the hours your team spends on briefing, building, reviewing and reporting. This is the line most calculators omit and the first one a CFO asks about.
• Attribution window: state it in the spreadsheet header and use the same window for any channel you compare against.

If your click rate is currently an assumption rather than a measurement, A/B testing campaigns in Mailerflow lets you replace it with a tested figure over a few sends.

Sensitivity: what happens when an input moves

ROI is rarely sensitive to the input people obsess over. Move one variable at a time against the example above:

The pattern: conversion rate, revenue per conversion and automation revenue move ROI more than list growth, because list growth usually drags cost with it. That is the argument for fixing the middle of the funnel before buying more contacts.

Copyable templates to pair with the calculator

Numbers alone rarely win the budget. These three templates do the persuading.

1. Internal budget memo — use when you are asking for more spend or defending existing spend.

Subject: Email budget request — [amount], backed by a 90-day model

Summary: Email returned [ROI %] on [total cost] over the last 90 days,
based on [conversions] conversions at [revenue per conversion].

Three numbers to lead with:
1. Revenue attributed to email: [$X] (window: [7] days, net of refunds)
2. Total cost including [12] hours/month of team time: [$X]
3. Marginal return of the next [$X] invested: [scenario ROI %]

The ask: [$X] for [list growth / deliverability tooling / contractor hours].
At current conversion rates this pays back within [N] months.

Risks I have accounted for: attribution window held constant, team time
included, no revenue counted that is already attributed to [paid search].

Adapt the marginal-return line using the sensitivity table — that is the number decision-makers actually weigh.

2. Stakeholder email requesting cost inputs — use before you build the model.

Subject: Two cost figures I need for the email ROI model

Hi [name],

I am rebuilding the email ROI model and want the cost side to be accurate
rather than flattering. Could you confirm:

- Platform subscription: actual invoiced amount for [month]
- Loaded hourly rate for [team/role] so I can cost the [12] hours/month
  we spend on email production
- Any list acquisition or co-registration spend booked outside marketing
- Deliverability or inbox-placement tools billed to [department]

I will send the finished model with the attribution window and assumptions
stated on the first tab.

Thanks,
[name]

3. Test campaign email — use to replace an assumed conversion rate with a measured one.

Subject: A 2-minute question about [problem]
Preview text: One click, no form, and it tells us what to build next.

Hi [first name],

Most [role]s we talk to handle [task] the same way: manually, once a week,
and slightly differently every time.

Is that you?

[ Yes, that is me ]   [ No, we have this handled ]

If you click the first button, we will send you the [resource] we built
for exactly that workflow. No form, no call.

[Your name]

For a cold segment, lead with the problem and remove the assumption that they know you. For a warm segment, open with a reference to their last interaction and shorten the body by a third.

If you would rather not hand-build variants, Mailerflow's AI email builder turns a short description into a complete responsive design with subject lines and preview text, and the visual block editor plus reusable templates keep structure consistent across test versions so the only variable is the copy.

Subject lines and preview text for the test campaign

Pair each subject line with preview text that extends it rather than repeating it:

Keep subject lines short enough to survive mobile truncation — roughly 30–45 characters displays safely in most inboxes, though clients vary. Test subject lines as a single variable using A/B testing; changing subject and body together makes the result unreadable.

Mistakes that make the calculator lie

• Counting gross revenue. Use net of refunds and discounts. Fix: reconcile against your payment processor once a quarter.
• Ignoring team time. It is usually the largest cost line. Fix: hours × loaded rate, reviewed annually.
• Treating opens as a hard metric. Privacy features make opens approximate; Mailerflow reports approximate opens, so use them directionally and let clicks carry the argument.
• Double-counting revenue. If a contact clicked an email and a paid ad before buying, decide the rule once. Fix: document it in the model.
• Changing the attribution window between periods. Fix: lock it in the header and only change it deliberately, with a note.
• Borrowing a click rate from another industry. Fix: use your own 90-day data; if you have none, run the test campaign above first.
• Forgetting deliverability and hygiene costs. Fix: add a line for suppression management and inbox tooling.
• Reading one month as a trend. Fix: compare rolling quarters.

Turning the number into a decision

Once the model holds up, you have three levers: grow the list, improve conversion, or cut cost per send. The sensitivity table tells you which one is worth your next hour.

For high-volume senders, the cost lever deserves a specific look. Mailerflow includes unlimited emails on every paid plan, starting at $14.90/month, with a Free plan at 2,500 contacts and 10,000 emails/month — so if your current contract charges per send, the marginal cost of an extra campaign may be lower than your model assumes. Verify current plan details on the official pricing page before you plug them in, and keep the rest of the model unchanged so the comparison stays honest.

Set a floor ROI your organisation accepts, run the three scenarios side by side, and take the decision to whoever controls the budget with the assumptions printed on the same page as the result.

FAQ

How do I calculate email marketing ROI? Subtract total email cost from revenue attributed to email, then divide by total email cost and multiply by 100. Revenue comes from conversions multiplied by revenue per conversion; cost includes subscription, team time, list acquisition and tooling.

What counts as email marketing cost? At minimum: platform subscription, the loaded cost of the hours your team spends producing and reporting on email, list growth spend, deliverability tooling, and any agency or contractor fees. If it would disappear when you stopped sending email, it belongs in the cost block.

What attribution window should I use? Pick one that matches your sales cycle — 7 days suits most ecommerce, longer suits considered purchases — and keep it identical across every period and channel you compare. The specific window matters less than holding it constant.

Can I calculate ROI without revenue data? You can calculate cost per click or cost per conversion, which is still useful for comparing campaigns. Without revenue you cannot produce an ROI figure, so treat the output as an efficiency metric and label it as such.

How often should I recalculate? Quarterly is usually enough for budget decisions, with a quick refresh whenever you change platform pricing, add an automation, or shift your list acquisition spend.

---

Track deliveries, clicks and conversions per campaign and run A/B tests in Mailerflow — start with a free account and run the model against your own last 90 days. You can also review the full feature set before you commit.