Clay Icon

Mapping Company Lookalike Results to a New Table Efficiently

ยท
ยท

Hi, I have a list of about 1230 and I have run a company lookalike search. How do I map all of the different companies to a new table? I did it once already where I mapped the results to a new table, and I got 12k rows. Although, when I enabled auto-dedupe, it reduced to 49. Is this because all of the lookalike companies for each row where the same and there we only 49 unique ones? I basically want to know if the method that I did imported all of the lookalike companies, or just the ones from the cell I clicked "write to new table" on.

  • 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.
    ยท
    ยท

    Hey Tom, thanks for reaching out! Write to table is the best method here to map all the lookalike results to a new table. When you select write to new table, the new column will run on all rows so all of the companies in each row should be sent to a new table, not just the cell you selected it for. Which column did you enable Auto-dedupe on? We typically recommend deduping on a unique identifier such as LinkedIn url. If you deduped on a non-unique identifier such as "Country" for example this could explain why you are seeing such a significant drop in results. I've attached more info on auto-dedupe below. If you share the table you're working from I can take a closer look :) [App: Article Inserter]

  • 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 Tom V.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Tom V.
    Tom V.
    ยท
    ยท

    Please can you take a look. Here is the link to the other table that I mapped the lookalikes to https://app.clay.com/workspaces/139337/tables/t_6grjc4TBgEDG/views/gv_QKwxGREbnvfz

  • Avatar of LuisArturo
    LuisArturo
    ยท
    ยท

    Hey there Tom thanks for reaching out, made a loom explaining what occurred here and a solution to address this issue. https://www.loom.com/share/28262d4d9d3f458ebbf88ba12f5a3007?sid=8b9512bd-9036-493d-921c-b5a01e8a598f