.png&w=3840&q=75){kind=logo}
Using Clay to Find Specific Roles like Sales Reps Who Recently Left Companies
how can i do this with Clay? I want to find people that fit a specific role e.g. sales rep who left a company in the last N months?
Adil A.··if we can't find the specific people, then finding the number of people who left is fine too
- Adil A.··
so to be clear, i am not trying to find people who currently work at a company. i want to find people who used to work at that company uptil N months ago
- Adil A.··
Glad you asked. Here's the end goal. I have a Company table and a People table. In the people table, I assign people to different Instantly email campaigns based on their attributes and their company's attributes. I wanna create a new email campaign that roughly says something like this:
Noticed that XYZ recently left the company. It sucks when that happens. Other [job function] people have to do ABC. You don't know when this would happen again. Use my services so you don't get impacted as badly next time it happens".Now, to do this, I want to add a column in the Company table that lists the number of people with particular titles who left that company in the last 6 months. If we can't list, then count. So, it's very much like the Find Employee Headcount by Criteria except I want to Find Ex-Employee Headcount by Criteria
- Adil A.··
the job changes feature is different: it tracks job changes for specific people
- Adil A.··
i want to find the last person who left a company C (in the last N months) where that person fit a criteria (say job title)
- Adil A.··
for every company C in my company table