Hey Clay S. I have an active list using data from Store Leads. I have a lot of duplicate domains and I need to clean the list and keep the main domain. Using the list of SI Alternates, How can I find and choose the highest SI Ranks? Here´s a video where I explain the use case. Table link here.
To clean your Store Leads list and remove duplicate domains while keeping those with the highest SI Ranks:
1. Use the "Normalize and Deduplicate a List" tool in Clay to standardize your domain formats first.
2. For deduplication based on SI Ranks, you can:
• Click on the column header containing your domains
• Select "Dedupe" from the dropdown menu
• Use the SI Alternates list to identify main domains with highest SI Ranks
3. Alternatively, transfer this data to another table using the "write to table" integration and run the deduplication there.
Hey Patricia, thanks for the context! Let me know if this approach works for you:
1. We can take each value in the column (e.g., [apple.com](http://apple.com), [apple.fr](http://apple.fr), [apple.de](http://apple.de)) and write each individual domain into a new table, one domain per row.
2. In that new table, each domain (like [apple.com](http://apple.com)) would have its own row.
3. Then, in the original table, we can add an enrichment using “Lookup Single Row” that searches across the new domain table for matches.
Does that sound like what you're trying to achieve? If so, we can figure out the next step from there.
I´m not sure. How can we make the "lookup" understand that I want to go to 3 different rows (apple.com, apple.fr, apple.de) and see which one has the lowest Rank?
Hey Patricia, that would be the next step.
1. Step: Find matches - see explanation above.
2. Step: If there's a match, we're going to perform a "Lookup multiple rows" within the same table, and determine which ones has the lowest rank.
I agree, it's not a straightforward cleaning task. Want me to give it a try on your table?
Hey Patrícia, good news. I found a way. I made a loom for you ::)
[https:://www.loom.com/share/d0f58c00bc3f491a91a0d5e354e9b1e8](https://www.loom.com/share/d0f58c00bc3f491a91a0d5e354e9b1e8)
If there's anything else I can assist you with, please let me know! 😊
Have a great Tuesday,
Daniel
.png){kind=logo}
