Identify and Enrich Contacts from Targeted Companies List
help me Find people whose previous employer is any company in my list, then enrich their current employer, email
help me Find people whose previous employer is any company in my list, then enrich their current employer, email
To find people whose previous employer matches companies in your list:
Create a Find People search - Go to "Add Table" > select "Find People"
Enable past experiences - Toggle on "Include Past Experiences" to search historical work data
Set company filters - Under "Companies," select your existing Clay table containing the company list
Configure search parameters - Apply additional filters for job titles, seniority, or other criteria as needed
Run the search - Click "Preview People" to see results, then "Import" and "Save to new table"
Enrich current employer and email - In your new people table, add enrichment columns to get their current company information and email addresses using our person enrichment features
The past experiences filter will search across both current and previous roles to find people who previously worked at any company in your list.
Did that explanation help you find those people?
whats a prompt i can give sculptor that will help me produce this
Here's a prompt for Sculptor to find people whose previous employer matches your company list:
#VARIABLES#
{CompanyList} = /[Your Company List Column]
{PersonName} = /Full Name
{CurrentCompany} = /Current Company
{Email} = /Email Address
PROMPT:
"Find people who previously worked at any company from this list: {CompanyList}. For each person found, enrich their current employer information and email address. Return results with their full name, previous company (from the list), current company, and email address."
Use curly brackets to reference your table columns, and add the column by typing "/" then selecting from the dropdown. You can also use our AI help tool by clicking "Generate with prompt" and entering your desired outcome in the task description field.
Did that prompt work for your needs?
If you still need help refining the Sculptor prompt or any other part of your workflow, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any challenges you’re facing?
what should i do to my list before I do it ??? get rid of the personal emails ? or what ?? its a 28000 list
For a 28,000 record list, prepare it by:
Create a clean export view - Hide unnecessary columns and keep only essential data like company names, domains, and key identifiers.
Remove duplicates and outdated records using data cleansing tools to ensure accuracy.
Filter to qualify leads - Apply criteria like location, industry, or company size to enrich only high-value prospects and avoid wasting credits on irrelevant records.
Set up exclusions - Use our "Exclude" feature to automatically filter out existing contacts or companies you already have in your CRM.
Test first - Run your Sculptor prompt on a small sample (10-50 rows) before processing the full 28,000 to validate your workflow and credit usage.
Personal emails aren't necessarily problematic - focus more on data quality and relevance filtering.
Does that preparation advice make sense to you?
how do i dedupe ?
You have two ways to dedupe in Clay:
Auto-dedupe (recommended for ongoing cleanup):
Click the Auto-dedupe button at the bottom-right of your table. Toggle on "Enable automatic deduplication" and select a column to use as the unique identifier (like company domain or email). This continuously monitors and removes duplicates automatically.
Manual column dedupe:
Right-click any column header, select Dedupe > Delete Duplicate Row. This removes duplicates based on exact matches in that specific column.
Important: Deleted rows cannot be recovered, and deduplication is case-sensitive.
Did that explanation help you with deduping?
If you still need help with deduplication or any other part of your list preparation, I’m here to assist. Would you like to share more about the specific challenges you’re facing or what you’re trying to accomplish next?
i really just want a list of all the people who used to work at the comapnies that signed up for my product.... whats best way i can do that
Use Find People with the "Include Past Experiences" toggle enabled:
1. Go to "Actions" > "Find People at These Companies"
2. Select your company table under "Companies"
3. Toggle on "Include Past Experiences" to search historical work data
4. Set filters for job titles or other criteria as needed
5. Click "Preview People" then "Import" and "Save to new table"
This searches across both current and previous roles to find people who previously worked at your customer companies.