Formatting and Next Steps for Enriching Company URLs in Clay Tables | SEO

·Dec 19, 2023 02:40 PM·

Share

Hi There, I'm new to Clay, and just playing around with my first table, I imported a csv of local businesses and tried to enrich company with the companies site URL, but got about 30% "company not found" but if I manually search they have company profiles on LinkedIn where the URL is displayed. Is there any sort of formatting on the URL I should have done before running the enrichment and what should be my next step to find the companies for the enrichment? I only have Google maps data including company URL. Thanks.

✅1

7 comments

· Sorted by Oldest

Jon B.
·
·
https://app.clay.com/workspaces/161855/tables/t_WaXyw5CK5teW/views/gv_HD7L84VHw1eW
Clay Team
APP
·
·
Hey Jon, thanks for reaching out! Taking a look
:thumbsup_all:1
Clay Team
APP
·
·
A few of them do appear to have a profile as you say and a few others don't. For the ones that aren't coming up, this could sometimes be due to the company not having the same domain/website linked to their profile but will check with our provider in case it's something else. Thanks for flagging these!
Jon B.
·
·
Is there no way to get the enrichment for those then?
Clay Team
APP
·
·
The only other way is to get their LinkedIn URL and enrich that instead. At least for now
Jon B.
·
·
So get the url within clay, or externally?
Clay Team
APP
·
·
Sorry for the delay, Jon, had a few calls in between. You could try to get their LinkedIn URL with a Google Search column and with the company's domain as part of the query, condition it so it only runs for those that weren't enriched. Not sure if it will be accurate enough though.The alternative is to get them externally as you mentioned.

Jon B.
·
·
https://app.clay.com/workspaces/161855/tables/t_WaXyw5CK5teW/views/gv_HD7L84VHw1eW
Clay Team
APP
·
·
Hey Jon, thanks for reaching out! Taking a look
:thumbsup_all:1
Clay Team
APP
·
·
A few of them do appear to have a profile as you say and a few others don't. For the ones that aren't coming up, this could sometimes be due to the company not having the same domain/website linked to their profile but will check with our provider in case it's something else. Thanks for flagging these!
Jon B.
·
·
Is there no way to get the enrichment for those then?
Clay Team
APP
·
·
The only other way is to get their LinkedIn URL and enrich that instead. At least for now
Jon B.
·
·
So get the url within clay, or externally?
Clay Team
APP
·
·
Sorry for the delay, Jon, had a few calls in between. You could try to get their LinkedIn URL with a Google Search column and with the company's domain as part of the query, condition it so it only runs for those that weren't enriched. Not sure if it will be accurate enough though.The alternative is to get them externally as you mentioned.