Numbering Company Domain Occurrences in Email Lists for Campaigns

Clay EXPERTS! Anyone know how I can NUMBER the occurances of a company domain within an email list. USE CASE - I don't want 25 contacts from Unilever, for example, getting hit with similar emails - so want each occurance numbered, so I can limit the numbers being sent to Instantly

7 comments

Channeled
APP
·
·
To number occurrences of company domains in your email list, you can use our "Identify Email Type and Extract Company Domain from Email" action. Here's a step-by-step approach: 1. Use the action to extract company domains from your email list. 2. Use our "write to table" feature to create a new column for domain occurrences. 3. Apply a formula to count and number each domain occurrence. 4. Filter or sort based on these numbers to limit emails sent to each domain. For more specific domain-related actions, you could also use our Prospeo integration to find email addresses associated with domains. If you need further assistance with implementing this process, please ask to talk to a person for more detailed guidance.
Sources: Prospeo integration overview | Documentation | Clay University Identify Email Type and Extract Company Domain from Email with Clay
Channeled
APP
·
·
Was that helpful?
Jorge M.
·
·
I would create a formula to extract everything after @ in the email field. Then, use a lookup feature to count how many times the same domain is being used in the same columns. You get a JSON output that is easy to use/filter afterward.
Channeled
APP
·
·
We haven't heard back, so we're going to go ahead and close this out. Feel free to click the "Talk to a Human" button above if you still need help!
Channeled
APP
·
·
To number occurrences of company domains in your email list, you can follow these steps: 1. Use our "Identify Email Type and Extract Company Domain from Email" action to extract company domains from your email addresses. 2. Use our "write to table" feature to create a new column for domain occurrences. 3. Apply a formula to count and number each domain occurrence. You can use a lookup function to count how many times the same domain appears in the column. 4. Filter or sort based on these numbers to limit emails sent to each domain. This approach will help you manage the number of contacts from each company receiving similar emails, allowing you to control your outreach more effectively.
Sources: Identify Email Type and Extract Company Domain from Email with Clay Claybooks: Find key decisions makers and their emails using only a company URL | Clay.com
Channeled
APP
·
·
Did that answer your question?
Channeled
APP
·
·
We haven't heard back, so we're going to go ahead and close this out. Feel free to click the "Talk to a Human" button above if you still need help!