Clay Icon
Join the Community
01 Community General

Guidance Needed for Validating Healthcare Company Data Retrieval

Avatar of AliAli
·
·

I ran a query by adding the counties and states of, US, and it successfully retrieved hospital and healthcare companies. The query also created a "Number of Records" column, where some entries have 5 records, while others have 10. Now, how should I proceed from here? I need to find the company names first, then their domains. After that, I need to validate whether the domains are correct or not. Finally, I need to find decision-makers within these companies. How can I efficiently complete this process? Can someone guide me, please?

1 comment

  • Avatar of Anuj P.
    Anuj P.
    ·
    ·

    hey Ali here's how you can efficiently complete this process:

    1. 1.

      since you have "number of records" as an output in the query, you need to first "write to other table" and select all the records.

    2. 2.

      So, you'll have the counties and states and also hospital and healthcare companies in a new Clay table as a separate row.

    3. 3.

      if query has 5 records, then 5 records will be added to the new table when you do "write to other table", and if 10 records, then 10 records added.

    4. 4.

      Then, you can find company names first.

    5. 5.

      Run free Clearbit enrichment to find domains.

    6. 6.

      If Clearbit doesn't find the domains, use Claygent.

    7. 7.

      Then, use Apollo to find the decision makers in a company

    8. 8.

      Then, run email waterfall enrichment to find email addresses