Clay Icon

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

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Was that helpful?

  • Avatar of Jorge M.
    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.

  • Avatar of Channeled
    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!

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Channeled
    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!

Numbering Company Domain Occurrences in Email Lists for Campaigns | Clay