Extracting Unique Companies for Targeted People Searches

Dominick C. · 2025-02-28T20:40:23.927186+00:00

So, I have a list of contacts in one table that have company names attached to them. I need to pull out all the unique companies from that table and then run a people search for certain titles at those companies. What's the best want to connect all this

To extract unique company names and run a people search for specific titles, follow these steps: 1. Extract company names: • Click on a cell in the "Company Table Database" column • Hover over "Name" and select "Add as column" • Click the new column header and select "Dedupe" to get unique companies 2. Run a people search: • Go to "Actions" and select "Find people at these companies" • Choose your table under "Companies" • Select the company's LinkedIn URL or domain under "Column" • Set job title parameters for the positions you're looking for • Click "Preview People" • If satisfied, click "Import" and "Save to new table" This process will create a new table with people matching your criteria from the unique companies.

Source: Find People [Clay 101] - Clay University

3 comments