For business owners, copywriters, and email marketers who want a simple strategy to collate, analyze, and determine what the best email to send next is. This email audit shows you what’s working, what isn’t, and what the next steps are. Completing your email audit gets you on track to get better open rates for your future campaigns.
This post shows you how to make your emails work for you.
Over the past 3 years, I’ve analyzed which of my emails have worked best and why. Here I’ll share my email tracker system (on excel sheets) so that you can copy it and make your own. Plus, I’ll show you how to analyze your own emails to re-use the parts that are working well and how to incorporate my best practice headers into your email campaign mix.
If you haven’t already, read the post X14 Best Email Headings For +50% Open Rate first and then come back here for future analysis.
Your Email Tracker
Create a spreadsheet with the following columns:
- Open rate
- Click through
- Date sent
- Email headline
- Link
I keep the link to refer to the contents of the email to see the length, tone of voice, and elements I included.
You can also add
- Images
- Giff
- Video
- Plain Text / Template
If you want to track details inside the email
I start by listing all the top-performing emails and then I reorder them into the highest open rates first.
I also use colors for best and second best or notable – which are the ones I’ll study for insight because of something that stands out about them. Either their high open rate or click-through rate.

I have separate sheets for the years I tracked on Mailchimp and then for 2022 when I switched to Convert Kit.



On this sheet, I highlighted the elements that stood out as working best. For example:
- Use You in the headline
- Mention the time, or today a number
- Ask a question
- Add intrigue
- Use Emojis
- Play with CAPS and no caps for the first letter



This sheet is for my ConvertKit email campaigns. I didn’t add the links but did add some super niche emails as notable because of their high open rate and outstanding click-through rate. The last email had 1471 people on the list, so a 42.1% open rate was very good.
In this sheet, although the [FLASH SALE] email was for my candle business, I think that the title [FLASH SALE] was enticing and so will use that again.
Summary
In order to audit your emails, you need to track your data with your email tracker.
Key Takeaways
Keep a list of your emails on a spreadsheet.
Reorder the emails so that your highest open-rate emails are at the top.
Note what works best so that you can send more emails like that.
Recommended Reading
X14 Best Email Headings For +50% Open Rate
[🔐 The Vault 🔐 ]
Love Lauren
***
P.S:
ADVERTISE YOUR BUSINESS HERE
*sponsor a blog post to advertise your business to my audience*
(with links to your website, social media, and email)
email hello@laurenwallett.com to find out more