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

5 comments

Aaron A.
·
·
Best thing to do here is to add a "look up multiple rows" enrichment and then match the company name across both tables, you'll get a clear view of which one has profiles or not.
1
Saad Z.
·
·
yessir, just do “lookup multiple rows” from the company table into the people table based on the company domain. the company rows that show no results would be the ones that don’t have any contacts in the people table.
Muhammad H.
·
·
Can you please guide me with thisSaad Z. ?
Muhammad H.
·
·
Can you please help with this Aaron A. ?
Aaron A.
·
·
Search for the "lookup multiple rows" enrichment. Choose your table and target column, set the criteria to either contains or equals, then the row value you've looking to match for