Join the Community

Should I modify my company enrichment query to use LinkedIn URLs for the previously unsuccessful companies, or run a new enrichment?

·

·

Following on from a previous message, I had a problem where company enrichment didnt work using company url although the company did have a LinkedIn presence. I have now created a search query concatenating company name, city, and LinkedIn, and got the missing company LinkedIn urls. My question is, should I modify my current company enrichment query to now use the company LinkedIn url and not company url and only run on the ones that didnt work before (will it replace the already populated companies). Or run a new enrichment on the ones that didnt work before? Thanks

6 comments

Jon B.
·
·
https://app.clay.com/workspaces/161855/tables/t_WaXyw5CK5teW/views/gv_HD7L84VHw1eW
Clay Team
APP
·
·
Hey Jon, thanks for reaching out! Do you mean running the LinkedIn enrichment? You can change the source but make sure to only run the ones that didn't get enriched, you can apply a filter on them.If you choose "run all rows that haven't run" for the entire list, it will re-run the entire column because the source is different, so the filters would help save you credits and only get the missing ones.
Jon B.
·
·
Thanks, Im having trouble setting up the conditional formula, it looks like it should work, but it will cause an infinite loop apparently, see screenshots:
Jon B.
·
·
Looks like I'd have to create an additional Enrich company?
Clay Team
APP
·
·
Sorry for the delay, Jon! Looks like it contains a value that is generated from the Enrich Company itself so that's why it's causing a loop error message. Indeed it would be easier to add a new column that only runs for those that are empty, that could be another conditional formula
Jon B.
·
·
👍