The Lead Scorecard & ICP Template
Ask five people at your company to describe your ideal customer and you’ll get five answers, none of them pulled from the CRM. Then lead scoring gets built on top of whichever answer won the meeting.
This template starts from what closed. Code your last 30 to 60 deals, won and lost, and it shows which titles, company sizes, segments and sources show up in wins and not in losses. That becomes your ICP in plain English, a set of fit points, and a scorecard that grades any lead list in seconds. No CRM setup needed.
$49
One-time payment · instant download
What's inside
| Tab | What it does |
|---|---|
| ICP Builder | Code up to 200 closed deals. Signal tables compare how often each trait shows up in wins against losses, so you see what predicts a win and what's just noise. |
| ICP Summary | Your ICP and your anti-ICP written out in plain English, ready for your positioning doc, ad targeting or a sales brief. |
| Fit Points | Points out of 100 for each trait, with suggested values from your signals, and A to D grade cutoffs you control. |
| Lead Scorecard | Paste up to 300 leads and each gets a fit score and a grade. Test it on 10 leads you already know before you trust it. |
What’s in the files
Real screens from the files. Workbooks are shown with the sample data they ship with; guide pages are shown in part. Click any image to enlarge it.
Who it's for
- B2B teams who want an ICP pulled from their own won and lost deals.
- Teams who want to try lead scoring in a spreadsheet before building it in the CRM.
- Anyone handed an event list or a purchased list who needs to know which leads deserve a rep.
Common questions
Does it work in Google Sheets?
Yes. It's an Excel workbook that works in Excel 2019 or later, Microsoft 365, and Google Sheets.
How many deals do I need?
At least 10 won and 10 lost. 30 to 60 in total gives you a clearer read.
How is this different from the Lead Scoring & Routing Kit?
This template scores who a lead is. The Scoring Kit adds intent scoring and decay, account scoring, the HubSpot and Salesforce build, routing, a sales alignment kit and a health dashboard.
What am I allowed to do with it, and what if something's wrong?
One purchase covers one company: use it across your whole team. Consultants and agencies can use it with clients, one purchase per client company. Please don't resell it or post the files publicly. The files download as soon as you pay, so sales are final, but if a file is broken or doesn't match this page, email [email protected] within 30 days and I'll fix or replace it, or refund you in full if I can't. Fixes and updates to the files are free; email for the latest version or a lost download link. Questions about the files get a reply within two business days. Building it inside your CRM is on your team, or book a working session. Full terms.
Start with what closed
The Lead Scorecard & ICP Template
Your ICP from your own won and lost deals, fit points, and a scorecard that grades any lead list A to D. $49.
Get the TemplateNeed the full build? See the Lead Scoring & Routing Kit.