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)