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