Hi guys, am using storelead to pull a list of companies but i would like clay to give me the number of employees that are 1-20 and the companies that have 20 employees.
You can find companies based on employee count in two ways: 1. Use our "Get Employee Count by Criteria" feature where you can search using:
⢠Company domain
⢠Company social profile
⢠Stock ticker
⢠Company name
⢠Role filters
⢠Country filters
2. Within Clay tables, you can use the Lookup Multiple Rows integration to:
⢠Scan columns for company identifiers (domain, name, LinkedIn URL)
⢠Count matching values
⢠Apply conditional formulas to filter based on specific parameters
Source:Get Employee Count by Criteria with People Data Labs