hey people, i need some inspiration ... i want to assess the employee turnover. I mean, it's simple to get the growth/shrink rate, but how to discover the employee churn (aka attrition rate aka staff turnover) ?
To assess employee turnover and calculate churn accurately, you can adapt the customer churn rate formula for employees: Employee Churn Rate = (Number of Employees Lost During Period / Total Employees at Start of Period) × 100 To get a comprehensive view: 1. Track employee counts over time (e.g., monthly, quarterly, annually). 2. Calculate churn rate for each period. 3. Analyze trends and patterns in the data. 4. Consider factors influencing churn (e.g., job satisfaction, competitive offers). Remember, churn rate is different from growth/shrink rate as it focuses specifically on employee loss. This metric helps identify retention issues and areas for improvement in your employee experience.
You can use Claygent for that. Just tell it to scrape number of employees from a company linkedin profile. Track that on a given period and use an AI formula (may not even need to be an AI formula), to calculate Employee turnover
Hey Jarek, chiming in here—exactly right. You can use Claygent to pull in employee numbers (just make sure to add your own API key to save on credits). From there, set a schedule to run the Claygent column at your preferred interval. Once that’s in place, you can use the AI Formula column to calculate the number you’re looking for based on that data. Let me know if you have any follow up questions! Have a great Tuesday, Daniel
Daniel K. & Gui S. thanks for your insights, I dare to say these do not address the issue 🙂 now bear with me I will explain why. the change in employee number is not retention. there may be no change in # employees QoQ or YoY, whilst the churn may be enormous (or none, for that matter). So i was thinking along these lines:
find employees who worked for this company before but are not with it any more
find out when they left the company
use it to calculate empl. turnover
now, this has obvious limitations, as it makes no economic sense to inspect potentially hundreds of contacts to get just one number. hence my question, opinions welcome :)
Good catch, that will not work indeed since we have employees joining and leaving the company simultaneously. The only way I can think of is exactly like you described, it will be VERY costly (in terms of credits).
Fetch list of all employees working at that company (run that every week)
Compare previous week with current and highlight different names (Lookup)
Find missing names.
Those that are not found, check their Linkedin profile. Check date he left.
Confirm and calculate churn.
so here's an interesting one... i actually am able to do this with apollo.io running this query: Excluded Companies: [this company name], Past Companies: [this company name] [* edit *] actually i can further improve it by setting time in current role, this way I can filter out employees who churned outside of the time window I will check their API and see if this can be done from Clay.
.png){kind=logo}
