Clay Icon

Creating a Company Search Column in Apollo by Country, Industry, and Revenue

·
·

Hi! I would like to make a column using Apollo where I can search for companies. Just like we currently have the ability to search for contacts by job title, company, location. I would like the same thing, but companies by country, industry and revenue. Is this possible?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can search for companies using various filters in Clay with Apollo.io integration. You can filter companies based on multiple attributes including:• Location - Select specific countries• Industries - Include or exclude specific industries• Company size and type• Keywords in company descriptions• Company attributes and other specific detailsTo use this feature:1. Start by defining your search parameters 2. Set filters for company type, industry, and location 3. Set a record limit to control the number of companies returned 4. Preview the results before importing them into your tableOnce you find the companies you're looking for, you can enrich their data using Apollo.io to get detailed information about the organizations, including employee count, industry, and social media profiles. Sources: Find People Overview - Clay University Find Company Overview - Clay University Enrich Company with Apollo.io

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    but how to do it in a column in the table?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You can use the Apollo.io integration in Clay to enrich your company data and find companies based on specific criteria. Here's how:1. Add the "Enrich Company with Apollo.io" integration to your table 2. Input the company domain in the required field 3. The integration will then fetch detailed company information from Apollo's databaseFor more specific company searches, you can also use Apollo's search capabilities to find companies and their employees by:** Using job titles ** Specifying company domains * Setting result limitsThe integration will help streamline your prospecting workflow by providing access to Apollo.io's extensive business intelligence database, allowing you to enhance your company data with detailed information. Sources: Find People By Job Title with Apollo.io Find People at Company By Job Title with Apollo.io Enrich Company with Apollo.io

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    But I want to find companies so how should I "Input the company domain in the required field"?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You have a couple of options to find companies using Apollo.io in Clay:1. Search by Job Titles: You can use the "Find People By Job Title" action to discover companies where people with specific job titles work. The company domains field is optional, so you can search broadly across all companies. 2. Two-Step Process: • First, use the "Find Domain from Company Name with Google" action to get company domains by simply entering company names • Then use these domains with Apollo.io's enrichment featuresOnce you've identified companies through either method, you can leverage Apollo.io's extensive B2B database to retrieve detailed company and contact information, validate company details, and track job postings. Sources: Find People By Job Title with Apollo.io Apollo.io - Clay University Find Domain from Company Name with Google

  • Avatar of Karol S.
    Karol S.
    ·
    ·
    1. 1.

      Yes but I want to add filter for Revenue and there is no option there

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    2. I don't have domains yet! I want to find them

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    Can I talk with real person?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    When searching for companies using our Apollo.io integration, you can use the Company Attributes section to filter your search. While filtering by company size and industry is possible, I don't see specific information about revenue filtering in the provided documentation. However, since Apollo.io's integration enables retrieving detailed company information, I recommend checking our help documentation or clicking on "Talk to a person" if you need further assistance with revenue filtering capabilities. Sources: Find People Overview - Clay University Apollo.io - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, thanks for reaching out Karol - If you want to find the domain, which data are you starting with? Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732828500&signature=2555153a24a86b6547e141a177b191bc046d1c231bb2d4dfa1ba1dc36a092620&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn0BJ8T2BKsam%2FhVPvC6A%3D%3D%0A

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    this is my table

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    I want to find companies with filters: Revenue, Industry, Country

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    and now I'm using column "Companies - AI" and try to find list of companies according to my filters

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    bu I'm using AI and Clayagent. And this is not working correct

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    so the perfect will be when I can use Apollo to find these companies

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Karol - Why not use the normal Find Companies search instead? In Clay, we allow you to filter for industry, country, etc. It's super simple. Regarding the revenue, it's an enrichment that needs to be added after the search has been done, not before! :) AI Search is good for smaller searches

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    Because I have this table connected with other tool. So every row is diffrent request. And the output should be the list of contacts which I send via Zapier to requester. I don't want to search manually.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Got it - Is there any way to add more information for the companies or is that the only thing you'd like to work with? For example, the way I would try to tackle this would be like in this workflow: https://app.clay.com/workspaces/263123/workbooks/wb_h4ictssuGjEG/tables/t_V9trogpiDuF8/views/gv_hTHnkYpVxrMb You would simply need to segment the companies per revenue or location or size through different options to find their correct lookalike; otherwise, it'll bring companies that don't match. Table 2 https://app.clay.com/workspaces/263123/workbooks/wb_h4ictssuGjEG/tables/t_y7hD5ogQekFg/views/gv_3scg5E3pzwW7

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    Thanks! That didn't really solve my problem, because it still finds these companies not through Apollo or another tool, but through Clayagent / AI. And that doesn't give any certainty that lisya will be full.

  • Avatar of Karol S.
    Karol S.
    ·
    ·

    and btw - you used up 300 credits creating this table that didn't solve my problem. If I had known it would be like this I probably wouldn't have asked for help. I understand that you will return them to me?

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Hey Karol, just wanted to step in for Bo. If you prefer not to use AI, you could also give the ocean.io integration a try and add it as a column (check out the image below). 1. Identify a well-known company that fits your criteria (either through AI or your own research). 2. Enter that company's domain along with the other parameters. I've also refunded you 400 credits! If there's anything else I can help you with, feel free to reach out! 😊 Wishing you a fantastic Friday, Daniel https://downloads.intercomcdn.com/i/o/w28k1kwz/1270385068/a8f8407929d2e166f7980c804e08/Arc_m3hgDqGNcj.png?expires=1732885200&signature=973b4c2d80e893631f2c1d834b9ebd606563370dc92e2b9fcd554a5088d2a55d&req=dSIgFsp2mIFZUfMW1HO4zXNGHHSK050EhopWVu9%2BUCpACKYzjwY0E1QfVJKD%0AzY19%0A

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