Tracking Cold Calls in a Spreadsheet That Counts What Closes

To track cold calls, log every dial attempt as its own row in one sheet. Pick the outcome from a fixed dropdown, and let a weekly review tab count the rows with COUNTIFS. Dials, connects, meetings booked and follow-ups due all come out of that one log. It works in Google Sheets or Excel, and you do not need to buy a dialer.

A disclosure: my agency books meetings mostly through cold email and LinkedIn, with no cold dialing at all. If a client wants the phone, we call warm lists only: people who replied, engaged or opted in.

The rule that makes it work is one row per attempt. If you overwrite a contact's row every time you call, the history disappears. You can still count people, but you can no longer count effort. Three tries at the same buyer should show up as three rows.

Why does the call log also track email and LinkedIn touches?

Most cold-call logs stop at the dial. Mine does not, because the sale is happening online before the call, not on it. By the time the phone rings, the buyer has already checked you out. So the log records what they saw first: the email and LinkedIn touches either side of each call.

Which columns does a cold call log need, and what values go in each?

Paste these headers into row 1 of a tab named Log. The letters matter, because the formulas further down point at them.

Keep the outcome codes exactly as written, because COUNTIFS matches text character for character. Use "Gatekeeper" when someone other than your contact picked up. Use "Not now" when your contact answered and declined for the moment. Use "Callback set" when they agreed to a time. "Do not call" means they objected, and that code feeds the compliance columns in the next section.

Google Sheets. Select column I, then choose Insert > Dropdown, or Data > Data validation > Add rule, and type the values. By default, Sheets rejects anything that is not on the list. Leave it that way. The "Show a warning" option under Advanced options lets off-list values in, and one typo like "voicemial" quietly drops out of your counts (Google Docs Editors Help).

Excel. Select the column, open Data > Data Validation, set Allow to List, and type the values in Source separated by commas. Make sure the In-cell dropdown box is checked. On the Error Alert tab, choose the Stop style so a wrong code has to be fixed before it can be saved (Microsoft Support). Set this up before you share or protect the workbook. Excel will not let you change validation on a shared workbook or a protected sheet.

For Follow-up date, use a Date rule set to "between". Microsoft's own example limits dates to =TODAY() through =TODAY()+3. Copy the pattern with whatever window your sequence needs, for example =TODAY()+30, so nobody types last year by accident.

In our email and LinkedIn campaigns, replies tend to come late. Most arrive on the third follow-up. That only works when real days pass between attempts. Space the column K dates for that.

Columns L and M exist for the same reason. I never stop at one or two messages: I plan at least 5 to 6 touches, spread over more than one channel where I can. A call is one of those touches, so the sheet shows what came before and after it.

Which compliance columns should the sheet carry before anyone dials?

Add these to the right of the call columns. Fill them in before the first dial.

This section covers the UK and the US only. EU countries have their own national rules, so check local law before dialing there.

UK. For live B2B calls, the ICO says numbers on the TPS or on the corporate register (CTPS) are off limits unless that business has consented. You screen against both registers and against your own do-not-call list (ICO B2B marketing guidance). Columns R, S and T record that check. The same guidance treats sole traders and some partnerships as individual subscribers, which is why column Q exists. Expect changes here: the ICO flags this page as under review after the UK's 2025 data reform law.

Regulation 21 of PECR bars calls to a subscriber who has told you not to call that line, and calls to a number on the register. The exception is a subscriber who has said it currently has no objection. That permission can be withdrawn at any time (PECR regulation 21). Column U holds the objection date. Column V holds the permission, if you have one.

The ICO's PECR guide expects records showing what each person agreed to, the date, and the way consent was obtained. It also says callers must say who they are and display their number (ICO guide to PECR). Column X shows whether your number was displayed on each call.

US. According to the FTC's Telemarketing Sales Rule guidance, the rule leaves out the majority of telemarketer-to-business calls. Calls that sell nondurable office or cleaning supplies are covered. Calls to a business line that pitch employees on buying for their own personal use are covered too.

The FTC's Do Not Call Q&A adds that most calls asking a business to buy for itself are exempt from those provisions. Column W flags the rows that fall outside the usual exemption.

If column W ever says anything other than "Business use", stop and get advice. This is not legal advice.

What formulas turn the log into weekly metrics?

Make a second tab called Review. Put the Monday of the week you are reviewing in B1, then name that cell WeekStart (Data > Named ranges in Sheets, Formulas > Define Name in Excel). Add three helper columns on the Log tab: Z for Hour, AA for Weekday, and AB for Connected, with this formula in AB2:

=IF(OR(I2="Not now",I2="Callback set",I2="Meeting booked",I2="Do not call"),"Yes","No")

A connect here means you reached the named person, whatever they said.

How do you read B9? Gong's analysis of 300 million calls, as summarized by Trellus, reports a 5.4% connect rate for the average rep and 13.3% for the top quartile. They count calls answered by a prospect divided by dials, the same math as B3/B2. Trellus notes these are vendor-reported figures that do not describe every industry. Treat them as a rough range to compare against.

If B10 stays low, look at your 30-second opener and your replies to brush-offs before you blame the sheet.

The Done value in column J keeps the follow-up counts honest. When you complete a follow-up, set the old row's Next step to Done and log the new attempt as a new row.

To compare weeks, put =B1-7 in C1, =C1-7 in D1 and so on, then copy the B2:B11 formulas across and replace WeekStart in each column with that column's own row 1 cell (C$1, D$1 and so on). A named range does not shift when you copy it.

That gives you four weeks side by side. Month by month, a US coaching and consulting client of ours went from 27 booked calls to 35, then 64, all from LinkedIn outreach and LinkedIn content, with no phone involved. A weekly view shows that kind of ramp early.

Plan for no-shows on calls booked from cold outreach from day one: there is always a gap between meetings booked and meetings held.

When in the day and week do your calls actually connect?

Put =HOUR(C2) in Z2 and =TEXT(B2,"ddd") in AA2, then fill both down.

Build a pivot table from the Log tab. Use Hour as the rows, Outcome as the columns, and the count of Call ID as the values. Then show the values as a percentage of each row.

Google Sheets can show each value as a share of the whole (Google Docs Editors Help, pivot tables). Build a second pivot with Weekday as the rows to see the same pattern by day.

There is one trap. If you filter a Sheets pivot by values, new rows are not picked up automatically. You have to update the filter after the source data changes. Make that check part of the weekly review, or the pivot will ignore your newest calls.

ZoomInfo's analysis of over 1.4 million outbound calls found Tuesday and Wednesday were the top days. Together they accounted for 44% of all booked demos. ZoomInfo also advises treating published timing benchmarks as starting points. Industry, seniority and geography can produce a different pattern for you.

So a safe rule: do not move your call blocks after a single good Tuesday. Wait until the same hour leads for several weeks running in your own data, then shift one block at a time.

How long can you keep call records, and what must never be deleted?

In the UK there is no fixed number. The ICO says UK GDPR sets no specific time limits. You should not keep data indefinitely "just in case". You need to set and document retention periods (ICO storage limitation guidance). The same guidance allows you to keep enough about someone who objected to stop marketing to them in the future.

That leads to a tab you never delete: Suppression. Any row with "Do not call" in column I, or a date in column U, gets copied there with only the phone number, company, name and objection date. Before every calling session, check new numbers against it. Delete someone from Suppression and they end up back on your call list.

In the US, most B2B calls never reach this point, because of the exemptions above. Where the TSR's recordkeeping does apply, 16 CFR 310.5 lists the call records to keep for 5 years.

They include the calling and called number, date, time and duration, the disposition, and whether the call went to a consumer or a business. Time and duration go to the closest second, with time in UTC (eCFR, 16 CFR 310.5).

For the practical routine, fill column Y with your documented period. For example, =EDATE(B2,12) if you chose 12 months. Once a month, filter for Delete after earlier than today, copy any objectors to Suppression, and delete the rest.

When should the spreadsheet become a CRM?

The trigger is ownership. A sheet works while one person makes the calls, reads every reply and owns every follow-up date.

I keep every lead in a CRM so none gets lost, whichever CRM it is, and every reply needs one home before outbound starts. I also put one inbox manager on replies, so nothing slips through while the callers keep calling. If you also want a deal-stage view once a meeting is booked, a sales pipeline built in Excel covers that.

When you import, map the columns one to one. Outcome becomes an activity type, Follow-up date becomes a task, and the compliance columns become contact properties. Import the Suppression tab first, so the CRM blocks those numbers from day one. If two people call, divide the accounts between them so nobody touches the same leads, and use column D to enforce it.

What does the full funnel look like when calls are only one step?

Count the stages between a reply and a signed contract. In one month for a German software development company, run on cold email and LinkedIn with no phone involved, 34 meetings were booked, 28 were held and 4 became contracts. Every stage loses people, and a log that stops at "booked" hides that loss.

That is why the Log carries Showed and Signed in columns N and O, right next to Outcome. If your review tab stops at meetings booked, you are scoring yourself on the easy half. I judge a campaign by what closes, because a booked call is worth nothing until someone closes it, and what happens after the call is booked decides most of the result.

Add Showed and Signed on day one, and read row B11 before you celebrate row B4. More dials will not fix a weak close. A funnel that leaks at small volume will leak at big volume too. Fix the close first. Then dial more.

Building your own call log and unsure which columns your team really needs? Book a call and send me your draft sheet. I will tell you what I would cut or add.