Clay Icon
Join the Community
03 Tutorials & Inspiration

Using Clay to Track Employee Departures and Job Function Experience

Avatar of Garrett C.Garrett C.
·
·

Hey there! Does anyone have ideas on how to use Clay to identify how many people LEFT a company? I've been trying to get at this using a mixture of 'Find Employee Headcount by Criteria' and past experiences, but it's hard to do at scale. I can get it for one individual company, but haven't found a way to do it for a table of companies all at once. Similarly, would be interested to use Clay to identify how many people in a specific job function at a company didn't have direct experience previously doing that job function. Any ideas? e.g. how many managers have never managed before? How many salespeople have never sold before? Similarly I'm trying to start with find employee headcount by criteria but haven't quite figured it out.

5 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To identify employee turnover and experience levels across multiple companies, you can use Clay's "Find Employee Headcount by Criteria" feature with the "Companies, People, and Jobs" integration. Here's how: 1. For employee turnover: • Use "Employee Count Over Specified Time Period" to track changes in headcount. • Compare data points over time to estimate departures. 2. For experience levels: • Utilize "Find Employee Headcount by Criteria" with specific job function filters. • Cross-reference with "Latest Experience" data point to identify those new to the role. 3. For scale: • Create a table with your target companies. • Use Clay's batch processing to apply these queries across all companies simultaneously. To refine your approach, could you specify which job functions you're most interested in analyzing?

  • Avatar of shivam
    shivam
    ·
    ·

    hey Garrett C. since this is a diff bw (past people - new people); do you have any source for past data ?

  • Avatar of shivam
    shivam
    ·
    ·

    if you have then you can just make a HTTP call and find people for a company and then find the diff

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, we have a few ways to access historical employee data in Clay: 1. The "Employee Count Over Specified Time Period" data point allows you to track changes in a company's workforce over time. 2. For tracking individual job changes, you can use our "Track Job Changes" feature. To check if contacts still work at previously known companies, provide both the "Person LinkedIn Url" and "Company LinkedIn Url". This will generate job change events for historical moves. 3. To monitor future job changes, only provide the "Person LinkedIn Url" when setting up the tracking. Using these features, you can compare past and current employee data to calculate the difference. If you need more detailed guidance, please ask to talk to a person for further assistance.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To find people for a company and calculate employee number differences using Clay's HTTP API, you can use the "Find Contacts at Company" action. Here's a general approach: 1. Set up an HTTP API integration in Clay with the POST method. 2. Use the endpoint for "Find Contacts at Company" (you'll need to refer to our API documentation for the exact URL). 3. In the request body, include the company identifier and any other relevant parameters. 4. Make separate API calls for different time periods to compare employee numbers. To calculate the difference, you'll need to process the API responses and compare the results. If you need help with the specific JSON formatting or encounter any errors, please share the JSON you're using so we can troubleshoot further.