Best Way to Filter Companies without Specific Titles & Employee Criteria

·

Hey hey, In my list of companies, I’m trying to filter for those without specific employee job titles (e.g. does not contain “VP of Sales” “Head of Sales”….) Is it best to do this through the Find Contacts at Company integration? For example: Job Title Include Keywords = “VP of Sales”, “Head of Sales”…run records, filter for “No Profile Found” ?

✅1

6 comments

Joe H.
·
·
https://app.clay.com/workspaces/192229/tables/t_2e736sXM8LdZ/views/gv_l46NbAkWJhBS
Joe H.
·
·
Tried some conditional formulas for “Find Employee Headcount by Job Title” integration but didn’t have luck, seems like I’d need to run all the cells to actually count the job titles at the company - whether it’s 0 or more than 0
Clay Team
APP
·
·
Hey Joe!
Clay Team
APP
·
·
The Find employee headcount by job title should work
Clay Team
APP
·
·
Where'd you get stuck here? I see you've ran it for some rows already
Joe H.
·
·
Matthew Q. No worries, all set 👍