Clay Icon

Hi there - is there a tutorial or way to extract all office locations...

ยท

Hi there - is there a tutorial or way to extract all office locations for a company?

  • 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 Clay Team
    Clay Team
    APP
    ยท

    Hey, thanks for reaching out! Are you looking for just the number or need the address itself? Here's one video we have on the topic: https://www.clay.com/learn/how-to-find-the-number-of-locations-a-company-hasLet me know if you run into any issues!

  • Avatar of Shayda
    Shayda
    ยท

    Hi Arturo

  • Avatar of Shayda
    Shayda
    ยท

    Looking for the addresses not the number

  • Avatar of Clay Team
    Clay Team
    APP
    ยท

    Got it! That's a trickier one I'd say, because not all companies display them in their LI profiles or aren't collected by every enrichment. A potential workaround is to Scrape Website using their "locations" page URL if you have that available. Here's a video with an example of something similar but instead finding and scraping career pages. You can modify this to find their location URLs instead though: https://www.clay.com/learn/enriching-a-companys-linkedin-profile-for-tons-of-data

  • Avatar of Clay Team
    Clay Team
    APP
    ยท

    Then, a formula or chatGPT may do a great job of extracting those values