Hi! I'm trying to find all of the earliest/founding employees from a list of companies I generated but it seems like there isn't a clean way to go about it. Any ideas on how to best go about this?
To find the earliest or founding employees from your list of companies in Clay, you can use the Find People feature. Here's a streamlined approach: 1. Use the "Find People at These Companies" action from your company list. 2. In the Find People modal, set your search parameters: • Use "Experience Title" to include terms like "Founder", "Co-founder", or "Early Employee". • Set "Social Headline" to look for similar keywords in LinkedIn profiles. 3. You can also use the "Founded Date" or "Founded Year" data points to cross-reference with employee start dates. After running the search, review the results and look for people with the earliest join dates or founding titles. Remember, this method may not capture all founding employees, but it's a good starting point.
How would I access the founded date or founded year data points using Clay and automate cross referencing to find all of the employees who were at the company during that time period?
To access the founded date or year and identify early employees in Clay: 1. Use the "Founded Date" or "Company Year Founded" data points for your companies. 2. For employees, use the "Contact Employment Start & End Date" data point. 3. Use our "write to table" feature to compile this data. 4. Create a formula to compare employee start dates with company founding dates. 5. Filter results to show employees who joined within a specific timeframe after the founding date. This approach will help you identify employees present during the company's early stages.
How do I use these data points and the write to table feature to write a formula
To identify employees who joined during a company's founding period using Clay:
1. Use the "Founded Date" or "Company Start Date" for companies.
2. Use "Contact Employment Start & End Date" for employees.
3. Use our "write to table" feature to compile this data.
4. Create a formula to compare employee start dates with company founding dates. For example: LBKSIF(DATEDIF([Company Start Date], [Contact Employment Start Date], "D") <= 365, "Early Employee", "Later Hire")LBKSThis formula identifies employees who joined within a year of the company's founding. Adjust the timeframe as needed for your definition of "founding period".
Can you show me what to do with data points in Clay
Hey there, I’ve already answered this question in a separate thread. Let’s continue our discussion there to keep things organized. In the future, please start a new conversation for each topic to help us keep track more efficiently. Thanks!
.png){kind=logo}
