Clay Icon

How to Identify Companies Without Any Employee Results in Your Tables

·
·

Hey, sorry if this has been asked before. I have done a search in Slack and can't find any answers. I have a lot of companies in various tables that I have enriched to find the people that work at those companies. What I would like to do, is get a list of all the companies that did not return any results. tables I have:

  • Company Table (my companies)

  • Find People from Company Table (19 September 2024) Table (enriched profiles from Company Table

Also, anything I can do about companies that have not returned a result?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Chris, happy Saturday! 😊 Of course, here’s how you can get a list of companies that didn’t return any results: 1. Do a Lookup: From your Company Table, do a lookup to the Find People from Company Table (the enriched profiles table). This will show which companies returned results and which didn’t. Here’s a quick guide for that: 👉 Lookup Guide 2. Broaden Your Search Parameters: For companies without results, you can try creating a new search with broader parameters to see if more profiles can be found. 3. Use Claygent for Enrichment: You can also use Claygent with prompts from the library to find additional details, like the CEO’s LinkedIn URL, first name, and last name, for further enrichment. 👉 Claygent Prompts Guide 4. Prospeo for Domain-Associated Emails: Another option is to use the find email associated with domain feature from Prospeo. This can help you retrieve all emails linked to the company domain, which may lead to further contacts. Let me know if you need more help! 😊

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Chris! This thread was recently closed by our Support team. If you have a moment, please share your feedback: