Clay Icon

Finding Single-Founder Companies in a Specific Industry (e.g. Software Company serving Healthcare)

Β·
Β·

Hi , How to find companies that have only one founder AND from a specific industry. As a modification of this question, How to find companies that have only one founder AND from a specific industry serving another specific industry. ( example Software Company serving Healthcare Industry)

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫢 Don't worry, only admins will be able to open your table πŸ˜‰

  • Avatar of Nilesh M.
    Nilesh M.
    Β·
    Β·

    So I looked at Enrich data and ran filter on Find Employee Head count by Job and added Founder, Co-founder, Owner as include title. Now In the next filter I want to take companies where founder=1 or owner =1

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hey Nilesh! Just replied to the other thread :)... closing this one for now.

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Once you have the results, you can extract the count from that column and apply the filter to it so that it matches your criteria. Here's a quick video on how to extract nested values from enrichments or imports if needed- https://www.loom.com/share/32ae94f5fee34a82b9fa739b53741d00?sid=f67d4463-1cac-477b-a82a-f2e0fe072cb6

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    And here's how to quickly apply a filter to a column by clicking on the header. Let me know if you run into any issues!

    9e1f9ac1-8989-4fdd-aa13-246bf1d33466.png(32 kB)