Lead scoring template: which contacts to call first

Free lead scoring template in Excel with a filled-in example. Score each lead from 0 to 100 and know who to call today.

The template’s “Example” tab, completed using the case of a payroll firm.

The template in figures

100 maximum points per contact
5 yes-or-no questions
4 points for each “yes”
Leave us these three details and the download will appear right here, instantly.
Name *
Business email *
Company *

What the lead scoring template includes

An Excel spreadsheet that takes one minute to complete per contact and calculates everything automatically, using the same points as NextBlog.

Points based on what each lead has done

Downloading a guide, requesting a quote, or requesting a call: each action earns 25, 50, or 75 points depending on how close it is to a purchase.

Five yes-or-no questions

Whether they fit your ideal customer profile, whether they make the purchasing decision, whether they have the problem, whether they have looked at prices, and whether they have given a timeframe. Each “yes” adds 4 points.

Lead temperature and what to do

Hot, warm, or cold, with the appropriate action: call within 24 hours, send content on their topic, or let them mature.

A completed real-world example

One month’s contacts from a payroll firm, already scored, so you can see how to fill it in before you start.

How to do lead scoring step by step with the template

Five steps: half an hour the first time; after that, one minute per contact.

Choose the actions that count

Record what a contact can do with you, from downloading a guide to requesting a quote, and what stage of the buying process each action corresponds to.

Record every lead

One row per contact, showing the most advanced action they have taken to date.

Answer the five questions

Yes or no. If you cannot determine one, leave it as no.

Check the temperature

Hot leads at the top: these are the ones sales needs to call today.

Update it as things progress

If a contact requests something else, change their action and the score will increase automatically.

Frequently asked questions about lead scoring

Answers to your most common questions

What is a lead scoring template for?

To decide every morning who sales should call and who not yet, know how many hot, warm and cold contacts each month brings, stop chasing people who are only researching, and have the whole team score with the same criteria.

What is lead scoring?

It means scoring each contact based on how close they are to buying and how well they fit your ideal customer profile. It helps sales call those most likely to close first, rather than the most recent lead.

How is a lead score calculated?

In the template, the most advanced action taken provides the base score: 25 if they are gathering information, 50 if they are comparing options, and 75 if they want to buy. Five yes-or-no signals add 4 points each. A confirmed meeting brings the score to 100.

What is the difference between a cold, warm, and hot lead?

Cold, fewer than 50 points: they are gathering information, and it is not yet time to call. Warm, 50 to 74: they are comparing options and would benefit from content on their topic and a meeting proposal. Hot, 75 or more: they want to buy and should be called within 24 hours.

Why can a lead that is a perfect fit still be cold?

Because being a good fit does not mean being in a hurry. The signals add no more than 20 points: a contact who has only downloaded a guide remains cold even if they are your ideal customer, until they request something else.

Does it work for B2B and service companies?

Yes, it is designed for that: companies that sell to other companies and where a contact takes weeks or months to decide.

What do I need to use the template?

Excel. It includes instructions and a completed example for a payroll firm, so you can see how to fill it in before you start.