Back to library
Clay formula

Headcount to ICP band

Buckets employee counts into SMB, Mid-Market and Enterprise for routing and scoring.

Columns it needs

Headcount

The snippet

IF({{Headcount}} = "", "Unknown", IF({{Headcount}} < 50, "SMB", IF({{Headcount}} < 500, "Mid-Market", "Enterprise")))
scoringicpsegmentation

Related patterns