Clay formula
Root domain from any email
Pulls the root domain and drops free providers so only company emails pass through.
Columns it needs
Email
The snippet
IF(REGEX_MATCH({{Email}}, "(?i)@(gmail|yahoo|outlook|hotmail|icloud|proton|aol)\\."), "", LOWER(SPLIT({{Email}}, "@")[1]))How to use it
- 1Create a formula column named Company domain.
- 2Empty output means the email was a free provider — skip enrichment on those rows.
emaildomainnormalize