Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesMarketing & GrowthEmail Marketing & LifecycleEmail Campaign Tracker

SpreadsheetEmail Marketing & LifecycleFree

Email Campaign Tracker

Every send with delivery, open, click, unsubscribe and bounce rates against your averages, revenue per thousand, results by campaign type and monthly list growth.

Shown with sample data

Colour

Email Campaign Tracker

Every send with delivery, open, click, unsubscribe and bounce rates against your averages, revenue per thousand, results by campaign type and monthly list growth.

Click rate
5.8%
All sends
Open rate
42%
Email revenue
$19,100
Unsubscribe rate
0.2%
Click rate by send
  • Webinar invite8.4%
  • Summer sale7.5%
  • Feature launch7.3%
  • October newsletter5.5%
  • November newsletter4.6%
  • September newsletter4.5%
  • July newsletter4.4%
  • August newsletter4%
Revenue per 1,000 by type
  • Promotion$545.14
  • Product launch$271.00
  • Event invite$214.12
  • Newsletter$110.50

How to use it

  1. 1Add a row for every send with its type and subject line.
  2. 2Copy results from your email platform 72 hours after sending.
  3. 3Each month, add new subscribers on the List growth sheet.
  4. 4Compare each send with the average and note what you tested.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Benchmark your email programme send by send. Record each campaign's type, subject line, delivered, bounces, opens, clicks, unsubscribes and attributed revenue; the tracker works out every rate, revenue per thousand emails, and whether each send beat your average click rate. Campaign types are compared side by side, and a list growth sheet tracks new subscribers against unsubscribes each month.

Who it’s for

  • Newsletters and promotional emails
  • Testing subject lines and send types
  • Monthly email reporting

What’s included

  • Sends sheet: Every email send with engagement and revenue.
  • By type sheet: How each kind of email performs.
  • List growth sheet: New subscribers against unsubscribes and bounces each month.

How to use it

  1. 1Add a row for every send with its type and subject line.
  2. 2Copy results from your email platform 72 hours after sending.
  3. 3Each month, add new subscribers on the List growth sheet.
  4. 4Compare each send with the average and note what you tested.

Tips

  • Since privacy changes inflated opens, judge sends on clicks and revenue rather than open rate.
  • Keep unsubscribes under 0.3% per send and bounces under 2%; clean your list if they rise.

Questions

What is click-to-open?

Clicks divided by opens: how compelling the content was for people who opened.

How is the average worked out?

Total clicks divided by total delivered across every send in the tracker.

Related searchesemail marketingnewsletter metricsopen rateclick ratelist growthemail reporting

Details

Format
Spreadsheet
Category
Email Marketing & Lifecycle
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetEmail Marketing & LifecycleFree

Email Campaign Tracker

Every send with delivery, open, click, unsubscribe and bounce rates against your averages, revenue per thousand, results by campaign type and monthly list growth.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Email Marketing & Lifecycle
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More email marketing & lifecycle templates

View all
Email List Growth & Health Tracker2 sheets

New subscribers

2,430

Net growth

1,502

Unsubscribe rate

1%

ABCD
1MonthSourceList at startNew subscribers
2Sep 2026Website form4,200310
3Sep 2026Lead magnet2,600540
4Sep 2026Checkout3,100260
5Oct 2026Website form4,430280
Monthly
SpreadsheetEmail Marketing & Lifecycle

Email List Growth & Health Tracker

Subscribers gained and lost each month, with growth rate, churn and deliverability warnings.

10 min setupPreview

Welcome Series: Brand

Trigger: Subscribes / first purchase / starts trial Goal: First purchase / activation / reply From: Name at Brand

Email 1: Deliver and set expectations (immediately)

Subject: Welcome. Here’s your promised thing Preview: What they get and what to expect

Hi First name,

Thanks for joining. Here is the guide / your discount / your login: Button: Get it

Over the next two weeks I’ll send what, how often. If you only do one thing today, quick action.

Signature

DocumentEmail Marketing & Lifecycle

Welcome Email Series

Five emails for new subscribers or customers: deliver, introduce, help, prove and invite.

10 min setupPreview

Brand name Newsletter: Month Year

Subject line options

  • 1.The 15-minute dinner our customers are making this month
  • 2.New: winter menu kits, plus 3 tips for faster weeknights
  • 3.Maria, your November kitchen update

Preheader: Plus: free delivery on orders over $50 until Sunday.

Test two subject lines on 20% of your list, then send the winner to the rest.

Logo | View in browser

Hi First name,

DocumentEmail Marketing & Lifecycle

Email Newsletter

A ready-to-send newsletter layout with subject lines, preheader, feature story, quick updates, spotlight, tip and compliant footer.

30 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ