Seeking Help to Identify Unenriched Leads from 900 Companies

Hi guys, Anyone with clay expertise can help me in a thing where I'm stucked now? issue: Actually,I had 900 companies and I enriched the whole table by applying finding people at these companies now the new table only got me 405 enriched companies via employees but remaining 500 leads didn’t enriched, Can someone help me finding how can i find which kind of leads didn't enrich from whole 910 original table? Thanks Haddid

3 comments

Channeled
APP
·
·
To identify which leads didn't get enriched with employee data, you can follow these steps: 1. Extract the Company Name from your original table into a new column. 2. Deduplicate the Company Name column to get a list of unique companies. 3. Compare this list with your enriched table of 405 companies. 4. Use the "write to table" feature to transfer the data to a new table for easier comparison. 5. Create a formula to identify companies present in the original list but not in the enriched list. This will show you which companies didn't get enriched. If you need more detailed guidance, let me know, and I can provide step-by-step instructions.
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Muhammad H.
·
·
how I know my which leads are enriched and whih are not?