Best Integration to Identify Companies with No Finance Team

What’s the best integration to figure out if the company has any people on their finance team? I want to target companies with no finance team

Clay Team
APP
·
·
Hi, thanks for getting in touch!
Clay Team
APP
·
·
you can use this enrichment
0c198bd9-c55b-4270-a7eb-3d9b43a19b66.png(83 kB)
Sary
·
·
perfect, and you recommend the company identifier to be linkedin url vs company url?
Clay Team
APP
·
·
linkedin url is the most accurate in my opinion
:thumbsup_all:1
Clay Team
APP
·
·
then you can use a lookup function to export to a new table all the companies with 0 matches
Sary
·
·
Any videos on that?
Clay Team
APP
·
·
well actually would be better to use the write to table function
Clay Team
APP
·
·
sure, one moment
:thumbsup_all:1
Clay Team
APP
·
·
you can use our Write to table integration to extract a list of results into their own rows in a new table, here's a quick video: https://www.loom.com/share/841cc9c009194f1688bbd134b3e4f388
Clay Team
APP
·
·
just add a conditional in the enrichment, only use it when match = 0
Clay Team
APP
·
·
Using conditional formulas would be best for this, here's a quick video on how to use them/set them up - https://www.clay.com/learn/how-to-use-ai-formulas
:thumbsup_all:1
:sparkles-clay:1
Sary
·
·
When I write a new table, how can I enrich the prospect rows with company information?
Clay Team
APP
·
·
you can run a linkedin enrichment
d8d07a6a-c5c2-4e6d-a8c6-0ef23f322c11.png(34 kB)