Resource · Last updated July 14, 2026 · By the ColdDMCalculator team
Cold DM Lead Tracking Spreadsheet: Free Template Guide
A spreadsheet is the simplest way to track every lead from first send to closed deal. This guide gives you the exact column structure, formulas, and setup steps to build a lead tracker that captures the metrics that matter.
Column structure
Each row represents one prospect. Each column captures a specific data point. This structure supports A/B test tracking, follow-up scheduling, and conversion reporting.
| Column | Purpose |
|---|---|
| Contact name | Full name of the prospect |
| Company | Company name for context and segmentation |
| Role / title | Job title to verify targeting fit |
| LinkedIn URL | Direct link to profile for quick reference |
| Source | Where you found them (search, referral, event) |
| Send date | Date the first message was sent |
| Script variant | Which A/B variant was used (A, B, etc.) |
| Reply status | No reply / Replied / Positive / Negative |
| Reply date | Date of first reply |
| Positive reply? | Yes / No — expressed genuine interest |
| Follow-up 1 sent | Date of first follow-up |
| Follow-up 2 sent | Date of second follow-up |
| Meeting booked? | Yes / No — meeting scheduled |
| Meeting date | Date of booked meeting |
| Deal value | Projected or actual deal value |
| Stage | Cold / Replied / Interested / Meeting / Closed |
| Notes | Any relevant context for follow-up |
Setup steps
- Create a new Google Sheet or Excel workbook named 'Cold DM Lead Tracker'.
- Add the column headers listed above in row 1.
- Freeze row 1 so headers stay visible when scrolling.
- Add conditional formatting: green for 'Positive' replies, yellow for 'Meeting booked', green for 'Closed'.
- Create a 'Dashboard' tab with formulas: =COUNTIF for each stage, =COUNTIF for reply rate, =COUNTIFS for conversion rates.
- Add data validation for the 'Reply status' and 'Stage' columns to prevent inconsistent entries.
- Set up a filter view so you can sort by script variant, stage, or date without disrupting others.
Dashboard formulas
Add these formulas to a separate 'Dashboard' tab to auto-calculate key metrics from your lead data.
Total leads
=COUNTA(A:A)-1
Reply rate
=COUNTIF(H:H,"Replied")/COUNTA(A:A)-1
Positive reply rate
=COUNTIF(I:I,"Yes")/COUNTIF(H:H,"Replied")
Meeting rate
=COUNTIF(M:M,"Yes")/COUNTIF(I:I,"Yes")
Close rate
=COUNTIF(P:P,"Closed")/COUNTIF(M:M,"Yes")
Pipeline value
=SUMIF(P:P,"<>Closed",O:O)
How to Use This Resource
- Set up the spreadsheet before your first send — not after 200 leads are already in the pipeline.
- Update daily. Log every send, reply, and follow-up as it happens.
- Use the dashboard tab to monitor conversion rates at each stage — this tells you where to focus improvement efforts.
- After the campaign, use the data to populate the Cold DM Calculator with your actual rates.
This resource is for educational planning purposes. Results vary based on execution, audience, and platform rules.
Related: All Resources · KPI Tracker · Lead Qualification Checklist · Calculator
Frequently asked questions
Why not just use a CRM?
A CRM is great for established pipelines, but for cold DM outreach, a spreadsheet gives you faster access, easier filtering by script variant, and simpler reporting. Many operators start with a spreadsheet and migrate to a CRM once the campaign scales past 500 leads.
How often should I update the spreadsheet?
Daily. Log every send, reply, and follow-up as it happens. Waiting until the end of the week leads to missed entries and inaccurate metrics. If you're sending 30 DMs per day, updating takes less than 5 minutes.
Should I track negative replies?
Yes. Negative replies tell you about targeting quality. If a high percentage of replies are negative (not just no-reply, but active rejections), your audience criteria may be too broad.
What's the minimum I should track?
At minimum: contact name, send date, reply status, positive reply, meeting booked, and deal value. Everything else is helpful but not essential for core metrics.
Track your leads from send to close.
Pair your spreadsheet with the calculator for complete campaign visibility.
Forecasts are estimates based on user-provided assumptions. Results are not guaranteed.