Which clay plans having unlimited columns?
None of our plans offer unlimited columns. All tables in Clay have a column limit of 70 columns per table. Within these 70 columns, up to 30 can be action or integration columns. If you implement a waterfall, the integration column limit increases to 40. Sources: Clay Plan Feature Overviews Table columns overview | Documentation | Clay University
Looks like you're still looking for help. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
i created this master table: https://app.clay.com/workspaces/334800/workbooks/wb_DYU7dUgPtiX3/tables/t_GRtmPyxhmcpV/views/gv_XHftqnRu3q3C those in blue columns are organic data that where i can fill-in information from different sources. Now if any of those Blue do not have data, those in Yellow will run for Enrichment. Now I would like to add more enrichment but I am stuck with 72 columns.
Hey Lemuel, thanks for reaching out. Apologies for the inconvenience here, we limit our tables to 72 columns to avoid any issues with table performance, speed, and efficacy. What other enrichments were you hoping to perform? What may be the best move here is separating out people and company enrichments. I noticed this table is first a person table, i.e. there is a single person per row. After figuring out what company this person works for and getting the website URL we could write this into a new table, perform all company enrichments and research in this new table, then look that data back up or have it written back into the original table to be used for drafting emails. Happy to provide some extra credits for you here to help with this. :)
will get back to you
Can you create a recording on how to get the data from table 2 ((company) to table 1 (employee)?
Happy to help! In this case we'll likely use a lookup column. Recorded a video on this process:loom video A contact table can have multiple contacts from the same company. Running company enrichments for each contact would duplicate efforts and waste credits. To avoid this, we store company data in a separate table, perform all enrichments there, and then reference that enriched data for each contact. Let me know what questions you have and how I can best assist! :)
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Hi Owen, I used the Lookup Single row in other table...but it appears, the lookup runs earlier than the enrichment on the other template is completed. is it possible to set a day in minute for the lookup to run?
or do you have some alternative?
I trying to have this in the run if: moment().diff(moment({{Created At}}), "minutes") > 2 do you know if there are some downside?
Hi Lemuel, thanks for reaching out! I’m looking into this now. Unfortunately, there’s no built-in way to delay runs, but you can work around this by calling the Postman delay endpoint: https://www.postman.com/cs-demo/kevin-swiber-s-public-workspace/request/n10q1y1/returns-a-delayed-response-max-of-10-seconds. This will allow you to set your lookup to run only after the delay has elapsed. Let me know if you need any help setting it up!