Hi, can you please help me find the right US local colleges? I used keywords such as "education and education administration program" but the search results are not quite close to colleges in the US.
๐ Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Hi Abegail, thanks for reaching out. Taking a look at this now!
The best approach here would be to download this very exhaustive csv of already curated US colleges, and then upload it to Clay using the "upload list of companies from CSV" feature. You'll then be able to run all the enrichments you need, such as finding people, just by finding the companies domain using their name and the "find domain" waterfall feature: https://downloads.intercomcdn.com/i/o/w28k1kwz/1231912994/085a3fdbcf2fab7496efd444e863/CleanShot+2024-10-28+at+17_05_22%402x.png?expires=1730151000&signature=b64d7b7a88b45a344b6bb237d79b1717fe6bd839593bf3fe64bfb626ec2945a3&req=dSIkF8B%2Fn4hWXfMW1HO4zVXYSKVA9Lc1ikeIFPjuD%2BVi9Xa%2FHz6oPept8eDV%0AakGm%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
Thank you Bruno! I'll take a look at this
Happy to help, let me know if you have any other questions on this!
Hi Bruno, I do need some help. Remember the list you gave me? I only picked the Colleges and when I'm trying to extract the more people who are Director of Admission or anything that has to do with admission or enrollment a problem occur. I had 227 leads but when I'm trying to find more people this phrase would appear "Unable to fetch views for table" https://docs.google.com/spreadsheets/d/1q89olUAGakHgtNM-xqgWBkUr46BHyX5ozgZH4_aMAYI/edit?usp=sharing. Can you please help me? Thanks!
Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730227500&signature=d2367e2dea04473e0265503fd676020e3ff7665f3e2fd4c6aaed8e339e773b24&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv%2BBJAT2BKsam%2FhVPsJBQ%3D%3D%0A
Sure
This is the table of the colleges I'm trying to use to find people "https://app.clay.com/workspaces/352083/workbooks/wb_3BjHUSJYNVGr/tables/t_FZu7nkae9G8v"
It looks like you set a 100 person limit for each people search here: You should be able to edit this limit and pull in the remaining leads to your table as follows: https://downloads.intercomcdn.com/i/o/w28k1kwz/1233095339/6255ce63ddd226f86ddc29646be9/CleanShot%2B2024-10-29%2Bat%2B14_49_11.gif?expires=1730229300&signature=a13a7edb6a3a0356e630906e727bebf9324e2f79d9b3a7f193459371bb821ada&req=dSIkFcl3mIJcUPMW1HO4zayvkdPHPInh7O7r%2FeDY%2FojMnYDTJ%2FsPeN%2BvRZ4u%0A0tDh%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
I'll try this, thank you so much!
Happy to help here!
Hi Bruno, sorry I'm having a new concern again. I limit the search to a 100 but when I add the leads to my existing table https://app.clay.com/workspaces/352083/workbooks/wb_GPbqTUosZPyZ/tables/t_HAyQzodoZ7eR/views/gv_oQVkm52Mdysu. The leads still stay the same and is it because I have extracted all the people from the university table?
You can see this recording that my leads are still 227 even after doing another "Find People" process https://www.loom.com/share/0afa3f5ba81b480e81022f2d2c4424f7?sid=a67cb4bd-2ec9-47a7-a356-a794b7e79ab1
Apologies for the oversight, Abegail. Since you're on the free plan, your people searches are currently limited to 100 leads. To access the full list of leads, you'll need to upgrade to a paid plan. You can explore our various pricing options on our pricing page: clay.com/pricing
Thank you for this information! I have a follow-up question: If I create a table with 100 leads, is there a high likelihood of lead duplicates occurring?
There won't be any duplicates in the lead you're pulling because we have a built-in deduplication feature, which is enabled by default. This feature automatically identifies and removes duplicate entries from lead lists. https://downloads.intercomcdn.com/i/o/1140444503/13040b7166bf91139781adf3/CleanShot+2024-08-09+at+13_54_07.gif?expires=1730234700&signature=8f99f4e15205098af6b3098cfdceaa09aa27b1c9896a48126092ec78a4a8dfcc&req=dSEjFs16mYRfWvMW1HO4zU%2FZK1FmaJJmja5u6FVZLS5cYA%3D%3D%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!
Even if I make a different table with 100 leads each?
If you're in a different table, this won't apply, you also can't exclude leads on a free plan so the lead lists will most likely have a strong duplicate presence.
Got it Bruno, thank you so much!