Clay Icon

Excluding Companies from CSV for New Search Table: A Guide

·
·

Question for everyone - how do you exclude companies that you don’t want to contact using a csv file that you have to build a new companies search table?

  • Avatar of Brandon C.
    Brandon C.
    ·
    ·

    Build a master “DNC” table and then do a “Look up” to see if there is a record. If a record exists, the workflow stops. I’ll be making a video tutorial on this exact topic this week

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    That would be really useful! so lets say if i have over 9K do not contact list and ive uploaded to clay as csv and when i create a new table uding the “look up” method, i should be able to filter them out? Is that right logically? Brandon C.

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    and would love to see the video too

  • Avatar of Brandon C.
    Brandon C.
    ·
    ·

    Kazuki O. yep, exactly that!

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    amazing! and Brandon C. one last question. for this option, does that use clay credit too or no?

  • Avatar of Nicolas P.
    Nicolas P.
    ·
    ·

    Adding to this: any difference between using a new table or performing the vlookup to a google sheet were I already have all those companies?

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    thats a great one too! if we could perform on google sheet that would be amazing

  • Avatar of Nicolas P.
    Nicolas P.
    ·
    ·

    You can, the feature is called 'Lookup Row'. You'll have to connect your file to Clay, it's pretty straightforward Don't know if it has any advantages or disadvantages compared to creating a table on Clay. Maybe Brandon C. has some insight on that

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    Brandon C. do you happen to know when you are releasing the tutorial videos 🙏

  • Avatar of Brandon C.
    Brandon C.
    ·
    ·

    Kazuki O. yep! Planning on recording it tonight!

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    Brandon C. that’s great! please let me know when its ready. hopefully during this week i would love to view it

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    Brandon C. i have a quick quesiton regards to look up. i was managed to do this but i noticed that i can’t create a new view so i can filter those company that mattched “Do not contact List”

  • Avatar of Kazuki O.
    Kazuki O.
    ·
    ·

    in this scenario, i want to make sure i dont enrich the company that is alreayd in the “Do not contact list” so how should I avoid this?