Clay Icon

Column Limit Issue: Assistance Required for Table 't_KA3TQ3PMcznZ'

·
·

Table 't_KA3TQ3PMcznZ' cannot create new attribute due to column limit - need some help

  • Avatar of Owen C.
    Owen C.
    ·
    ·

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

  • Avatar of Owen C.
    Owen C.
    ·
    ·

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

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    find mobile phone

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    with 10 columns i think

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    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. :)

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    Owen

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    still getting this problem

  • Avatar of Mike B.
    Mike B.
    ·
    ·

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

  • Avatar of Mike B.
    Mike B.
    ·
    ·

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

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    only 41 columns

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    i dont get whats happening here

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Got it, looking into this further

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    yea please take a look if you can

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    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 :)

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    Can we automate this process?

  • Avatar of Mike B.
    Mike B.
    ·
    ·

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

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    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

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    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?

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    i need mobile phone

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    to be sent to n8n

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    now im super confused how to do this

  • Avatar of Mike B.
    Mike B.
    ·
    ·

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

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    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'.

  • Avatar of Mike B.
    Mike B.
    ·
    ·

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

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    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

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    yep i see that

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    can you increase my enrichment columsn to 40

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    instead of 35 please

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    The enrichment column limit has already been raised to 40.

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    can i get 45 then please

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    i need 2 more

  • Avatar of Owen C.
    Owen C.
    ·
    ·

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

  • Avatar of Mike B.
    Mike B.
    ·
    ·

    thank you for all your help!

  • Avatar of Owen C.
    Owen C.
    ·
    ·

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

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

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

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    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!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Mike B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: