Updated 4 min read

Free call log template: who your reps called, and who to call back

Seven columns and six outcome words, so a rep can fill in a row before dialling the next number. Free for Word and Excel, no sign-up.

Your team's calls and callbacks on one page

Give each rep a copy. Copy it, print it, or download the Word or Excel file. In Excel, Outcome is a drop-down and the counts add up on their own.

Sales call log: [your name]

Date: [date]. Calls planned: [number].

Calls

TimeName and companyNumberNew or follow-upOutcomeWhat they saidNext step and date
[Time][Name, company][Number][New or follow-up][One word from the list][One line][What you'll do, and the date]

Outcomes: pick one per call

  • Spoke: booked. A meeting is in the diary.
  • Spoke: call back. They gave you a day to call again.
  • Spoke: no. Write down why.
  • Gatekeeper. You spoke to someone else. Get the right name.
  • Voicemail. Write down when you'll try again.
  • No answer.

The day's count

  • Calls made: [count]
  • Spoke to the person: [count] (every "Spoke" row)
  • Meetings booked: [count]
  • Calls per meeting booked: [number] (calls made divided by meetings booked)
  • Callbacks due next: [names and dates]

Download for Excel Download for Word

What to put in a call log

A call log is one row for each phone call, saying who you rang, when, what happened and what comes next.

ColumnWhat it gets you
TimeWhich hours people pick up, once you have a few weeks of rows
Name and companyThe right person to ask for next time
NumberNo digging for it when the callback comes up
New or follow-upWhether calls are finding new people or circling the same ones
OutcomeTotals that add up, because everyone uses the same six words
What they saidThe one line your rep wants to read before calling back
Next step and dateWho's due a call, and when

Other call logs add call length or a department. Add a column if someone will read it. If it stays blank for a week, delete it.

Three rules that keep a call log filled in

  • Fill in the row before dialling the next number.
  • Use the same six outcome words, so one rep's "no answer" means the same as another's.
  • Give every call where someone spoke a next step and a date.

What the count tells you

The bottom of the page takes two minutes. Reps count calls made, conversations and meetings booked, then copy their callbacks into the calendar.

Calls per meeting booked is the number to watch. One day is too noisy, so use four weeks. In a made-up month, 800 calls and 40 meetings come to 20 calls per meeting, and now a rep knows what next month's meetings will take.

A filled-in call log: 10 calls, 4 conversations, 1 meeting

Aisha Rahman is a made-up rep, calling made-up people. She's planned 40 calls for Thursday 24 September, and these are her first 10, with the numbers left out.

TimeName and companyNew or follow-upOutcomeWhat they saidNext step and date
9:02Tan Wei Ming, Harbour DentalNewNo answerTry Fri 25 Sep, 8:30 am
9:06Lena Goh, Kestrel LogisticsFollow-upSpoke: bookedWants prices for 12 driversDemo Tue 29 Sep, 10 am
9:11Front desk, Northgate PrintNewGatekeeperThe owner is Sam Ong, in after 2 pmCall Sam, 2:30 pm
9:15Ravi Menon, Brightside CafeNewVoicemailLeft a 20-second messageTry Fri 25 Sep
9:19Joy Lim, Apex TuitionFollow-upSpoke: call backSets next year's budget in OctoberCall Mon 5 Oct
9:24Mark Chen, Tide GymNewSpoke: noSigned with another supplier in AugustTry again in March
9:28Nur Aina, Oakline RealtyNewNo answerTry Mon 28 Sep, 4 pm
9:31Ben Ho, Summit ClinicsFollow-upVoicemailEmailed the one-pager as wellTry Mon 28 Sep
9:36Kim Yeo, Leafy FloristNewSpoke: call backAsked for a customer exampleSend it, then call Wed 30 Sep
9:41Omar Aziz, Cobalt FreightNewNo answerTry Thu 1 Oct, 3 pm

It adds up to 10 calls made. She spoke to the person 4 times: Lena, Joy, Mark and Kim. One meeting booked means 10 calls per meeting so far. Her next callbacks are Sam at 2:30 pm, then Wei Ming and Ravi on 25 September.

How to change it for each kind of calling

When it'sChange this
A cold calling blockFill in Name and company for the whole list first, so reps only type the outcome between dials.
Follow-upsStart from the Next step column, oldest date first. Read What they said before dialling.
Inbound callsWrite "In" under New or follow-up, and put how they heard of you in What they said.
One log for the teamAdd a Rep column and keep one sheet. Agree the outcome words first, or the counts won't match.
A rep's first monthCount every day, even when it's small. After four weeks, calls per meeting is their own number to plan from.

Marketing calls to Singapore numbers

If your reps market to people on Singapore numbers, add a DNC checked column with the date of the check. The PDPC says of a Do Not Call check: "Results are valid for 21 days from the date the check was conducted." The Act leaves out "any message sent to an organisation other than an individual acting in a personal or domestic capacity", so read the rules against who you call.

Counting calls without adding up the sheet

This log works, and it holds what no count can: who said what. It's also the tab somebody has to remember to fill, and you only see the total once someone adds it up.

Palby Sales Tracker does the counting. A call is one tap on the rep's phone, or /log in a private Telegram chat, and the board moves within seconds. A wrong tap can be undone. Nothing can be dated more than 7 days back, late entries get marked, and you can read every edit for 14 days. It can't prove a logged call happened. Names and callbacks stay in your log. See how calls are logged.

30 minutes. You choose the day and the time.

Book a walkthrough

Keep reading

Common questions

Sources

Keep the log for what they said, and let one tap count the calls

See a call go from a rep's phone to the board in a walkthrough.

Book a walkthrough

30 minutes. You choose the day and the time.