Column Limit Issue: Assistance Required for Table 't_KA3TQ3PMcznZ'

https://app.clay.com/workspaces/164087/workbooks/wb_wbaxbDJndPXn/tables/t_KA3TQ3PMcznZ/views/gv_PQHxiw2xMX38

Hey Mike, thanks for reaching out! Checking this out right now

Hey Mike, which columns or enrichments were you hoping to add to this table?

find mobile phone

with 10 columns i think

Hey Mike, I made an adjustment so you should now be all set to add a mobile phone number waterfall! This limit helps balance performance and complexity, so if you plan to add additional enrichments, consider using a separate table. :)

Owen

still getting this problem

Table 't_KA3TQ3PMcznZ' cannot create new attribute due to column limit

when i select all 10 enrichments plus validation, and set run setting requirement

only 41 columns

i dont get whats happening here

Got it, looking into this further

yea please take a look if you can

After checking this out, I'd recommend using a separate table to enrich the phone numbers of these contacts to keep this table performing up to our standards. While it's true, there are only 41 columns, most of them are relatively compute-intensive, which could lead to performance issues over time. Seeing that you have a table within this workbook titled 'Phone Number Enrichment', this works perfectly! What we can do is: 1. Use a 'Write to other Table' function to write the LinkedIn Profile URL associated with each contact from 'Smartlead Webhook' into 'Mobile Phone Enrichment' table 2. Once this data is written over, create a Mobile Phone Number waterfall using the LinkedIn URL as an input 3. Then, go back into 'Smartlead Webhook' and create a 'Lookup' column that uses LinkedIn URL as an input (this function will pull all data associated with the unique LinkedIn URL from 'Mobile Phone Enrichment' back into the 'Smartlead Webhook' table 4. Once the 'lookup' column has ran, you'll have access to all of the data associated with this URL in the other table and you can map out the phone number that was found while using a lot less valuable column space in your main table Hope this helps and clears things up! I'm happy to help set this up if you'd like :)

Can we automate this process?

isnt this going to happen to quickly and it wont automate?

My problem is that that i send this to another table, it takes time to run, then i need to run that n8n call from the original smartlead table

Got it, this is what I'm looking into a bit further as that is a good point, what data are you pulling from the n8n call?

i need mobile phone

to be sent to n8n

now im super confused how to do this

Stuff missing a mobile number needs a mobile lookup, stuff with mobile can be sent right away

Apologies for the confusion. I'm looking into this further, in the meantime try creating the mobile phone number waterfall on the main table (Smartlead Replies) as initially discussed. Going to bring this up with my team but want to unblock you here, therefore you should be able to create the phone number waterfall on this main table and I'll refund the credits that were ran on the phone # waterfall in the table titled 'Mobile Phone Enrichment'.

thats fine by me but ive tried twice and it simply wont create

Hey Mike, some of the data providers that are being used require the contacts Social Profile URL as an input to be ran. This is whats causing some of the errors in these cells. If you'd like to use LinkedIn Profile as an input, it can be easily found with the emails you've already collected plus some related data. (image of waterfall to collect LinkedIn URL below) Hope this helps, let me know how else I can assist here and if you have any other questions or concerns. https://downloads.intercomcdn.com/i/o/w28k1kwz/1248050080/a47c17d8f56a367e7cc03365d03d/CleanShot+2024-11-11+at+17_50_05%402x.png?expires=1731367800&signature=8fb4e66b7cd957ba6f2adea1a98add5355aad080b03eeca28a5072391f769b9b&req=dSIjHsl7nYFXWfMW1HO4zbst1bLvEdJLJzKGK2rZlR34lxh6n2pm7ymG8t%2B%2B%0AM3np%0A https://downloads.intercomcdn.com/i/o/w28k1kwz/1248050866/70699903990c6cf42bb1eb6ec674/CleanShot+2024-11-11+at+17_51_00%402x.png?expires=1731367800&signature=003ac30b2b574a17eeb12bccaafa6a2a1a70c4afef45e6242fd3de21e214f812&req=dSIjHsl7nYlZX%2FMW1HO4zdyMPMAHm7t%2FTk659fWAVpxrnIvVzIYt6E5XK7Pl%0AYn2D%0A

yep i see that

can you increase my enrichment columsn to 40

instead of 35 please

The enrichment column limit has already been raised to 40.

can i get 45 then please

i need 2 more

Should be good to go! :) Are you running into this limit still?

thank you for all your help!

Of course! Let me know how this goes and don't hesitate to reach out with any other questions or concerns :)

Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!