You've sent 200 cold emails this week. But how many opened them? Who replied? Which subject line worked best? If you're scratching your head, you're not alone.
Most Nigerian freelancers either ignore tracking entirely—and lose money—or pay ₦5,000–₦15,000 monthly for tools like HubSpot or Mailchimp. But here's the truth: Google Sheets is free, powerful, and completely sufficient for tracking cold email campaigns when you know how to structure it.
In this guide, I'll show you exactly how to use Google Sheets to track cold email campaigns like a professional agency, without spending a naira on expensive software. By the end, you'll know which leads are worth following up, which emails are converting, and where to adjust your pitch.
Before we build your tracking sheet, let's talk numbers. A Nigerian freelancer earning ₦300,000–₦500,000 monthly typically spends 15–20 hours per week on outreach. That's real time, and time is money.
Without tracking, you're flying blind. You don't know:
A freelancer I worked with in Lagos was sending 50 cold emails weekly for 6 months with zero system. When we set up tracking, he discovered his open rate was only 12% (vs. the 25% benchmark). We changed his subject line, and it jumped to 31%. That single change generated an extra ₦180,000 in contracts that quarter.
Tracking doesn't just tell you what happened—it tells you what to do next.
Before you build your tracking sheet, understand the full workflow:
Your Google Sheet is the command center. Everything flows through it.
Open Google Sheets and create a new sheet. Name it "Cold Email Campaign [Month]" (e.g., "Cold Email Campaign August 2026").
Add these column headers in row 1:
This might look like overkill, but you'll use every column. Trust me.
If you're starting from scratch, the first thing you need is a quality lead list. Get one from Freelance LeadsHub—they provide downloadable CSV files with verified business emails, phone numbers, and websites segmented by niche and country. The Starter plan (₦20,000) gives you 8,500 leads, which is enough for 2–3 months of outreach.
Once you have your CSV:
You now have your lead database. Don't delete it—keep it as a reference sheet.
Before you send a single email, fill in columns A–I for all leads you plan to contact:
This takes 2–3 minutes per batch of 50 emails, but it's critical. You're setting up the structure before the action happens.
Pro Tip: Color-code by industry. Select the Industry column, then use Format → Conditional Formatting to highlight "Video Production" in green, "Tech Startups" in blue, etc. This makes pattern-spotting instant.
Once your sheet is prepped, use Zaram Web Mailer to send your bulk emails. It integrates open and click tracking, and you can export the results back into your sheet.
Zaram provides tracking data automatically—opens show up in your email provider's analytics or via a tracking link you include in the email. When you send, also update column J (Date Sent) in your sheet with the send date.
Never send all 500 emails on Monday morning. Spread sends across 3–4 days, varying send times. Subject line "Quick question about [company]" sent Tuesday at 10 AM will have a different open rate than Friday at 6 PM.
This is where discipline matters. Every day, spend 10 minutes updating your sheet with the previous day's results:
Update this weekly. If you wait until the end of the month, you'll lose context and miss follow-up windows.
Download a targeted list of businesses with real emails and phone numbers — by niche and country — in seconds. Sign up free, pay once, pitch immediately.
Get My Lead List →Raw data means nothing. You need insights. Here are the formulas to add to your sheet (I'll put them in a "Metrics" section at the top or bottom of your sheet):
In a cell, type:
=COUNTIF(K:K,TRUE)/COUNTA(D:D)*100
This divides total opens by total emails sent, multiplied by 100 for percentage. If you sent 100 emails and 28 opened, you get 28%.
=COUNTIF(N:N,TRUE)/COUNTA(D:D)*100
If 100 emails sent and 7 replies, you get 7% reply rate. (Industry benchmark: 2–5%.)
=COUNTIF(S:S,"Deal Won")/COUNTA(D:D)*100
Tells you what percentage of your outreach actually converted to paying work.
If you paid ₦40,000 for 17,000 leads from LeadsHub and sent 500 emails, your cost per lead is ₦40,000 ÷ 500 = ₦80 per email.
Cost per conversion = ₦40,000 ÷ (number of deals) = your actual customer acquisition cost.
=AVERAGEIF(S:S,"Deal Won",T:T)
This calculates the average USD value of deals you've won. (See the example below.)
Let's say you're a video editor in Ibadan and you send 100 cold emails to e-commerce businesses in Lagos:
| Metric | Result | What It Means |
| Emails Sent | 100 | Your outreach size |
| Emails Opened | 26 | 26% open rate (good for cold email) |
| Replies Received | 4 | 4% reply rate (above average) |
| Positive Replies | 2 | 50% of replies were interested |
| Deals Won | 1 | Conversion to paid work |
| Deal Value | $800 (≈₦528,000 at ₦660/$) | What you earned |
| Cost Per Lead | ₦80 (40,000 ÷ 500 emails from lead list) | Paid for every email sent |
| Cost Per Conversion | ₦40,000 ÷ 1 deal = ₦40,000 | You spent ₦40,000 to earn ₦528,000 (ROI: 1,220%) |
One deal covers your lead list cost 13 times over. That's why tracking matters—you can now justify spending money on leads and prove that cold email works.
In your "Metrics" section, create a pivot table to compare open rates by subject line:
Stop using "Partnership opportunity." It doesn't work for your audience. Double down on the specific-problem subject line.
Do video production companies reply more than logistics businesses? Use COUNTIFS to measure:
=COUNTIFS(G:G,"Video Production",N:N,TRUE)
This counts replies only from the Video Production industry. Compare across industries and focus your effort where it works.
If you're testing two email templates, compare their reply rates and conversion rates. This is how you optimize your pitch.
Track when you sent follow-ups (column R) and how many turned into deals. You might find that following up 5 days later converts better than 3 days—that's gold.
Select your Status column (S) and apply conditional formatting:
Instantly, you see your pipeline. You can scan 200 rows and spot trends in seconds.
Also format Column K (Email Opened?) with conditional formatting—green for TRUE, red for FALSE. You'll immediately see which batches had low open rates.
You're now using LeadsHub (for leads), Zaram Web Mailer (for sending), and Google Sheets (for tracking). How do they talk to each other?
The workflow:
It's not fully automated, but it takes 10–15 minutes per day and gives you perfect visibility.
At the end of each month, create a simple summary on a new sheet called "Monthly Summary":
This becomes your system's report card. Share it with yourself monthly (or a coach/partner if you're in a group). It shows whether cold email is actually working for you.
A: Open rate tracking depends on your email provider. Gmail marks emails as "opened" when images are loaded. Zaram Web Mailer uses pixel tracking, which is reliable to about 95%. The percentage might be 2–3% off in either direction, but it's good enough to spot trends. What matters is whether Template A has a 25% open rate and Template B has a 32%—the gap is real.
A: Absolutely. Add a column "Phone Contacted?" and "Phone Call Result?" Some Nigerian businesses prefer voice calls to emails. If you're doing outreach, include phone follow-ups after 3 days of no email response. Log the date, who answered, and what they said. You might find phone converts better than email for your niche.
A: Start with 25–50 per week to test your templates and subject lines. Once you see a 3%+ reply rate and your conversion is positive (e.g., ₦40,000 spent on leads = ₦200,000 in deals), scale to 100–200 per week. If you're already tracking with your sheet and know your numbers, you can be confident in scaling. Most successful Nigerian freelancers run 200–400 weekly once they optimize.
A: Mark them as "Interested but Unresponsive" in your Status column. Send one more follow-up 7 days later with a different angle (e.g., "Still interested in talking about improving your product videos?"). If no reply after that, mark as "Dead." Track this in your Notes column: "Ghosted after initial interest." Over time, you'll find that some segments (e.g., startups vs. established companies) ghost more than others—adjust your targeting accordingly.
You don't need a ₦10,000/month email marketing platform to run professional cold email campaigns. Google Sheets—free, simple, and in your hands—is enough to track opens, clicks, replies, and revenue at scale.
Here's what you're going to do:
One more thing: read our guide on how to get email lists of Nigerian businesses to understand where your leads come from, and check out our deep dive on Nigerian business contact sourcing for advanced targeting strategies.
Cold email in Nigeria isn't a lottery. It's a system. And once you track it, you control it.
Your move.
Read next
Practical tips on finding clients, cold outreach, earning in dollars, and growing your freelance income — free, every week.
No spam. Unsubscribe anytime.