running a builtwith enrichment on a list and having two separate cell...

running a builtwith enrichment on a list and having two separate cell data restriction issues. for one domain, i can’t even see the enrichment box due to cell data size. and then second, for some of them, i can’t extract the ‘technologies found’ because of cell data size. i’m fine with extracting a portion of this, the first X number of characters. i believe the cell data size limit is 8,000 characters. the table is: https://app.clay.com/workspaces/10750/tables/t_FtLephTMoRCU/views/gv_rHWQpjAkF9Ds

10 comments

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 😉
Clay Team
APP
·
Hey Harris!! Yup, the first one is something the team is looking into soon, the second one you can achieve with a couple of formula columns and split by 8000 characters as you say
Clay Team
APP
·
Let me know if you need help setting up the second one or if you run into issues!
Harris K.
·
Hi Arturo yes could you please try to help me with the second? i tried this but it seems like i got it wrong 😇
Clay Team
APP
·
Hey Harris - quick thought here. You could add a "Last date detected" filter to reduce the size here (and also remove any results that may be too old
Clay Team
APP
·
Looks like you already have a formula for pulling out the first 7k characters - still need help here?
Harris K.
·
GREAT idea about last date detected, the 7k thing didn’t seem to work but idk why not
Clay Team
APP
·
Sorry for the delay! Will check if there's anything we can improve/add to the formula
Clay Team
APP
·
Harris K., I added the two columns at the end in case it helps. 1st 7k then 8k.
Harris K.
·
tysm