Email Tracking Spreadsheet Template

Email Tracking Spreadsheet Template

Campaign & Outreach Performance Tracking

Last Updated: November 8, 2025 Version: 1.0

---

📋 Overview

This document provides a comprehensive spreadsheet template for tracking all email outreach, measuring performance, and optimizing your email campaigns.

---

🎯 Spreadsheet Structure

Setup Instructions

Option 1: Google Sheets (Recommended)

1. Create new Google Sheet
2. Name it: “Email Outreach Tracking 2025”
3. Create tabs as outlined below
4. Share with team members

Option 2: Excel

1. Create new Excel workbook
2. Save as: “Email_Outreach_Tracking_2025.xlsx”
3. Create sheets as outlined below

---

📊 Tab 1: Email Log (Main Tracking Sheet)

Column Structure

Column	Header	Data Type	Example	Notes
A	Date Sent	Date	2025-11-08	When email was sent
B	Recipient Name	Text	Dr. Sarah Nkosi	Full name
C	Company/Org	Text	ETDP SETA	Organization name
D	Title/Role	Text	CEO	Their position
E	Email Address	Email	sarah.nkosi@etdpseta.org.za	Actual email
F	Template Used	Dropdown	CLIENT-003 (SETA)	Which template
G	Subject Line	Text	Skills Development Intelligence for ETDP SETA	Actual subject
H	Source/Context	Dropdown	Conference / Referral / Cold / Website	How you found them
I	Sent By	Dropdown	Your Name	Team member who sent
J	Opened?	Checkbox	☑ Yes / ☐ No	Email opened (if tracking)
K	Open Date	Date	2025-11-09	When first opened
L	Responded?	Checkbox	☑ Yes / ☐ No	Did they reply
M	Response Date	Date	2025-11-10	When they responded
N	Response Type	Dropdown	Interested / Not Interested / More Info / Meeting Request	Type of response
O	Meeting Booked?	Checkbox	☑ Yes / ☐ No	Meeting scheduled
P	Meeting Date	Date	2025-11-15	Scheduled meeting
Q	Demo Scheduled?	Checkbox	☑ Yes / ☐ No	Demo booked
R	Demo Date	Date	2025-11-20	Demo scheduled
S	Current Status	Dropdown	Sent / Opened / Responded / Meeting / Demo / Proposal / Closed Won / Closed Lost	Pipeline stage
T	Follow-up 1 Date	Date	2025-11-15	First follow-up sent
U	Follow-up 2 Date	Date	2025-11-22	Second follow-up
V	Follow-up 3 Date	Date	2025-11-29	Third follow-up
W	Next Action	Text	Send follow-up 2 on Nov 22	What’s next
X	Next Action Date	Date	2025-11-22	When to do it
Y	Value (Potential)	Currency	R500,000	Estimated deal value
Z	Notes	Text	Met at SACE conference. Interested in provider oversight.	Any additional info

---

Dropdown Values

Column F - Template Used:

• EVENT-001 (Exhibition Request)
• FOLLOWUP-001 (Post-Presentation)
• FOLLOWUP-003 (Gentle Reminder)
• CLIENT-001 (Education Institution)
• CLIENT-002 (NGO/Training Provider)
• CLIENT-003 (SETA)
• CLIENT-004 (Government Department)
• PARTNERSHIP-001 (Strategic Partnership)
• CUSTOM

Column H - Source/Context:

• Cold Outreach
• Conference/Event
• Referral - Client
• Referral - Partner
• Website Inquiry
• LinkedIn
• Social Media
• Other

Column I - Sent By:

• [List your team members]

Column N - Response Type:

• Interested - Meeting Request
• Interested - More Info
• Not Interested - No Fit
• Not Interested - Timing
• Not Interested - Budget
• Out of Office
• Bounced/Invalid
• No Response

Column S - Current Status:

• Sent (email sent, no open confirmation)
• Opened (email opened, no response)
• Responded (replied, next action pending)
• Meeting Scheduled
• Meeting Completed
• Demo Scheduled
• Demo Completed
• Proposal Sent
• Negotiation
• Closed Won
• Closed Lost
• Nurture (not now, follow up later)

---

Conditional Formatting (Google Sheets)

Status Column (S) - Color Coding:

• Sent/Opened: Light Gray
• Responded: Light Blue
• Meeting/Demo Scheduled: Yellow
• Proposal/Negotiation: Orange
• Closed Won: Green
• Closed Lost: Red
• Nurture: Purple

Next Action Date (X) - Alert Colors:

• Overdue (past date): Red
• Due Today: Yellow
• Due This Week: Light Orange
• Future: White

---

📈 Tab 2: Performance Dashboard

Summary Metrics

Metric	Formula	Target	Actual
Total Emails Sent	=COUNTA(‘Email Log’!A:A)-1	-	-
Open Rate	=COUNTIF(‘Email Log’!J:J,”☑”)/COUNTA(‘Email Log’!A:A)-1	30%	-
Response Rate	=COUNTIF(‘Email Log’!L:L,”☑”)/COUNTA(‘Email Log’!A:A)-1	20%	-
Meeting Booking Rate	=COUNTIF(‘Email Log’!O:O,”☑”)/COUNTA(‘Email Log’!A:A)-1	10%	-
Demo Conversion Rate	=COUNTIF(‘Email Log’!Q:Q,”☑”)/COUNTIF(‘Email Log’!O:O,”☑“)	60%	-

Performance by Template

Template	Emails Sent	Open Rate	Response Rate	Meeting Rate
EVENT-001	=COUNTIF(‘Email Log’!F:F,“EVENT-001”)	=COUNTIFS(‘Email Log’!F:F,“EVENT-001”,‘Email Log’!J:J,”☑”)/COUNTIF(‘Email Log’!F:F,“EVENT-001”)	[Similar formula]	[Similar formula]
FOLLOWUP-001	[Same pattern]
CLIENT-001	[Same pattern]
CLIENT-002	[Same pattern]
CLIENT-003	[Same pattern]
CLIENT-004	[Same pattern]

Performance by Source

Source	Emails Sent	Response Rate	Meeting Rate	Conversion
Cold Outreach	=COUNTIF(‘Email Log’!H:H,“Cold Outreach”)	[Formula]	[Formula]	[Formula]
Conference	=COUNTIF(‘Email Log’!H:H,“Conference/Event”)	[Formula]	[Formula]	[Formula]
Referral	[Sum of referral types]	[Formula]	[Formula]	[Formula]

Monthly Trends

Month	Sent	Opened	Responded	Meetings	Demos	Won
Nov 2025	[Formula filtering by month]
Dec 2025
Jan 2026

---

📅 Tab 3: Follow-up Schedule

Columns

Column	Header	Formula/Data
A	Company/Org	=IF(AND(‘Email Log’!S:S<>“Closed Won”,‘Email Log’!S:S<>“Closed Lost”,‘Email Log’!X:X<>""),‘Email Log’!C:C,"")
B	Contact Name	=‘Email Log’!B:B
C	Next Action	=‘Email Log’!W:W
D	Next Action Date	=‘Email Log’!X:X
E	Days Until Due	=D:D-TODAY()
F	Status	=‘Email Log’!S:S
G	Last Contact	=MAX(‘Email Log’!A:A,‘Email Log’!T:T,‘Email Log’!U:U,‘Email Log’!V:V)
H	Days Since Contact	=TODAY()-G:G

Sort by: Column D (Next Action Date) ascending

Filter: Show only rows where Status is not “Closed Won” or “Closed Lost”

---

💰 Tab 4: Pipeline Value

Revenue Forecast

Status Stage	Count	Avg Deal Size	Total Pipeline Value	Probability	Weighted Value
Meeting Scheduled	=COUNTIF(‘Email Log’!S:S,“Meeting Scheduled”)	=AVERAGE(IF(‘Email Log’!S:S=“Meeting Scheduled”,‘Email Log’!Y:Y))	=B2*C2	20%	=D2*E2
Demo Completed				40%
Proposal Sent				60%
Negotiation				80%
TOTAL	=SUM(B2:B5)		=SUM(D2:D5)		=SUM(F2:F5)

Top Opportunities

Rank	Company	Contact	Value	Status	Next Action
1	[Sort by highest value]
2
3

---

🎯 Tab 5: Weekly Action Plan

This Week’s Priorities

Week of: [DATE]

Priority	Company	Contact	Action Required	Due By	Status
1	[Pull from Follow-up Schedule]				☐ Not Started / 🔄 In Progress / ✅ Done
2
3

Overdue Actions

Company	Contact	Action	Original Due	Days Overdue	Urgency
[Auto-populate from Follow-up Schedule where Days Until Due < 0]					High/Medium/Low

---

📊 Sample Data (For Testing)

Row 1 Example

Date Sent: 2025-11-08
Recipient: Dr. Sarah Nkosi
Company: ETDP SETA
Title: CEO
Email: sarah.nkosi@etdpseta.org.za
Template: CLIENT-003 (SETA)
Subject: Skills Development Intelligence for ETDP SETA
Source: Conference/Event
Sent By: [Your Name]
Opened: Yes
Open Date: 2025-11-09
Responded: Yes
Response Date: 2025-11-10
Response Type: Interested - Meeting Request
Meeting Booked: Yes
Meeting Date: 2025-11-15
Current Status: Meeting Scheduled
Next Action: Send pre-meeting agenda
Next Action Date: 2025-11-14
Value: R750,000
Notes: Met at SACE Annual Conference. Very interested in provider oversight capabilities.

---

🔧 Advanced Features (Optional)

Email Tracking Integration

If using email tracking tools (Mailtrack, HubSpot, etc.):

1. Export tracking data weekly
2. Import Open/Response data into columns J-M
3. Reduces manual data entry

CRM Integration

If using CRM:

1. Export deal pipeline weekly
2. Cross-reference with Email Log
3. Update Status column (S) accordingly

Automation (Google Sheets)

Auto-reminders using Google Apps Script:

// Send daily email with overdue follow-ups
function sendDailyReminder() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Follow-up Schedule");
  var data = sheet.getDataRange().getValues();

  var overdue = [];
  for (var i = 1; i < data.length; i++) {
    if (data[i][4] < 0) { // Days Until Due column
      overdue.push(data[i][0] + " - " + data[i][2]); // Company - Next Action
    }
  }

  if (overdue.length > 0) {
    MailApp.sendEmail({
      to: "your.email@isutech.co.za",
      subject: "Overdue Follow-ups: " + overdue.length,
      body: "The following actions are overdue:\n\n" + overdue.join("\n")
    });
  }
}

---

📋 Weekly Maintenance Tasks

Monday Morning (15 minutes)

1. Review “Follow-up Schedule” tab
2. Plan week’s outreach and follow-ups
3. Update “Weekly Action Plan” tab
4. Clear completed actions from previous week

Friday Afternoon (20 minutes)

1. Update all email outcomes for the week
2. Review “Performance Dashboard”
3. Identify top/bottom performing templates
4. Plan adjustments for next week

Monthly (30 minutes)

1. Analyze monthly trends
2. Calculate conversion rates by template
3. Update team on performance
4. Refine templates based on data

---

🎓 Training: How to Use This Spreadsheet

For New Team Members

Day 1:

1. Review column definitions above
2. Practice entering 2-3 sample emails
3. Understand dropdown options
4. Learn status progression (Sent → Opened → Responded → etc.)

Week 1:

1. Log every email you send
2. Update Opens/Responses daily
3. Check Follow-up Schedule each morning
4. Ask questions when confused

Ongoing:

1. Update immediately after sending emails
2. Check Next Actions daily
3. Review your personal stats weekly
4. Celebrate wins (meetings booked, deals closed!)

---

🔍 How to Analyze Your Data

Question 1: Which templates work best?

Check: Performance by Template table Action: Use more of high-performing templates, refine low performers

Question 2: What source generates best leads?

Check: Performance by Source table Action: Invest more in high-converting sources (conferences > cold email, etc.)

Question 3: Am I following up enough?

Check: Follow-up Schedule tab - Days Since Contact column Action: If average >14 days, you’re not following up enough

Question 4: What’s my actual conversion rate?

Check: Performance Dashboard - Meeting Booking Rate Action: If <10%, review email quality and personalization

Question 5: What’s my pipeline value?

Check: Pipeline Value tab - Total Weighted Value Action: Use for forecasting and goal-setting

---

📈 Success Benchmarks

Metric	Poor	Average	Good	Excellent
Open Rate	<20%	20-30%	30-40%	>40%
Response Rate	<10%	10-20%	20-30%	>30%
Meeting Rate	<5%	5-10%	10-20%	>20%
Follow-up Consistency	<50%	50-75%	75-90%	>90%
Data Entry Currency	>3 days lag	1-3 days	Same day	Real-time

---

🚀 Quick Start

1. Create spreadsheet (Google Sheets recommended)
2. Set up Tab 1 (Email Log) with all columns
3. Add dropdown menus for Template, Source, Status, etc.
4. Enter first 5 emails you’ve sent recently
5. Create Tab 2 (Performance Dashboard) with basic metrics
6. Use it daily - make it a habit

Download template: [Create based on structure above]

---

💡 Pro Tips

1. Update immediately: Don’t batch-update, do it right after sending
2. Be consistent: Use same dropdown values every time
3. Track everything: Even “no response” is valuable data
4. Review weekly: 15 minutes every Friday to analyze trends
5. Celebrate wins: Share team success stories based on data

---

Questions or need help setting this up? Contact marketing team lead.

---

Email Tracking Template maintained by iSu Technologies Marketing Team Last Updated: November 8, 2025