Cleaning Duplicate Domains and Selecting Highest SI Ranks

Patrícia S. · 2025-07-02T09:49:33.852Z

Hey 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 where I explain the use case. Table link .

Cleaning Duplicate Domains and Selecting Highest SI Ranks | Clay

15 comments

· Sorted by Oldest

Clay
APP
·
·
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.
Sources: Normalize and Deduplicate a List with Clay What is De-dupe? | Clay
Patrícia S.
·
·
links already provided
Patrícia S.
·
·
Hello, still waiting for reply
Daniel K.
·
·
Hey Patrícia, thanks for reaching out and sorry for the delay. Just to clarify, you want to see if there's a match from SL Alternates in Domain?
Patrícia S.
·
·
If a row has alternate domains, I want a way to search them in the domains column and identify which one has the lowest SI Rank.
Patrícia S.
·
·
https://www.loom.com/share/a3805da8cfe842c8ac34775ce9f96f2c?sid=49a64fc2-8cb4-4295-8a80-ea55196cdd5f
Patrícia S.
·
·
Let me know if you understand what I mean 🙂
Daniel K.
·
·
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.
Patrícia S.
·
·
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?
Daniel K.
·
·
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?
Patrícia S.
·
·
hey Daniel K. Yes, please
Daniel K.
·
·
Hey - I'm going to have a look at it tomorrow first thing. Hope it works for you
Daniel K.
·
·
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
Channeled
APP
·
·
Clay
APP
·
·
Thank you so much for sharing your feedback Patrícia S.!

Clay
APP
·
·
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.
Sources: Normalize and Deduplicate a List with Clay What is De-dupe? | Clay
Patrícia S.
·
·
links already provided
Patrícia S.
·
·
Hello, still waiting for reply
Daniel K.
·
·
Hey Patrícia, thanks for reaching out and sorry for the delay. Just to clarify, you want to see if there's a match from SL Alternates in Domain?
Patrícia S.
·
·
If a row has alternate domains, I want a way to search them in the domains column and identify which one has the lowest SI Rank.
Patrícia S.
·
·
https://www.loom.com/share/a3805da8cfe842c8ac34775ce9f96f2c?sid=49a64fc2-8cb4-4295-8a80-ea55196cdd5f
Patrícia S.
·
·
Let me know if you understand what I mean 🙂
Daniel K.
·
·
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.
Patrícia S.
·
·
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?
Daniel K.
·
·
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?
Patrícia S.
·
·
hey Daniel K. Yes, please
Daniel K.
·
·
Hey - I'm going to have a look at it tomorrow first thing. Hope it works for you
Daniel K.
·
·
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
Channeled
APP
·
·
Clay
APP
·
·
Thank you so much for sharing your feedback Patrícia S.!