Clay Icon

Best Practices for Enriching Company Info Without Duplicates

·
·

I have a test person table like that, what’s the best way to enrich company info and industry without duplicate enrichment for different people in the same company? I search the channel and yes we could create row number and only enrich first one among same company. But that way, at individual level we lose company info for people with row number > 1. One alternative solution I am thinking is wether we could create a separate table to extract the UNIQUE email domain and then do the enrichment. Then inside the people table, we do a row lookup to find the info we need. The problem is I cannot find a way to extract the UNIQUE email domain. “Write to table” does not work in this case since it requires a list in a single row whereas in our case it is multiple rows with same value. If my thought is not ideal, pls advice the best practice.

  • Avatar of Jinghang H.
    Jinghang H.
    ·
    ·

    For example, “vibe.us” is duplicates.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hi Jinghang, thanks for reaching out and great question! To avoid double-enriching any companies, what you can do is send your domains to a new table using "write to other table." In this new table, you can dedupe your company domains so you are only enriching one unique company domain. Once you've finished enriching, in your original table you can use a Lookup single row enrichment to conduct a vlookup to this table and pull the enriched company information/industry back into this table. Here's a quick tutorial on how to set this up: https://www.loom.com/share/3e3ebfdda5e84f1d9f80666144458c43?sid=dd9f7ab6-9646-4349-abaa-3ff1024eade7

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

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