This table is your dashboard of success. It’s how you measure what matters in your newsletter campaign—growth, engagement, and retention. If you can’t track it, you can’t improve it. Simple.
How to Use It:
Subscriber Growth:
Input your target number of new subscribers. Track your current count and let the table show your progress. Always keep your eye on this number—this is your lifeblood.
Average Open Rate (%):
Enter the target percentage for how many people should open your emails. Compare it to your current open rates to see how close (or far) you are from hitting the mark.
Average Click Rate (%):
This shows you how effective your emails are in driving action. Input the target percentage of clicks per email. Monitor your current click rate here.
Unsubscribes (Max):
Keep your unsubscribe rate under control. Set a max limit and track how well you're retaining subscribers. Too many unsubscribes? Fix your content or frequency.
Pro Tip:
Use this table weekly to ensure you're heading in the right direction. Adjust fast if numbers aren't hitting targets.
Campaign Objectives
Objective
Target Value
Current Value
Progress (%)
Objective
Target Value
Current Value
Progress (%)
1
Subscriber Growth
2
Average Open Rate (%)
3
Average Click Rate (%)
4
Unsubscribes(Max)
There are no rows in this table
Target Audience Persona
Knowing exactly who you’re talking to is everything. If you’re not laser-focused on your target audience, you’re wasting time and losing subscribers. This table helps you dial in on who they are, what they care about, and how to engage them.
How to Use It:
Demographics:
Who are they? Age, location, gender—these are your basic building blocks. Don’t guess—know it.
Interests:
What drives them? What topics get them excited? You’ll use this to craft content they care about. This isn’t about what you want to write—it's about what they want to read.
Pain Points:
What keeps them up at night? These are the problems you solve. If you’re not speaking to their struggles, you’re irrelevant.
Preferred Content:
How do they like to consume information? Whether it's how-to guides or insider tips, this is what you’ll feed them to keep them engaged.
Pro Tip:
Reference this table every time you create content. Make sure you’re always aligning with your audience’s needs, interests, and pain points. Hit these, and they’ll stay loyal.
Simple, right? Know your audience—everything else falls into place.
Target Audience Persona
Demographics
Interests
Pain Points
Preferred Content
Demographics
Interests
Pain Points
Preferred Content
1
25-40 years old
Tech, personal growth, entrepreneurship
Struggles with managing time, staying updated with industry trends
Actionable guides, how-tos, and insider industry tips
2
There are no rows in this table
Email Sequence
Your email sequence is where you convert subscribers into loyal readers or paying customers. This table helps you keep track of each email’s performance. If you’re not tracking open rates and click rates, you’re flying blind.
How to Use It:
Email Title:
List the subject or title of each email. Make it catchy—this is your first chance to grab attention.
Send Day:
Log the day you send each email in the sequence. Timing is crucial—test and optimize for when your audience is most active.
Total Subscribers:
Enter the total number of subscribers who received the email. Keep an eye on this—it should be growing over time.
Opens:
Track how many people actually opened the email. If this number is low, you’ve got a subject line problem.
Clicks:
How many people clicked a link in your email? This shows engagement. If clicks are low, your call to action needs work.
Open Rate (%):
Automatically calculated from Opens and Total Subscribers. This tells you what percentage of recipients opened your email.
Click Rate (%):
Automatically calculated from Clicks and Opens. This shows how effective your content and call to action are.
CTA (Call to Action):
What’s the action you want subscribers to take? Is it a purchase, download, or click? Make sure it's clear and compelling.
Email Sequence
Email Title
Send Day
Total Subscribers
Opens
Clicks
Open Rate (%)
Click Rate (%)
CTA
Email Title
Send Day
Total Subscribers
Opens
Clicks
Open Rate (%)
Click Rate (%)
CTA
1
2
There are no rows in this table
Content Calendar
If you fail to plan, you plan to fail. Your Content Calendar is the backbone of your newsletter campaign. It keeps you organized, ensures consistency, and helps you stay ahead of deadlines. This table is where you keep all your content in line—no more scrambling at the last minute.
How to Use It:
Publish Date:
Enter the scheduled date for your newsletter to go live. This keeps you accountable—stick to the schedule.
Newsletter Theme:
What’s the overarching topic for this newsletter? Keep it focused—whether it’s an industry trend, how-to guide, or special promotion, make sure each newsletter has a clear theme.
Title:
Enter the title of your newsletter. This is what grabs attention. Make it compelling—this is your reader’s first impression.
Content Type:
What kind of content are you delivering? Is it a how-to guide, a case study, or a product promotion? Knowing your content type ensures you’re delivering a variety that keeps your audience engaged.
Status:
Track whether the content is in draft, pending, or published. This keeps the entire team (or just you) updated on the progress. Don’t leave things half-done—keep moving forward.
Days Until Publish:
Automatically calculated based on the Publish Date. This shows how many days you have left until the newsletter goes live. Don’t let this number sneak up on you.
Formula:
Pro Tip:
Review this table weekly to stay ahead of deadlines and avoid last-minute rushes. Use it to plan content strategically, ensuring each newsletter builds on the last.
Own your schedule and you’ll own the success of your campaign.
Content Calendar
Publish Date
Newsletter Theme
Title
Content Type
Status
Days Until Publish
Publish Date
Newsletter Theme
Title
Content Type
Status
Days Until Publish
1
2
3
4
There are no rows in this table
Lead Magnets
Your lead magnets are your secret weapon for attracting subscribers. This table lets you track and measure their performance, helping you figure out what works and what doesn’t. The more effective your lead magnets, the faster your list grows.
How to Use It:
Lead Magnet:
Enter the name of the lead magnet (e.g., Free eBook, Webinar, Checklist). Clarity is key—name it something easy to identify so you can track results over time.
Type:
What kind of lead magnet is this? It could be a PDF guide, webinar, checklist, or video series. Knowing the type helps you compare the performance of different strategies.
Status:
Track whether the lead magnet is live, in development, or paused. You’ll know exactly what’s available to your audience at any given time.
Date Launched:
Record the date when the lead magnet went live. This helps you track how quickly it’s performing and gives you insight into long-term performance.
Subscribers:
Enter the number of subscribers gained from this lead magnet. This is the number you’re chasing—more subscribers, more potential conversions.
Visitors:
Track how many people viewed or landed on your lead magnet. If you have a lot of visitors but few subscribers, your lead magnet may need some adjustments.
Conversion Rate (%):
Automatically calculated from Subscribers and Visitors. This shows how well the lead magnet is converting visitors into subscribers. If the percentage is low, optimize your offer or landing page.
Formula:
Download Link:
Provide the direct link to the lead magnet for easy access. Whether it’s a download or sign-up page, keep everything organized and accessible.
Pro Tip:
If a lead magnet isn’t converting well, don’t scrap it right away. Tweak the copy, adjust the CTA, or A/B test the landing page first. Data-driven decisions lead to long-term success.
Stay on top of this table, and you’ll have a clear picture of what’s bringing in subscribers and where to focus your efforts for maximum growth.
Lead Magnets
Lead Magnet
Type
Status
Date Launched
Subscribers
Visitors
Conversion Rate (%)
Download Link
Lead Magnet
Type
Status
Date Launched
Subscribers
Visitors
Conversion Rate (%)
Download Link
1
9/20/2024
51
2
10/15/2024
78
3
11/6/2024
95
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (