Clay Icon

Identifying Companies Without Contacts in Database Tables

ยท
ยท

When I do Find contacts at company from a companies table, data is saved into another table. How do I tell if a company do not have a contact found?

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    Hey there, happy to help! To identify companies that did not have any contacts found after using the "Find contacts at company" feature from a companies table, you can use Clay's Lookup to filter for companies where contacts are missing. Here's the process you can follow: * Perform a lookup for rows with empty contact values in your original companies table. * Once filtered, this will highlight the companies that haven't had contacts enriched yet. For a visual guide on how to perform this lookup, you can refer to this Loom video tutorial: Loom Video. Additionally, if you find companies without results, you can enrich the missing data by adding more enrichments using tools like Datagma or Claygent. Here are some guides to assist you with that: * Datagma guide * Claygent guide * Claygent prompt guide.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • 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 Daniel T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: