Grouping Job Titles by Company for Effective Outreach

is there some kind of a group by function? im scraping indeed and some companies have multiple jobs for similar/same roles I want to basically group by company for specific job titles, to reach out to the CEO and say for ex: “saw you were hiring 2 salesforce developers - are you growing your team or replacing people looking to leave?”

18 comments

Muhammad S.
·
·
No directly.
Muhammad S.
·
·
But you can pull jobs in one clay table
Muhammad S.
·
·
and then use lookup multiple records in table enrichment to group the data by company domain/name
Bojan
·
·
yeah already did that 🙂 but a company can have multiple different job titles, so its not like all of them are the same, with this recommendation of yours and how i’ve done it, i’d have to create new tables in Clay, for each distinct job title, and that way, i could use the multiple lookup table function correct? this is why i really need a group by feature haha
Muhammad S.
·
·
Here is how it would work 1 table - Containing all the jobs posted by the companies you want 2nd table - containing all the company domains but deduped on domains (Containing only unique domains) Now use lookup multiple rows feature in 2nd table- This will group your data by the domains/company (Now you have all the job titles posted by the same company in a single cell/row) You can extract all the titles in comma seperated form in a new cell using formulas Then you can either use formulas OR AI to analyze and tell you how many jobs and what kind of jobs a company has posted. You only need two tables to achieve that whole thing
Bojan
·
·
this is kinda what i’ve done but its not working for me https://www.tella.tv/video/bojans-video-2lm0
Muhammad S.
·
·
In the second table aka 1-1 table use this enrichment Lookup multiple rows
Bojan
·
·
dude i just figured out what you were saying
Bojan
·
·
haha
Eric N.
·
·
kind of funny hack, you can use lookup multiple rows in other table in the same table you're doing the lookup in so you can keep your workflow together
Bojan
·
·
nice one Eric N. i also do that, in the main jobs table, i basically Count, how many job postings that company has Quick Q - As im continuously getting new job data into the table - is there a way to automatically Dedupe this data when i extract it into a Company Table?
Bojan
·
·
this is my workbook So you can see if i have duplicate Companies, it manifests into duplicates everywhere downstream
Eric N.
·
·
There’s a dedupe function in Clay. Right Click on the column you want to dedupe by
Bojan
·
·
Sure, that’s manual though, i should have been specific, is there a way to dedupe automatically
Bojan
·
·
cause tomorrow jobs data will come in, odds are there will be 1 company hiring multiple roles, and that would automatically get written as duplicate entries into my company table
Eric N.
·
·
Yes there’s an auto dedupe function. Maybe they moved it but if ask real support for it. It for sure exists
Bojan
·
·
❤️ you long time found it at the bottom right
Daniel K.
·
·
Thanks for chiming in here. Bojan, let us know if you hit a snag and happy to look at your table :) Have a great one!