How to Count Contacts per Company on a Lead List (and Find Accounts With Only One)

To count contacts per company on a lead list, take the part of each email address after the @ sign, treat it as the company, and count how many rows share each one. The accounts with the fewest contacts sort to the top, and those are the accounts that need attention. This post covers how to decide what a company is, why single-contact accounts are fragile, what to do about them, and where counting by domain misleads you.

Count contacts per company →

When a count by company helps

Most lead lists are sorted by person. You scroll them by name or by row number, and nothing tells you that three of the first twenty rows work at the same firm while two hundred firms appear only once.

That matters when you sell to companies and want more than one person involved. Account-based outreach usually means reaching two or three people at each target account, such as the buyer and someone who will use the product. A list that gives you one address for most accounts cannot do that, and you will not see the gap until you count.

It matters in the opposite direction too. If you do not want to email five colleagues at once, you need to know which accounts have five. The coverage count shows both ends: accounts with too few contacts for your plan, and accounts with too many.

How a company is decided

The method is mechanical. For the address jane@example.com, the company is example.com. For leo@example.com, it is also example.com. Those are two contacts at one account.

A few rules keep the count honest:

• Personal mailboxes are not grouped. Gmail, Outlook, Yahoo and other free providers are counted on their own line. Two people at gmail.com have nothing in common, so treating gmail.com as a company would make a one-account list of unrelated strangers. The list of free providers is fixed, which is a limit: a smaller free provider that is not on it would be counted as a company. The free vs business email filter separates the two groups if you want them in different files.
• The same address twice counts once. Duplicates would otherwise inflate a company's count. The repeats are reported so you know how many there were. To remove them from the file itself, use the duplicate contact finder.
• Rows without an address are not assigned to an account. They are counted, but they cannot belong to a company you cannot name.

Where counting by domain misleads you

Domain is a good proxy for company, not a perfect one.

• A company with two domains counts as two accounts. A business that sends mail from one domain and has its website on another will appear twice, each with fewer contacts than the company really has.
• A subsidiary on the parent's domain counts as part of the parent. If three divisions all use one domain, they look like a single account, though to you they may be three different buyers.
• Shared domains look like accounts. An agency whose clients all have addresses on the agency's domain, or a university with many departments, looks like one big account.

None of this makes the count useless. It means you should read it as a prompt to look, not as a fact. Accounts with a surprising number of contacts are the ones to check by hand.

Why a single contact is fragile

Suppose your list has 400 accounts and 260 of them have one contact each. That looks like a lot of coverage, but each of those accounts depends on one address being correct and one person being the right person.

If that one address is dead, the email bounces and you have nothing at that company. If it is alive but the person is the wrong one, nobody else at the company hears from you either. With two or three contacts there is a margin: one bounce does not end the account.

So the single-contact accounts are where verification matters most, and where finding a second contact pays back. This is not a claim about how many of any given list will bounce; it is the structure of the problem. One point of failure is worse than three.

Step by step

1. Upload the list as .xlsx or CSV, or paste the cells with the header row first. The email column is found for you.
2. Set the number of contacts you want at each account. The pre-filled 2 is an example. Use the number your sales plan calls for.
3. Read the stats and the table of accounts, fewest contacts first. You see how many accounts exist, how many have only one contact, and how many fall below your target and by how many contacts.
4. Download the account report to see where you need more contacts, or the list with a count added to every row.

The target can be changed after the report is made, and the stats and table update at once, so try a few numbers.

What to do about accounts with one contact

You have three honest choices.

Find a second contact. Use whatever source you normally use for the role you want. The report tells you which accounts need one and how many are short, so you can prioritise. It does not read job titles or find people. If you add contacts, put them into the same file and run the count again.

Keep the one you have and verify it. If a second contact is not worth finding for a small account, make sure the one address is valid before you send. Our post on what to do when a lead has several addresses covers choosing between addresses for one person, and the primary email picker does that choice for a whole list.

Leave the account out of a multi-person play. If the plan needs three contacts and you will never have three, take that account out of the sequence that assumes them and put it in a simpler one.

When you want the opposite: fewer contacts

Counting also finds accounts that are over-covered. If you do not want to email more than a few people at one company, set a target for the maximum and look at the top of the count instead. To enforce the limit by removing the extras, use the limit contacts per company tool. To segment the list by company size or any other column before sending, the email list segmenter can help.

Verify the addresses behind the count

A contact count treats every address as real. That is an assumption, and a coverage report built on dead addresses is false comfort. An account that shows three contacts may have one live mailbox and two that bounce.

So verify the list alongside the count. Upload the file at /verify and SimpleVerifier checks each address and tells you whether it is valid, risky or invalid, with the reason. Then run the coverage count on the cleaned file, and the numbers reflect contacts you can actually reach.

SimpleVerifier Pro is $39 a month, with the first 100,000 checks a month at full speed, then slower, never cut off. If you merge several sources into one list first, our post on duplicate leads across CRM sources explains how to avoid counting the same person twice under different addresses.

Limits

• It counts email domains, not companies. A company with two domains counts twice.
• It does not read job titles, so it cannot say whether the contacts are the right people.
• Rows without an address are counted but not assigned to an account.
• Free-mail providers are recognised from a fixed list.
• The file is read and counted in your browser. It is not uploaded to SimpleVerifier.

A short routine before each campaign

1. Verify the list and remove invalid addresses.
2. Run the coverage count with the target you want per account.
3. Sort the short accounts out: find a second contact, or move them to a simpler sequence.
4. Check the over-covered accounts and decide whether to cap them.
5. Send, and keep the account report so you can see which accounts replied.

The count takes seconds to run and tells you something your row-by-row view never will: how your list looks from the point of view of the companies on it.