Identify Work Emails with Mismatched Company Domains

Anna B. · 2025-03-06 09:08:56.288729+00

In peole table I have a column with company_domain and people's work_email. How can I find emails where domains are not matching in the email and company_domain?

To find emails where the domains don't match between work_email and company_domain columns, you can use a formula in Clay. Here's how: 1. Add a new column to your table. 2. Use the "Identify Email Type and Extract Company Domain from Email" enrichment on the work_email column. 3. Create a formula to compare the extracted domain with the company_domain column. 4. Use the "write to table" feature to filter rows where the domains don't match. If you need help setting up this process, you can request human assistance by clicking on "Talk to a person" for step-by-step guidance.

Source: Identify Email Type and Extract Company Domain from Email with Clay

2 comments