Skip the filters to search leads. Use AI Search to find prospects instantly.
Skip the filters to search leads. Use AI Search to find prospects instantly.
Lifetime access to 200 email views and 100 export credits every single month
ICP Worksheet Template
Written by:
Abdul Kareem

ICP Worksheet Template: A Free Tool to Define Your Ideal Customer

> Best Practice

How to Evaluate B2B Data Vendors for Accuracy and Compliance

TL;DR

What Is an ICP Worksheet?

Search “ICP worksheet template” and most results hand you a paragraph describing your buyer, not something a rep can actually use on a Tuesday afternoon. This one’s meant to be the other kind: an ICP worksheet template you fill out once, score, and hand straight to sales, plus a companion ICP worksheet template excel download if spreadsheets are more.

All B2B teams talk about ICP marketing, but only a small number use a worksheet that someone will actually open before a call. A genuine ideal customer profile template omits the section on ‘mid-market SaaS companies’ and instead turns firmographics, technographics, and intent signals into fields that can be scored and discussed in a meeting.

What Should an ICP Worksheet Include?

A good ideal customer profile worksheet should include five elements: firmographics, technographics, intent signals, a buyer persona for the person you actually intend to pitch, and a short list of companies that appear very promising on paper yet somehow never result in a closure. If you omit any one of these, the worksheet ceases to function as a filter and becomes merely a wish list.
 
Most teams start off by using an ICP template which B2B representatives are able to complete in under an hour specifying the industry, the number of employees, the revenue band, the geography, the tech stack, and then between three and five trigger events to show that a company is actually in the market now, not just a possible fit.

Firmographics: The Company-Level Filters

Firmographics are the company-level facts you check before anyone cares about technology or behavior: industry, headcount, annual revenue, funding stage, geography. An ideal customer profile template for B2B companies usually starts right here, since firmographic data is the easiest to verify and, ironically, the easiest to get wrong anyway.

Keep the fields the same across departments, otherwise the ideal customer profile template b2b marketing builds and the one sales actually uses end up as two different documents by Q3. Give every firmographic field a floor and a ceiling instead of one magic number. A floor of 50 employees and a ceiling of 2,000 catches a lot more of your real closed-won accounts than the word “mid-market” ever will on its own.

Technographics and Intent Signals

Technographics reveal to you the software a company currently uses, the things it has outgrown, and the gaps in its technology stack that happen to align with the products you offer. If you also take into account intent signals, a sudden increase in hiring, the appointment of a new VP, and enriched ICP data, then ICP data enrichment ceases to be just a task to be ticked off and starts to be genuinely useful.

ICP prospecting moves a lot faster once technographic and intent filters sit on top of firmographics. Reps quit chasing accounts that merely look right on a spreadsheet and start chasing ones that are actually in the market.

Lead Scoring: Turning Fit Into a Number

It is the scoring system that turns an ICP from just a good idea into something that is actually useful. A template that includes scoring assigns a point value to each firmographic and technographic field, places greater emphasis on the factors that correlate with deals that have been closed, and establishes the threshold at which marketing passes an account over to sales.
 

B2B account scoring works a lot better when the weights come from your own win-rate numbers instead of a template you found online. Your top-scoring accounts should be closing at something like double the rate of the partial fits, if they’re not, go back and adjust the weights.

AI-Enhanced ICP Templates

An AI-enhanced ICP template fills itself in, pulling firmographic, technographic, and intent data automatically instead of making someone type twenty fields by hand, then re-scoring accounts as new signals show up. The worksheet doesn’t really change, what changes is how fast it gets populated and whether it’s still accurate six months later.

ICP targeting software that plugs into your CRM can refresh a target account list every week instead of once a quarter, and that gap matters more than people expect, since firmographic and technographic data ages faster than most teams realize.

See What an Ideal Customer Profile Example Looks Like
ReachStream Prospect turns a finished ideal customer profile example into a live, filterable prospect list in a few minutes, matching firmographics, technographics, and intent signals against millions of verified company and contact records.

ICP Template vs Buyer Persona: What's the Difference?

An ICP template is about the company. A buyer persona is about the person inside it you’re actually emailing, their title, what keeps them up at night, why they’d say no. Different documents, different jobs, and teams that merge them usually end up with something too vague to use for either purpose.

Streamlined marketing happens when both get built side by side: the ICP decides which accounts are worth the effort, and the buyer persona decides what to say once you’re in front of the right one.

ICP Layer Must-Have Criteria Signal Weight Data Source Example
Firmographics
Small list of high-priority accounts 
15 to 20 minutes 
Low, does not scale past a short list 
Low, checked in real time by a person 
Technographics
Building lists at volume 
Seconds to minutes 
High, scales to thousands of records 
Depends entirely on provider refresh rate 
Intent Signals
Most sales and marketing teams 
Database for volume, manual for top accounts 
Medium, scales with team size 
Mixed, varies by which method sourced the contact 

How to Fill Out an ICP Worksheet Template, Step by Step

Before opening the worksheet, pull 12 to 18 months of closed-won and closed-lost deals. Guessing at an ideal customer profile without checking who actually bought is how most of these worksheets go wrong in the first place.

Write down every firmographic and technographic field that shows up again and again in the closed-won accounts, then put a point value on each. Add three to five intent signals that tend to show up right before a deal opens. List three to five disqualifiers too. Last step: boil it down to one page a rep can read in under two minutes, not a slide deck that sits in a folder.

Free ICP Worksheet Templates: Excel, Sheets, and Notion

A free ICP worksheet doesn’t need much: firmographic fields, a scoring column, room for three to five intent signals. An ICP template Excel file is a fine starting point if your team already lives in spreadsheets and just wants SUM formulas doing the math. Call it a B2B ICP worksheet or call it your account-scoring sheet, the fields underneath are the same either way.

Not in the mood to build one from scratch? An ICP template free download, Excel, Google Sheets, or Notion, skips the setup and gets a working scoring column on day one.

Common ICP Mistakes to Avoid

Making the ICP too wide is probably the biggest missed step teams make. An ICP that covers half your total addressable market stopped being a filter a while ago, it’s basically a mailing list at that point. Tighten the criteria until it genuinely rules companies out.

The other misstep: building the worksheet once and forgetting it exists. ICP account targeting criteria that made sense last year often misses new segments your product has since picked up. A short quarterly review keeps ICP targeting software and manual worksheets alike from quietly going stale.

Where ReachStream Fits Into Your ICP

Once the ICP worksheet template is actually filled out, the next problem is finding real companies and people who match it. ReachStream turns those filters into a genuine target account list pulled from verified firmographic, technographic, and contact data, so marketing and sales stop working off two different spreadsheets.

ICP data sitting in a worksheet doesn’t do much on its own. Matching it against a live, verified database is what actually turns the exercise into pipeline.

Match Your ICP Against Real Companies
Pull a sample target account list from ReachStream and hold it up against your current pipeline, see how close your real accounts come to your ideal customer profile.

Conclusion

An ICP worksheet template is only worth building if people actually use it. Base it on real closed-won data, keep the firmographic and technographic fields tight, add a handful of intent signals, and review it every quarter. That’s basically the whole system, and it beats trusting a rep’s gut feeling about which accounts seem like a good fit.

Turn Your ICP Into a Prospect List Today
See how ReachStream matches your ICP worksheet template against millions of verified B2B companies and contacts.

Frequently Asked Questions

1. What Is an ICP Worksheet?

An ICP worksheet is a one-page document that turns your Ideal Customer Profile into fields you can actually score: firmographics, technographics, intent signals, each with a point value attached. It’s the working copy of an ICP, the one reps open before a call instead of a slide buried somewhere in Drive.
A complete ICP worksheet template has firmographic filters like industry and headcount, technographic filters for the tools a company already runs, three to five intent signals, a scoring column, and a short list of traits that disqualify a company outright.
Pull 12 to 18 months of closed-won and closed-lost deals, pick out the firmographic and technographic traits that keep showing up in the wins, weight them by how strongly each one predicts a close, then write the whole thing up as a one-page ideal customer profile template.
Start with firmographic fields, industry, size, geography, then move to technographic fields, then three to five intent signals. Score each one, set a threshold for what counts as qualified, and note which account types should be excluded even when they technically check every box.
A B2B company should build the worksheet off real deal data instead of assumptions, keep it to a single page, put a sales or RevOps owner’s name on it, and revisit the weights every quarter so the ICP template B2B teams rely on doesn’t quietly drift out of date.
Firmographic data narrows accounts down by company facts, size, industry, that sort of thing, and technographic data narrows it further by what tools those accounts already run. Score the two separately, combine them into one fit number, then layer intent signals on top of that.
ReachStream checks your finished ICP worksheet template against verified firmographic, technographic, and contact data, and turns the criteria into an actual target account list with real contacts attached instead of a document nobody opens again.
Drop your ICP worksheet’s firmographic and technographic criteria straight into ReachStream’s search filters, then export the matching companies and verified contacts as a target account list that’s ready to work.
Abdul Kareem

Author

Abdul Kareem
Abdul Kareem covers B2B sales and marketing operations at ReachStream. He writes about how sales and marketing teams define, score, and actually act on their Ideal Customer Profile using real pipeline data instead of guesswork.
Share
Table of Contents

Access 200M+ verified business emails and grow your sales pipeline effortlessly.

Power Your Sales with Targeted Data
Abdul Kareem
Abdul KareemAuthor
Abdul Kareem writes about B2B sales prospecting, email deliverability, and cold outreach for ReachStream, focusing on practical guidance that sales and marketing teams can put to use right away.

Don't forget to share this post!

Check out our other blogs!