Ideal customer profile worksheet: a 2026 template that turns into a score
The classic ICP worksheet describes a customer. This one ends in fields your CRM can score, because a profile nobody acts on is just a poster.
Most ICP worksheets look the same. A grid of firmographic boxes, a persona section, one line for the value proposition. Fill it in, file it, move on. That format made sense when a rep found a lead and the lead waited for the rep. It does not match how buying works in 2026.
Buyers now choose before they talk to you. In 6sense’s 2025 Buyer Experience Report, a study of nearly 4,000 B2B buyers, the vendor that won was already on the buyer’s Day One shortlist 95% of the time, and buyers made first contact about 61% of the way through their journey. Gartner’s 2026 buyer research found 45% of buyers used generative AI during a recent purchase, and consulted an average of seven information sources along the way. And the customer is not one person. Gartner puts B2B buying groups at five to 16 people across as many as four functions.
Meanwhile, the data an ICP runs on is thinner than most teams think. In Validity’s State of CRM Data Management in 2025, 76% of CRM users said less than half of their organization’s CRM data is accurate and complete.
So the worksheet has to do more than describe a customer. Here is a version built for how teams actually sell now.
Five upgrades to the classic worksheet
- Built from evidence, not memory. Start from closed-won and closed-lost records, not a list of favorite logos.
- Fit and timing, kept apart. Who is a good customer and who is ready now are different questions.
- A buying group, not a persona. Map every role that can say yes or no.
- A negative profile. Write down who you do not want, so the model can subtract.
- An evidence column that points at a field. Every row names its source, your confidence, and the CRM property that holds it.
The rest of this piece walks through the worksheet section by section. Copy the tables into a doc or a sheet and fill them in as you go.
Before you fill anything in: name the outcome
Fit for what. The accounts most likely to close, the ones that close fastest, the ones that expand, the ones that stay. These are different questions, and they produce different profiles. Pick one outcome for this worksheet. You can build a second one later for expansion.
Then pull two lists from your CRM:
- Your best 20 customers against that outcome. Won, retained, growing. Pull them from the data, not from memory. Memory overweights recent, loud, and big-logo deals.
- Your worst 20. Closed-lost after real effort, churned in year one, or so expensive to serve they were not worth it.
Every row of the worksheet should be a pattern that shows up in the first list and not in the second.
Part 1: Firmographic fit
Who they are. This is the section the classic worksheet covered well, with two changes: get specific, and write down where each answer lives in your CRM.
| Field | What to capture | Example CRM property |
|---|---|---|
| Industry | The sub-vertical, not the category. “Mid-market logistics software,” not “SaaS.” | Industry |
| Business model | Who they sell to and how: B2B or B2C, sales-led or product-led. | Custom property |
| Geography | Where you can sell, support, and meet any regulatory needs. | Country, region |
| Company size | Employee band and revenue band. Add growth rate if you can get it. | Number of employees, annual revenue |
| Team size | The size of the team that will use your product, which drives seats and how many people you must convince. | Custom property |
| Stage and ownership | Venture-backed, PE-owned, public, bootstrapped. Each buys differently. | Custom property |
| Current spend | What they spend on this problem today, including people and workarounds. | Captured on the deal |
Part 2: Technographic fit
What they run. For most B2B products this is one of the strongest fit signals, and the classic worksheet left it out.
- Required systems. What must be in place for your product to work? A CRM, a data warehouse, a specific edition.
- Adjacent tools. What do your best customers tend to run alongside you?
- Competing tools. Is a competitor installed, and when did they buy it? A tool bought three months ago is a disqualifier. One up for renewal in 90 days is a signal.
- Data maturity. Do they have someone who owns the systems, or is the CRM a shared junk drawer?
Part 3: Timing signals
Fit tells you who. Signals tell you when. The old worksheet treated them as one thing, which is why reps kept calling perfect-fit accounts that had no reason to buy this quarter.
| Signal | Why it matters | Goes stale after |
|---|---|---|
| New leader in a buying role | New CROs and marketing leaders often change tools in their first two quarters. | About 6 months |
| Hiring for the team you serve | Headcount growth creates new work and new budget. | About 3 months |
| Funding or acquisition | New money and new mandates. | About 6 months |
| Competitor contract nearing renewal | A natural decision window. | The renewal date |
| Visits to pricing, comparison, or integration pages | Research in progress, from a known contact or company. | About 30 days |
| Repeat engagement from several people at one account | A buying group is forming. | About 30 days |
The last two matter more than they used to. If the shortlist forms before first contact, the research that forms it is where you can still see intent. Your own site and email data is the one signal source you fully own, so make sure it is tied to company records and not stranded on anonymous visits.
Keep timing as its own score, separate from fit. It changes weekly. Fit changes a few times a year.
Part 4: The buying group
Replace the single persona with the roles that decide. For each one, write the titles you actually see on your deals, what they need to believe, and the objection they raise.
| Role | Typical titles | What they need to see | Common objection |
|---|---|---|---|
| Economic buyer | CRO, VP Sales, CMO | A number that moves: pipeline, win rate, cost to acquire | “Is this a priority this year?” |
| Champion | Sales or revenue ops lead, demand gen lead | A clear win they can take credit for | “Will my team actually use it?” |
| Daily user | AEs, SDRs, marketers | Less time spent deciding who to work | “Another tool to check” |
| Technical evaluator | CRM admin, IT, security | Clean integration and permissions | “What does it touch in our data?” |
| Blocker | Finance, procurement, legal | Clear cost and a short, low-risk start | “Why now, and why this vendor?” |
This matters because groups that agree buy better. Gartner found buying groups that reach consensus are 2.5 times more likely to report a high-quality deal, and that 74% of buying teams show unhealthy conflict during the process. A worksheet that names every role is the start of a plan to get them aligned.
Part 5: The negative profile
Write down who you do not want. Pull it straight from your worst-20 list.
- Too small to get value, or too large to serve well.
- Missing a required system.
- Just bought a competitor.
- Churned, and the reasons match a pattern.
- Wrong motion: they want a product you are not, or a service you do not sell.
In the scoring model, these become disqualifying factors that subtract. That way a genuine mismatch pulls a score down instead of hiding behind a good average.
Part 6: The value proposition, by role
The classic worksheet had one line for this. One line cannot speak to a CFO and an SDR at the same time. For each role in Part 4, write three things:
- The problem, in their words. Borrow the phrases from call notes and closed-lost reasons.
- The outcome you deliver. Specific and measurable.
- The proof. A customer result, a benchmark, or a demo moment.
The proof carries more weight than it used to. Buyers arrive with research already done, and Gartner found 69% of them prefer to check what AI told them with a sales rep. Your claims will be compared with what they already read, so they need to hold up.
Part 7: The evidence column
This is the part that makes the worksheet usable. For every row in Parts 1 to 5, record three things:
- Source. Closed-won analysis, customer interview, enrichment provider, or rep opinion. Rep opinion is allowed, but label it.
- Confidence. High, medium, or low.
- Field and coverage. The CRM property that holds the answer, and the share of records where it is filled in.
Coverage decides how much weight a factor can carry. If a field you care about is empty on half your records, it cannot drive the score yet. Fill it first. Until then, a missing value should add nothing to a score rather than count against the account.
From worksheet to score
Now turn the rows into a model. Take the firmographic, technographic, and negative-profile rows with the strongest evidence, group them, and give each group a weight as a share of the score. The negative profile subtracts.
- Industry and size fit 35% 9.1
- Runs a required system 30% 8.4
- Team size in range 20% 7.2
- Matches a churn pattern 15% -3.1
This account looks strong on paper, a 9.1 on industry and size and an 8.4 on systems. The churn-pattern line is what holds it to a 6.7. It resembles customers you lost in year one, and the score says so out loud instead of leaving a rep to find out six months in.
Then put fit and timing side by side to decide who gets worked:
- Fit 7.0 and up, active signals. A rep today.
- Fit 7.0 and up, no signals. Marketing’s job: stay on the shortlist until they are ready.
- Fit under 4.0, active signals. The trap. Lots of noise, poor deals. Route to self-serve or nurture.
- Fit under 4.0, no signals. Leave them alone.
That sorting matters because rep time is scarce. Salesforce’s State of Sales research found reps spend 60% of their time on non-selling tasks. A worksheet that does not change who they call leaves the other 40% unprotected too.
Keep it current
An ICP is a snapshot, and CRM data goes out of date. Put the review on a calendar:
- Quarterly: check field coverage, and compare the quarter’s wins and losses against the profile. Did the top band close? Did anything outside it?
- Twice a year: rerun the best-20 and worst-20 analysis and adjust the weights.
- On any big change: a new product, a new price, or a new segment gets a fresh worksheet.
What you end up with
Not a nicer document. A profile built from evidence, split into fit and timing, mapped to every role in the buying group, with a negative profile that subtracts and an evidence column that points at real fields. From there, the score can live on every record in your CRM, with its reasons one click away, so your team can see who fits and why.