How to Calculate ROI for Your Email Sequences (Free Google Sheets Template)

Stop Wasting Money on Email Sequences That Don't Convert

As a marketer or small business owner, you're probably running multiple email sequences — welcome campaigns, abandoned cart reminders, re-engagement drips. But do you actually know which ones are profitable?

Most people don't. They guess.

Let's fix that with a simple ROI formula and a pre-built Google Sheets template.

The ROI Formula for Email Sequences

ROI = (Revenue - Cost) / Cost × 100

Where:

• Revenue = Conversions × Average Order Value
• Conversions = Email List × Open Rate × Click Rate × Conversion Rate
• Cost = (Emails Sent × Cost Per Email) + Fixed Setup Cost

Example: Welcome Sequence

• 10,000 emails sent
• 25% open rate (2,500 opens)
• 4% click rate (100 clicks)
• 3% conversion rate (3 conversions)
• $75 average order value
• $0.02 per email + $500 setup

Revenue = 3 × $75 = $225

Cost = (10,000 × 5 emails × $0.02) + $500 = $1,500

ROI = ($225 - $1,500) / $1,500 = -85%

That's a loss. This sequence needs optimization.

Your Free Template

I built a free ROI Calculator for Email Sequences in Google Sheets. It includes:

• Auto-calculating ROI, net profit, and breakeven
• Pre-filled scenarios (welcome, abandoned cart, re-engagement)
• Sensitivity analysis for different list sizes
• Color-coded dashboard (green = profitable, red = losing money)

Grab the free template here

It's $0 — literally free. Use it for your next campaign review.