Regarding Data enrichment from Clay, we faced few contacts whose domains are not even valid gets updated through enrichment. Like we update Employee Range through Clay in Hubspot and for this contact: pasonghandal@gmajl.com, Clay updated it's Employee Count as 204058. The company domain even do not exist. What we can do to avoid such cases?
👋 Hey there! Our support team has got your message - we'll be back in touch soon. 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!
One more case: oppocentral@2021.com
Hi Madhukesh, thank you for reaching out. The first thing you would have to do is verify whether or not the domains are valid or not. This could be done through the use of Claygent. In order to set up a Claygent operator, select "Add Column">"Use AI". https://downloads.intercomcdn.com/i/o/w28k1kwz/1276918716/e836627b13ca59b7535c60c4d0d3/CleanShot%2B2024-12-04%2Bat%2B15_31_35-402x.png?expires=1737651600&signature=2b6bf0cf6eecbc0e8fc2a186a8d1fb4fe24f0cde1f149991e382fbecbd655030&req=dSIgEMB%2FlYZeX%2FMW1HO4zXMPeyd0cxR3NjOO8RBYh8butw%3D%3D%0A Following this, select "Web research (Claygent)" and then, under "Model" select one of the three Claygent options below. As this is a simple task, using a cheaper version should fit your needs. https://downloads.intercomcdn.com/i/o/w28k1kwz/1276918714/de4ecb323c6dfd2fc33931cc1850/CleanShot%2B2024-12-04%2Bat%2B15_32_02-402x.png?expires=1737651600&signature=1b4a098b09caf37d0d9d7ad206c3f824c793b086291b3aa7fd747b4c35c8aede&req=dSIgEMB%2FlYZeXfMW1HO4zb5QBs2u1AmjFAbE7VnbFo%2Fu2g%3D%3D%0A Under "prompt" instruct Claygent what you want it to do. Remember that to input information that is stored in a column, you will have to use /column_name format. Here you could aks it to return "yes" or "no" for whether the domain is valid or not https://downloads.intercomcdn.com/i/o/w28k1kwz/1276918717/5816ce54e4a0a604e95178bb1e0d/CleanShot%2B2024-12-04%2Bat%2B15_32_30-402x.png?expires=1737651600&signature=d19b4ede8640d9ec25fb66b9d9a7c770d159feed7d04a7b5be123ca54160657a&req=dSIgEMB%2FlYZeXvMW1HO4zfM4pFuHBkpBHfZLUDWGP6Ub9A%3D%3D%0A Once you have created your prompt, press on "Save"> "Save and run 10 rows". This will show you the result for the first ten rows. https://downloads.intercomcdn.com/i/o/w28k1kwz/1276918715/2356ad927dfedaa944338d4892cc/CleanShot%2B2024-12-04%2Bat%2B15_32_35-402x.png?expires=1737651600&signature=e34ff5113d3d7ba984ce1750e453a50c9dc7df6c66f16f4fdcb7bc5bce63a050&req=dSIgEMB%2FlYZeXPMW1HO4zdxbbWIcQCy%2FTcgY15Fq0BvUKw%3D%3D%0A After this, you can use this response to run the enrichment column conditionally, only if the company domain is valid.
To do so, select the header of any column that you would like to work with. From the menu that pops up, select "Edit Column". https://downloads.intercomcdn.com/i/o/w28k1kwz/1289397518/e67530e46e57c0151454c3dbba9f/CleanShot%2B2024-12-09%2Bat%2B14_57_47-402x.png?expires=1737651600&signature=3b8545f8f84b4d411181cfd4502b3155b797cec8f13bea0688c666159c00d27a&req=dSIvH8p3moReUfMW1HO4zZcDigQozDwPDjttC6QyhrG6HA%3D%3D%0A Now, scroll to the bottom of the menu that appears. Under "Run Settings">"Only Run if" press on "Use AI". https://downloads.intercomcdn.com/i/o/w28k1kwz/1289397521/2fe5929c714bc81414127a9b3582/CleanShot-2B2024-11-21-2Bat-2B11_29_35-402x.png?expires=1737651600&signature=86f6c0fc78632b214a790c98f8d637b78832c0ee4ac506addc668adc8d03925f&req=dSIvH8p3moRdWPMW1HO4za3ngTQ3Se56klsWOi276HsKyQ%3D%3D%0A After selecting this, you'll be able to either use an AI prompt in the first box or JavaScript to instruct Clay on how to process the results from a column. An example of what this looks like is shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1289397522/0b69e57b3ac5174e30521d5b74ef/CleanShot-2B2024-11-12-2Bat-2B13_02_13-402x.png?expires=1737651600&signature=27d80313ae0022773b420d72f457d0052b8304b67c0f8ec1550a67e8e8bf9e44&req=dSIvH8p3moRdW%2FMW1HO4zasptLxFPigO2aKrC0%2Bcs4bl2g%3D%3D%0A In this case, I recommend using the first box to specify to Clay what type of condition it should verify before it runs this AI column. Here, tell it to only run if the result from the Claygent enrichment says "yes". Then, click on "Generate Formula," which will create a JavaScript formula for you and show the results that would be generated if the formula were applied. If you're satisfied with the results, simply click "Output Is Correct, Save Formula." The button is shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1289397517/1803d0c277f85424e07e8802b84e/CleanShot-2B2024-11-12-2Bat-2B13_06_48-402x.png?expires=1737651600&signature=32b3fe395d2198ab531dfdb1a38a182906e222d087457eea90ed79edcc9b33d6&req=dSIvH8p3moReXvMW1HO4zTTKqnm0sBuoUYWbohHYn9yM7A%3D%3D%0A Please let me know if this helps!
Hi Madhukesh G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
.png){kind=logo}
