How to track cold calls
Log who you called, when you called, what happened and what to do next. Keep one record per attempt, with every attempt linked to the same contact.
Start with a simple call log
A spreadsheet is enough for a first calling session. A useful tracker should answer two questions without making you reread every note: who needs a call next, and why?
Download the free cold call tracker CSV. Open it in Excel, Google Sheets or another spreadsheet. The example rows are fictional; replace them with your own appropriate business contacts. No email signup is required.
| Field | What to record | Example |
|---|---|---|
| Contact ID | A stable identifier shared by every attempt for this contact. | LEAD-001 |
| Contact and business | The person you intend to reach and their business. | Alex Smith · Northside Roofing |
| Called at and caller | Date, time, timezone and who made the call. | October 16, 10:00 AM ET · Jordan |
| Outcome | What actually happened on this attempt. | Reached — callback requested |
| Interest | A separate, reviewable assessment of fit or interest. | Interested |
| Short note | Only the context needed for the next conversation. | Asked for pricing; prefers mornings |
| Next action and due time | A concrete step with a time and an owner. | Mia to call October 17 at 10:30 AM ET |
| Do not contact | An explicit opt-out or reason to exclude the contact. | Yes — requested no further calls |
Use outcomes you can act on
Keep the labels consistent: not reached, voicemail, reached, callback requested, meeting agreed, wrong number and do not contact. Keep interest separate from the call outcome. A person can answer the phone without being interested, and an interested person can miss a later call.
Record a callback as a dated task rather than a sentence buried in a note. If someone asks not to be contacted, flag the contact so they are excluded from future calling lists.
A repeatable routine
- Before the session: filter for due follow-ups and eligible new contacts. Check timezones and remove duplicates.
- After each attempt: save the outcome, one useful note and the next action while the conversation is fresh.
- Before stopping: give every open next step a due time. Teams should also name the person responsible.
- At the next session: start from due follow-ups instead of rebuilding a list from memory.
Measure progress without confusing activity with results
Count attempts, unique contacts reached, agreed next steps and completed follow-ups separately. Ten attempts to one person are ten calls, but only one unique contact.
- Connection rate: reached attempts divided by all attempts, multiplied by 100. Use the same definition each week.
- Next-step rate: conversations with an agreed next step divided by reached conversations, multiplied by 100.
- Follow-up completion: due tasks completed divided by tasks due in that period, multiplied by 100.
For example, 20 attempts with 4 reached conversations is a 20% connection rate. If 2 of those conversations have an agreed next step, that is a 50% next-step rate. These are illustrative calculations, not performance benchmarks. Small samples are noisy.
When a spreadsheet becomes hard to maintain
A dedicated cold call tracker becomes useful when repeated attempts, reminders and shared ownership take more effort than the calling itself. Look for editable outcomes, a clear contact history, due follow-ups, export access and transparent calling limits. A team also needs access controls and an obvious owner for each lead.