Assigning points to revenue ranges means slicing company revenue into brackets and giving each bracket a fixed score, so a lead’s size feeds your model instead of sitting in a cell as raw data. A revenue figure like $4,238,000 tells a salesperson something useful; it tells a scoring formula nothing until you bucket it into a tier worth, say, 25 points.
Knowing how to assign points to revenue ranges is the translation step where a lot of B2B teams stall. They know bigger accounts usually matter more, but “usually” doesn’t scale across 10,000 records. You need brackets with defined edges, a point value for each one, and a single formula that scores every row the same way.
It matters because sales attention is the scarcest resource you have. Most B2B traffic never converts (software sites turn visitors into leads at 7.6% and professional-services sites at 6.1%, per Ruler Analytics’ May 2026 benchmark of 110 million sessions), and the leads that do arrive can’t all get the same follow-up. Points on revenue ranges are how you tell your team which accounts earn a same-day call and which go to a slower follow-up queue.
Key Takeaways
- A revenue range is a bracket; each bracket gets one fixed point value, which turns company size into a usable scoring signal.
- Use 3 to 5 brackets, not 10. More brackets add noise, not accuracy.
- Set your cut points at the edges of your ideal customer profile: below your floor scores 0 or negative, your sweet spot scores the maximum.
- Pick an allocation style on purpose: linear, tiered to the top, or weighted to your best-fit band.
- Automate it with a VLOOKUP approximate match (or IFS / XLOOKUP) so one formula scores every record in the sheet.
What it means to assign points to revenue ranges
Assigning points to revenue ranges is the practice of dividing a continuous revenue figure into brackets and giving each bracket a fixed score. It converts company size into a value your lead-scoring or account-tiering model can act on.
The reason you bracket at all is that a model can’t reason about a raw number. “$4.2M” is not an instruction. “Tier 3, worth 10 points” is. Brackets compress thousands of distinct revenue values into a handful of bands you can reason about, defend to sales, and update in one place.
The same math shows up in three B2B jobs. In lead scoring, revenue is a firmographic signal that sits next to industry, headcount, and job title. In account tiering for ABM, the brackets decide who lands in Tier 1 versus Tier 3. In sales-performance and territory work, revenue bands set quota weighting. Customer-loyalty and spend tiers use the identical bracket-and-points structure, just pointed at spend instead of company revenue.
How to assign points to revenue ranges (step by step)
To assign points to revenue ranges, choose the revenue metric, cut it into brackets at your ICP edges, give each bracket a point value, build a sorted reference table, and let one formula apply it. The five steps below take about 15 minutes the first time and run on autopilot after that.
Set your brackets at the edges of your ICP
Cut points should land where buyer fit actually changes, not on round numbers that look tidy. If you sell to mid-market and the deals stop making sense below $5M and above $250M, those two numbers are your outer edges. Everything below the floor scores 0 (or goes negative if those leads waste sales time), and your best-fit band in the middle scores the most. The cleanest way to find those edges is to look at where your ideal customer profile’s revenue floor and ceiling sit in your actual closed-won data, then draw the brackets around them.
Assign the point values
With the edges set, give each band a score. Keep it to 3 to 5 bands so the signal stays legible. Here’s a working revenue-range scoring table for a mid-market B2B seller, with the sweet spot scoring highest and very large accounts scoring slightly lower because they take longer to close and service.
| Annual revenue (lower bound) | Tier | Points |
|---|---|---|
| $0 | Below ICP floor | 0 |
| $1,000,000 | Tier 3 (emerging) | 10 |
| $10,000,000 | Tier 2 (core) | 25 |
| $50,000,000 | Tier 1 (sweet spot) | 40 |
| $250,000,000 | Enterprise (slower close) | 30 |
Those point values aren’t arbitrary: revenue is one signal in a bigger set of scoring criteria, so its top score should be a deliberate slice of the total, not a runaway number. Deciding how much weight any single signal should carry is the part that keeps a model honest, and revenue is the signal teams most often over-weight.
Automate the scoring with a formula
Once the table exists, you never assign points by hand again. Put the revenue figure in a cell and let an approximate-match lookup find the right bracket. VLOOKUP with its last argument set to TRUE returns the points for the largest lower bound that’s less than or equal to the lead’s revenue, which is exactly the bracket logic you want.
=VLOOKUP(B2, $E$2:$G$6, 3, TRUE)Here B2 holds the lead’s revenue, E2:G6 is the table above (lower bound, tier, points), 3 is the points column, and TRUE switches on approximate match. A lead at $87M matches the $50M row and scores 40; a lead at $300M matches the $250M row and scores 30. If you’d rather hard-code the bands without a side table, an IFS function does the same job by checking the brackets from the top down.
=IFS(B2>=250000000, 30, B2>=50000000, 40, B2>=10000000, 25, B2>=1000000, 10, TRUE, 0)PRO TIP
Approximate-match VLOOKUP only works if the first column is sorted in ascending order. Both Microsoft and Google Sheets require it. One misplaced row and the formula returns the wrong tier silently, with no error to warn you.
XLOOKUP (with match mode set to “exact or next smaller”) and a nested IF do the same thing if your spreadsheet doesn’t have IFS. The lookup approach scales better: when your pricing or ICP shifts, you edit the table once and every row re-scores.
Workflow · 15 min
How to assign points to revenue ranges
Turn a raw company-revenue figure into a repeatable lead-score input in five steps.
Choose the revenue metric and pull the data
Pick annual revenue or ARR, then pull it from your CRM or an enrichment source. Decide upfront how you’ll score records where revenue is missing.
Cut the revenue range into 3 to 5 brackets
Place your cut points at the revenue floor and ceiling of your ideal customer profile. Below the floor scores 0; the best-fit band sits in the middle.
Assign a point value to each bracket
Give your sweet-spot band the maximum and step the others down. Keep the top value to a deliberate share of the total possible score.
Build the sorted reference table
List each bracket’s lower bound and its points in two columns, sorted ascending by the lower bound. This table is what the formula reads.
Automate the scoring with VLOOKUP or IFS
Apply =VLOOKUP(revenue, table, points_column, TRUE) so every record scores itself. Use IFS or XLOOKUP if you prefer to hard-code the bands.
How many points should each revenue range get?
Each revenue range should get a point value sized to how much that band changes your odds of a good deal, capped so revenue never dominates the score on its own. A practical rule: let firmographic fit, revenue included, account for 30 to 40% of the maximum possible score, and leave the rest for behavior.
The logic is simple. Company size predicts whether a lead could be a good customer. Behavior predicts whether they’re ready to buy. A $40M company that perfectly fits your ICP but has never opened an email is a great prospect and a terrible “call them today” lead. If revenue points alone can clear your qualification bar, you’ll flood sales with big logos that aren’t paying attention.
That’s why the top revenue band in the table earns 40 points against a qualification threshold of 75: meaningful, but it can’t qualify a lead by itself. A SaaS team scoring product-qualified leads will tilt even further toward usage signals, which is why a product-led model leans harder on activation and feature adoption than on company size.
Linear vs. tiered vs. weighted point allocation
There are three ways to spread points across your brackets, and the right one depends on how buyer fit changes with size. Pick deliberately instead of defaulting to an even spread.
| Approach | How points scale | Best when | Example (4 bands) |
|---|---|---|---|
| Linear | Equal step per bracket | Fit rises steadily with company size | 10 / 20 / 30 / 40 |
| Tiered (top-weighted) | Bigger jumps near the top | Only your sweet spot is worth real sales effort | 5 / 10 / 25 / 40 |
| Weighted by fit | Peaks at the sweet spot, dips for too-big | Your largest accounts are slow or hard to service | 10 / 25 / 40 / 20 |
Linear is the safe default for a first model. Tiered makes sense when small accounts genuinely aren’t worth a rep’s time. Weighted by fit is the most honest for many mid-market sellers: the biggest companies on the list often have procurement cycles and service demands you can’t support, so they shouldn’t outscore the accounts you actually close.
A worked example: revenue-range scoring in a B2B lead model
Here’s how revenue-range points behave inside a full score. Take a real-looking lead: a $40M SaaS company, VP of Marketing, who visited the pricing page three times and requested a demo, from a free email domain.
| Signal | Detail | Points |
|---|---|---|
| Annual revenue range | $40M, Tier 1 sweet spot | +40 |
| Headcount | ~600 employees (don’t double-count size) | +5 |
| Industry fit | SaaS, inside ICP | +15 |
| Job title | VP of Marketing | +10 |
| Behavior: pricing page x3 | High intent | +20 |
| Behavior: demo request | High intent | +25 |
| Negative: free email domain | Weak buying signal | -10 |
| Total | MQL threshold = 75 | 105 |
Notice that the firmographic signals alone (40 + 5 + 15 + 10 = 70) fall just short of the 75-point bar. It’s the behavior that pushes this lead over the line. That’s the model working as intended: revenue range earns the account a hard look, but engagement is what flips it from marketing to sales. Where that flip happens is the difference between an MQL and a sales-qualified lead your reps will actually accept, and revenue points should inform that handoff without forcing it.
Common mistakes when assigning points to revenue ranges
Most broken revenue-range models fail in the same few ways. Watch for these before you ship your scoring sheet.
Too many brackets. Ten bands feel precise but behave like noise, because the difference between a $22M and a $24M company isn’t real signal. Three to five bands capture the pattern and stay easy to explain to sales.
Round numbers instead of ICP edges. Cut points at $10M and $50M because they’re tidy, and you’ll split bands right through the middle of your best customers. Draw the edges from where your win rate actually changes.
Double-counting size. Revenue and employee count are highly correlated, so scoring both heavily means you’re rewarding company size twice and crowding out everything else. Pick one as your primary size signal and give the other a light touch.
IMPORTANT
A big revenue score is not a qualified lead. A perfect-fit account with zero engagement still isn’t ready for a sales call. Confirm that the company is a real, reachable buyer with the validation checks that separate a fit from a genuine opportunity before your reps spend time on it.
Set-and-forget brackets. Your ICP and pricing move, and stale brackets quietly mis-score every new lead. Tag the scoring table with a review date and revisit it each quarter so the points still match the business you want.
Frequently Asked Questions
Build a two-column reference table of each range’s lower bound and its points, sorted ascending. Then use =VLOOKUP(value, table, points_column, TRUE). The TRUE turns on approximate match, so Excel returns the points for the largest lower bound that’s still below your value. IFS or XLOOKUP work too.
Three to five. Fewer than three can’t separate small from ideal from oversized accounts, and more than five adds brackets so narrow they behave like noise. Most B2B models settle on a below-floor band scoring zero, two or three positive bands, and sometimes a discounted enterprise band on top.
Revenue-based lead scoring assigns points to a company’s revenue range as a firmographic signal of fit. Larger, in-profile companies score higher because they’re more likely to become valuable customers. It works best combined with behavioral signals, since revenue predicts fit, not readiness to buy.
No. Companies above your service ceiling often bring long procurement cycles and demands you can’t meet, so they convert worse than your sweet spot. A weighted-by-fit allocation peaks at your best-fit band and discounts the largest accounts, which usually models real win rates better than a straight line.
Yes. Google Sheets uses the same VLOOKUP syntax with the is_sorted argument set to TRUE for approximate match, so the bracket logic is identical to Excel. XLOOKUP is also available in Sheets if you’d rather match on the next-smaller value without a sorted table.
