Email Campaign Tracker

Track every email send: delivery, open rate, click rate, unsubscribes and revenue, with results by segment.

Copy the numbers from your email tool after each send. Sends with too many unsubscribes or a low open rate are highlighted.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Settings — Currency and your limits. You fill in: Currency, Lowest open rate you accept, Highest unsubscribe rate you accept.
  • Lists — Edit the drop-down lists. You fill in: Segments.
  • Sends — One row per email sent. You fill in: Date, Email, Segment, Sent, Delivered, Opens, Clicks, Unsubscribes, Orders, Revenue. Worked out for you: Open rate, Click rate, Click-to-open, Unsubscribe rate, Revenue per 1,000 delivered.
  • Dashboard — Which emails and segments work. Shows: Sends, Delivered, Open rate, Click rate, Unsubscribe rate, Revenue, a chart.
  • Summary — What the numbers say. Shows: Sends, Delivered, Open rate, Click rate, Revenue, Sends below your open-rate floor, Sends over your unsubscribe limit, Best email (revenue per 1,000), Weakest email (open rate).
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Email review routine. 10 steps to tick off, with a progress bar.

How to use it

  1. Open Settings: set your currency, the lowest open rate you accept and the highest unsubscribe rate.
  2. In Lists, edit your segments.
  3. In Sends, add one row per email after it goes out, with the numbers from your email tool.
  4. Dashboard shows totals and results by segment.

What it does

  • Open rate, click rate, click-to-open and unsubscribe rate per send
  • Revenue per 1,000 emails delivered
  • Results by segment: sends, open rate, click rate and revenue
  • Your own limits for unsubscribes and open rate
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Microsoft Excel
  • Excel for Mac

Support

Questions about setup? Send us a message from your account page and we reply by email.

Email Campaign Tracker

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

Free

File language: English

Free template. Enter your email and the files are yours right away.

We'll email you when new templates come out. Unsubscribe anytime.

Mia Ready
39 templates in the shop
View All Templates
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate