Clay Icon
Join the Community
02 Support

Understanding Dedupe Methods: Headline vs. Enrichment Comparisons

Avatar of Dominik L.Dominik L.
·
·

Q1: Can somebody tell me how this dedupe is working - I can dedupe the whole table (next to the headline) and also I can use the enrichment: Normalize and Deduplicate a List - what is the difference? And in one case I am also filtering double place-ids - what deduping should I use - from the headline or from the enrichment? Q2: When I want to include data from Outscraper via a Webhook. Should I include this directly into the table where I also enrich the whole data or should I include this in a separate table to clean the data their first, filter out useless data (f.e. listings where the address field is empty) and then include it in the correct table for enrichment. If the workflow should be like this how can I pull data from a cleaned table to another table in Clay? (Because when I filter everything in one table also the whole enrichment is running - I would need to adapt the run settings - I think for now I would be more convenient when there are different tables - one table for enrichment one table for pulling the data in via a webhook). Table I want to use for enrichment: https://app.clay.com/workspaces/258233/tables/t_G4HTCm3TKSAN/views/gv_uJXswk7hpfto

2 comments

  • Avatar of Dominik L.
    Dominik L.
    ·
    ·

    Okay got it. Q1: This means when auto-dedupe is active then this will not be imported in the table correct and it will not increase the numbers in the "rows" (first image attached)? Q2: It actually shows "491/1.337 rows" because of the filtering. The thing is just that when the local business are imported through the find local businesses enrichment I need to type in a keyword (column: keyword) and based on that everything else is running then in the table. But due to the fact that my filters are always active when importing new businesses with the enrichment the auto-dedupe function is not showing every business OR is there a problem with the filtering that when this is always active that it is filtering out some listings before even running some rows? When I delete the filters now, I can see that for some businesses the keyword was not added because when the filters are active this rows are not showing up. You got the point or should I explain it in a short video?

  • Avatar of Dominik L.
    Dominik L.
    ·
    ·

    reg Q2: I think I understand it now: The rows are running but when no Email is found then it will not show up. This mens that duplicates of the dedupe function are not listed here and the rows are not increasing. - it will not import them , correct?