Clay Icon

Finding Phone Numbers of Small Company CEOs: Troubleshooting Error Message When Inputting LinkedIn URL

·
·

Back here again haha, Wanting to find the phone numbers of small company CEOS. Ran a waterfall by inputting a linkedin url but am getting the error message. Maybe some help on how to correctly get it?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey Ethan, welcome back!😅 I am checking your table.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Heyy Ethan, The waterfall enrichment is giving no results because it's using the company's LI url as the social url to check. To get the phone numbers of CEOs at those companies, it'll be more seamless to enrich those contacts and pull their LI profile urls.I noticed you're using Claygent to find them and have a PDL column to enrich. I have updated your PDL column to use full name & company name for the enrichment. However, this + the phone number enrichments presents two different workflows in your table that may burn more credits than necessary. You could try this workflow:- Use this LinkedIn enrichment ­`(I have added this column and set it up for you) instead of Claygent to get more consistent results and profiles for CEOs/Founders (this will pull their LI urls as well) It's set to return one profile that matches your search criteria. - Add LI profile urls from the search results to your Waterfall enrichment to pull phone numbers. Let me if know if this helps!

    27e96fb1-35fe-48ef-9c0a-9680d5442b3e.png(38 kB)
  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    This is the enrichment you can use instead of Claygent:

    cdb35ec2-5d0a-479e-9085-e74132432606.png(171 kB)
  • Avatar of Ethan
    Ethan
    ·
    ·

    alright thank you so much, I’ll check it out when I get home

  • Avatar of Ethan
    Ethan
    ·
    ·

    and for the phone number?

  • Avatar of Ethan
    Ethan
    ·
    ·

    That’s not included in the enrichment is it?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey Ethan, happy to help!The phone number enrichments will run based on the LI urls that are pulled from "Find Contacts at Company"This is the flow: Run "Find Contacts at Company" > > "Extract the contact's LI url from the results" > > Map this to the social url field in the waterfall enrichment for phone numbers. I set this up for you. You can test for one or two rows when you have some time. Hope this helps!

  • Avatar of Ethan
    Ethan
    ·
    ·

    Hey Daniela

  • Avatar of Ethan
    Ethan
    ·
    ·

    I just got back

  • Avatar of Ethan
    Ethan
    ·
    ·

    just double checking but I remember you said you added something in the table? I don't see any changes

  • Avatar of Ethan
    Ethan
    ·
    ·

    oh nevermind I see the column

  • Avatar of Ethan
    Ethan
    ·
    ·

    I'm still confused about the pulling phone numbers part though..

  • Avatar of Ethan
    Ethan
    ·
    ·

    two things,

  • Avatar of Ethan
    Ethan
    ·
    ·

    one of which is that I ran the first 10 rows and it only returned 2 profiles

  • Avatar of Ethan
    Ethan
    ·
    ·

    so I'm not sure what I'm supposed to do about the rest

  • Avatar of Ethan
    Ethan
    ·
    ·

    and 2, from here where do I extract the contact's Li url from the results? After I have done that what waterfall enrichment do I input it to?.. The one that burns lots of credits?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey Ethan

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Looking into this right now!

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Just a heads up i'm going to be editing the table a bit. For phone number - you need to map the linkedin URL from the find contacts search. Right now you have the company linkedin mapped.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    What you have now:

    3cf8190c-9a1c-4dfd-95bd-818eb71785b3.png(135 kB)
  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    What it should be:

    75f0314e-4375-4d20-a519-ca118aaf63e7.png(63 kB)
  • Avatar of Ethan
    Ethan
    ·
    ·

    sounds good

  • Avatar of Ethan
    Ethan
    ·
    ·

    yes so

  • Avatar of Ethan
    Ethan
    ·
    ·

    I hope I didn't delete it but I tried to do contacts search however it can't find 90% of the contacts

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Just added a 2nd enrich to try to find people

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    + added a new phone waterfall - you're only charged if a phone number is found

  • Avatar of Ethan
    Ethan
    ·
    ·

    yeah I see it

  • Avatar of Ethan
    Ethan
    ·
    ·

    It doesn't look like it's being accurate though?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Which ones look off?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Right now it's running based on the domain column

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Let me try a different set of inputs

  • Avatar of Ethan
    Ethan
    ·
    ·

    I know that you can use the find people option

  • Avatar of Ethan
    Ethan
    ·
    ·

    I just wanted to know if there was an easier way of finding CEOs and their numbers (assuming it's this!)

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Find people works well for most businesses - but looks like you mainly have SMBs and local businesses on this list

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    For local businesses - we typically recommend this workflow: https://www.clay.com/learn/find-and-enrich-local-businesses-with-google

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Most local biz owners have linkedin profiles, but they don't always linkedin company profiles

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Which is why the find people search doesn't work well

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Or they don't have their account connected to the linkedin company profile

  • Avatar of Ethan
    Ethan
    ·
    ·

    Yup I would def use the google maps local leads but the problem with that is that I can't choose small businesses/employee sizes

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Checking out a few LI profiles you have in this table and the founders aren't listed as employees

  • Avatar of Ethan
    Ethan
    ·
    ·

    it's at complete random

  • Avatar of Ethan
    Ethan
    ·
    ·

    oh that too.. I don't think it's being very accurate. Tried Claygent and the results are different as well

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Ya unfortunately that's likely the best workflow still. It's a few cents extra per row - but accuracy is going to be the most spot on.

  • Avatar of Ethan
    Ethan
    ·
    ·

    which one

  • Avatar of Ethan
    Ethan
    ·
    ·

    the find people?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Google Maps workflow

  • Avatar of Ethan
    Ethan
    ·
    ·

    ah I see

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    in the video above

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Ya it doesn't seem as efficient from a first glance - but when you look at accuracy and credit spend it's the best

  • Avatar of Ethan
    Ethan
    ·
    ·

    and so I wouldn't be able to have an idea of what the company sizes are?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Once you find the companies via google maps, you can run "Enrich Company" from Linkedin to get the company sizes

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    then filter from there

  • Avatar of Ethan
    Ethan
    ·
    ·

    I see

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    What size are you looking for though? Most local businesses are going to be 10 people or less so it likely will align with what you need

  • Avatar of Ethan
    Ethan
    ·
    ·

    well

  • Avatar of Ethan
    Ethan
    ·
    ·

    I can send another table I tried it on and show you

  • Avatar of Ethan
    Ethan
    ·
    ·

    it was complete random

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Gotcha

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Yep this leads back to SMBs not often being on LinkedIn

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    So its not just that there's no match found or the wrong match - it's that they don't exist on linkedin or they don't have their domain properly mapped to their LI profile

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    I gotta jump right now but can take a look later tonight. Just a heads up though - if you want some really in depth help here it may be worth while to hire an expert to help more with any implementation-> clay.com/experts

  • Avatar of Ethan
    Ethan
    ·
    ·

    Got you

  • Avatar of Ethan
    Ethan
    ·
    ·

    so you recommend that I stick to google maps instead of linkedin but have random size companies?

  • Avatar of Ethan
    Ethan
    ·
    ·

    Enriched with the employee count and most of the "local SMBs" are huge companies 🥲

  • Avatar of Ethan
    Ethan
    ·
    ·

    anyway, updated that table with the employee count, any specific recommendations to get the owner's number without burning too many credits? (And finding the owner too lol) In the case of finding the owner, I can search "Find people" but again, not sure if that's the most efficient wise in terms of credits and both accuracy.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    I just googled some of them and i think those datapoints are wrong actually. Like 144 Academy Jiu Jitsu/Self-Defense/Fitness says "22,000" but i think that's just wrong actually on the pitchbook side - it looks to be mismatched

  • Avatar of Ethan
    Ethan
    ·
    ·

    yup I saw that exact one and was surprised too

  • Avatar of Ethan
    Ethan
    ·
    ·

    not sure if there is any other way?

  • Avatar of Ethan
    Ethan
    ·
    ·

    But anyway, do you have any recommendations to get the owner's number without burning too many credits?

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    I'd use this recipe:

    1b3359fe-a200-45dd-89a9-31405bf2b968.png(35 kB)
  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    It will find the person -> find phone numbers

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    It may cost up to 16 or so credits - but that's actually pretty low cost compared to everything else out there

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    and within Clay it's the lowest cost way to do this still

  • Avatar of Ethan
    Ethan
    ·
    ·

    I checked it out but it finds the email instead of the number which I don't need

  • Avatar of Ethan
    Ethan
    ·
    ·

    since I'm strictly cold calling

  • Avatar of Ethan
    Ethan
    ·
    ·
  • Avatar of Ethan
    Ethan
    ·
    ·
  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Gotcha so you can use that workflow

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    then delete the email columns

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    and just add a phone number column afterwards

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    That uses the LI profile as the input to find phone numbers

  • Avatar of Ethan
    Ethan
    ·
    ·

    oh gotcha

  • Avatar of Ethan
    Ethan
    ·
    ·

    and it has to be 25 credits per row?

  • Avatar of Ethan
    Ethan
    ·
    ·

    no possible accurate alternative?

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    You’re only charged if the phone number is found

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    I’d run with our normal phone waterfall

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    it will be 25 at the max

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    but you can also just remove that if you don’t want to pay that much per phone number

  • Avatar of Ethan
    Ethan
    ·
    ·

    gotcha thank you

  • Avatar of Ethan
    Ethan
    ·
    ·

    oh one last thing sorry

  • Avatar of Ethan
    Ethan
    ·
    ·

    it doesn't let you remove the work emails since it's conditionally ran

  • Avatar of Ethan
    Ethan
    ·
    ·

    and if I run the phone waterfall, it already requires a contact

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Can you send a table link? Not quite following

  • Avatar of Ethan
    Ethan
    ·
    ·

    yeah for sure

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Did you already try adding that workflow?

  • Avatar of Ethan
    Ethan
    ·
    ·

    the phone workflow?

  • Avatar of Ethan
    Ethan
    ·
    ·

    it requires a contact/profile url to play it

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    This one:

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Yep so you add this one^

  • Avatar of Ethan
    Ethan
    ·
    ·

    oh no, since I don't need emails

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Still use that

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    but once it’s created

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    delete the email columns

  • Avatar of Ethan
    Ethan
    ·
    ·

    and am starting to get very limited on credits

  • Avatar of Ethan
    Ethan
    ·
    ·

    alright

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    You still need it to find the person on LI first

  • Avatar of Ethan
    Ethan
    ·
    ·

    and that's the only way possible?

  • Avatar of Ethan
    Ethan
    ·
    ·
  • Avatar of Ethan
    Ethan
    ·
    ·

    because I could just play this out

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Those are the same - its just with the recipe we have it already set up + AI to verify it’s the right person

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    You can save that recipe without running it too

  • Avatar of Ethan
    Ethan
    ·
    ·

    alright, I'll do the first one then