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