Score and Rank a B2B Prospect List Against Your ICP Criteria

Returns a weighted scoring model and a ranked account table where every point cites the data field that earned it, with missing data flagged instead of guessed.

You getScoring model, ranked table and disqualified or unverified

Prompt

Prompt
You are a B2B sales operations analyst who builds account scoring models for outbound teams.

Your job: score and rank a prospect list against my ideal customer profile (ICP).

First, ask me these questions in one message, then wait:
1. Who is your ideal customer (industry, company size, region, tech stack, other traits)?
2. Which criteria are must-haves that disqualify an account if failed?
3. How should criteria be weighted? If I'm unsure, propose weights totalling 100.
4. Paste the prospect list (CSV or table, any columns).

Rules:
- Every score cites the exact column and value that earned it, e.g. "Employees = 420".
- If a needed field is blank or unclear, score that criterion 0, flag the row and name the missing field. Never guess or fill in data from memory.
- Accounts that fail a must-have, or where a must-have field is blank, go to a separate list, not the ranking.
- Break ties by the highest-weighted criterion.

Output format:
1. Scoring model: table with Criterion | Weight | How points are awarded.
2. Ranked table: Rank | Account | Score /100 | Breakdown with cited fields | Data gaps.
3. Disqualified or unverified: account and the must-have it failed or lacks.
4. Work first: top 3 accounts, one line each on why.

End with one line naming which missing fields would most change the ranking.

Example output

At a glanceRanked ICP scores for six qualified accountsTwo more accounts were held out: Northgate failed the US HQ rule and Valence has no HQ data.
  • Harlow Freight: 100
  • Brightline Cold Chain: 90
  • Kestrel Logistics: 80
  • Mason & Pike Distribution: 75
  • Pinecrest Foods: 60
  • Ortega Haulage: 55

Example for: a SaaS rep selling dispatch scheduling software to US logistics firms, 8-account list, must-have = US headquarters.

1. Scoring model

CriterionWeightHow points are awarded
Industry fit30Trucking, 3PL, logistics = 30; adjacent (wholesale, food manufacturing with own fleet) = 15; other = 0
Employee count30200–2,000 = 30; 100–199 or 2,001–5,000 = 15; other = 0
CRM20Salesforce = 20; other CRM = 10; blank = 0
Open ops roles205+ = 20; 1–4 = 10; 0 or blank = 0

2. Ranked table

RankAccountScoreBreakdown with cited fieldsData gaps
1Harlow Freight100Industry = Trucking (30); Employees = 640 (30); CRM = Salesforce (20); Open ops roles = 7 (20)None
2Brightline Cold Chain90Industry = Cold storage logistics (30); Employees = 1,850 (30); CRM = HubSpot (10); Open ops roles = 5 (20)None
3Kestrel Logistics80Industry = 3PL (30); Employees = 310 (30); CRM = blank (0); Open ops roles = 6 (20)Missing: CRM
4Mason & Pike Distribution75Industry = Wholesale distribution (15); Employees = 1,200 (30); CRM = Salesforce (20); Open ops roles = 2 (10)None
5Pinecrest Foods60Industry = Food manufacturing (15); Employees = 2,600 (15); CRM = Salesforce (20); Open ops roles = 3 (10)None
6Ortega Haulage55Industry = Trucking (30); Employees = 150 (15); CRM = Zoho (10); Open ops roles = blank (0)Missing: Open ops roles

3. Disqualified or unverified

  • Northgate Carriers: HQ = Toronto, Canada. Fails US headquarters must-have.
  • Valence Transport: HQ field is blank. Held out until location is confirmed; would score 85 on other criteria if US-based.

4. Work first

  1. Harlow Freight: perfect fit on all four criteria and 7 open ops roles suggest active dispatch pain.
  2. Brightline Cold Chain: strong size and industry fit; HubSpot means a lighter integration conversation.
  3. Kestrel Logistics: high-fit 3PL that is hiring; confirm CRM on the first call.

Missing data that would most change the ranking: Valence Transport's HQ (could enter at #3) and Kestrel's CRM (could move it to #1 tied, behind Harlow on the tiebreak).

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Asking for ICP, must-haves and weights first means the score reflects your market, not a generic fit model.
  • Citing the exact field and value behind every point makes the ranking auditable and easy to challenge.
  • Scoring blanks as 0 and flagging them stops the model from inventing firmographics it cannot verify.

Use before an outbound sprint or territory planning. Have your ICP, must-haves and the prospect list (exported CSV is fine) ready to paste into ChatGPT, Claude or Gemini.

Common edits

  • Add a fifth criterion such as recent funding or a competitor tool in the tech stack.
  • Ask for the ranked table as CSV so you can paste it straight back into your CRM or spreadsheet.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Sales