Clay Icon

Issue with Phone Number Watermark Feature and Merge Column Errors

ยท
ยท

hello. I'm having an issue with your phone number watermark feature. I edited the enrichments in it, and now I can't get the merge final column to work properly. I've tried everything; I've even spoken to my Clay consultant externally who taught me how to use Clay. He told me that he's had the exact same issues before and that all of the avenues I'm trying to do to remedy it, he'd tried too and he mentioned that he spoke to you and you were able to help solve it from the backend this is the table https://app.clay.com/workspaces/33727/workbooks/wb_8NvEe2D3BoHz/tables/t_UQfH7Tc6Y6qx/views/gv_7gJRS88gCkoM the column is right at the end "Mobile WATERFALL MERGE 1" , i simple want that to merge the values from the remaining mobile number finding enrichments and not have any errors, thanks in advance for your help. As a side note, due to these limitations, I won't be using the mobile number waterfall feature again. I'll instead try to build it myself. Hopefully you guys can fix this feature, as it's not a good sign that myself and another power user don't use it for this exact reason. We must have flexibility that's the whole beauty of your system, and right now we don't have any flexibility. It certainly doesn't make sense to have the most high credit using provider Data GMA at the start

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    Hi Scott, thanks for reaching out! I took a look at your Mobile Phone Number waterfall and multiple columns are showing the error Settings contains deleted column for "Conditional Run" input Looking at the conditional formula on your columns it looks like a validation column was deleted. Did you happen to use a phone number validator and then delete these columns? It appears doing so has prevent the logic of your waterfall from completing. Because the waterfall was created with the logic of returning only validated phone numbers, if the phone numbers can't be validated then they can't be returned. I'm refunding you the credits used in the mobile waterfall so that you can re-run them again correctly without the validation provider. Here's a more detailed explanation: https://www.loom.com/share/d27dfe1e33564ab6a794e30d7d51e154?sid=e300e216-04a1-4c3b-b099-69a819aeb182 Let me know if this makes sense and if you have any other questions!

  • Avatar of Scott L.
    Scott L.
    ยท
    ยท

    Tanvi, ๐Ÿ‘‹ Thank you for this. I'm logging off shortly as I am based in Dubai and it's 8:00 pm. To clarify on a few points, I did indeed add a phone number validator at one point, but I did that separately as a completely separate enrichment, not part of the mobile waterfall process. Just because I create a phone number verification column, I don't see how that relates to my waterfall. Full stop. I will watch your video and everything in more detail tomorrow and hopefully that will get me on the right track. As for refunding the credits, I'm not trying to grab credits - I used thousands on this waterfall task today, and it's not even that I need them back, I just need to be able to merge the data that I've already got . Are you saying that I'm screwed and I need to rerun the whole thing again?

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    Hey Scott, the phone number verification column affects your mobile number waterfall as it is one of the conditions listed under only run if for each of the data providers in your phone number waterfall. Because this condition can't be met, your waterfall is unable to complete. Here's a loom tutorial explaining this further: https://www.loom.com/share/c324ea095f104d999b66f960173a9382?sid=8167fee7-7a6a-42f0-bd3d-62e32d9a005d Additionally, could you clarify which phone number data you're still looking to pull? It looks like the column Mobile Waterfall Use HS Final next to the Mobile Waterfall Merge 1 column has phone numbers for all rows so I'm not sure which data you still need. Happy to help once I know more. Let me know if the Loom explanation makes sense and if you have further questions!

  • Avatar of Scott L.
    Scott L.
    ยท
    ยท
  • Avatar of Daniela D.
    Daniela D.
    ยท
    ยท

    Hey Scott! Thanks for sharing. I made a follow up video further clarifying the error in the waterfall and sharing suggestions for setting up your preferred configuration for providers: https://www.loom.com/share/26078457ebb14b69a1d4264a61efcf78 We'll run tests for the issue you flagged with RocketReach and verification for Nimbler and get back with an update๐Ÿ™๐Ÿฝ.