How to build a prospect list that actually produces shippers.

Most freight broker prospect lists die the same way. Someone exports a few thousand rows from a database, adds a "Status" column, blasts the same email at all of them, and three weeks later the sheet is a graveyard of "No response" with no idea why.

The reason is that the list was built backward. It started with contacts and tried to work toward freight. A list that produces shippers starts with freight, then the company, then the person, and it tracks the one thing that makes an email get answered: what you know about that shipper that a template does not.

This is the system I run. It fits in a spreadsheet or any CRM. The tool matters much less than the columns and the cadence.

1. Define the shipper you are looking for

Before a single row, write one sentence that describes your ideal account. Mine, when I started, was roughly: "flatbed and heavy haul shippers of building products, steel, and equipment in the Southeast and Texas, 50 to 1,000 employees, with weekly truckload volume and no private fleet."

Every clause in that sentence is a filter that keeps garbage off the list. Equipment type, commodity, region, company size, volume, and the absence of a private fleet. If you cannot write that sentence, you are not ready to build a list, and the guide to finding shippers walks through how to narrow it.

2. The 14 fields

One row per facility, not per company. A manufacturer with four plants is four rows, because each plant has its own shipping desk, lanes, and pain.

The Observation column is the one most brokers skip, and it is the one that matters. "Hiring a logistics coordinator as of August 12." "Expansion announced, 120,000 sq ft, opening Q1." "Driver says they load out Tuesdays and Thursdays, always short on trucks Thursday." If that column is empty, the row is not ready to be emailed.

3. Tier it: A, B, C

Not every row deserves the same effort. Three tiers:

• Tier A (10 to 15 accounts). Perfect fit for your lane, strong evidence they use brokers, a named contact, and a pain signal right now. These get hand-written emails, a phone call, and a follow-up sequence you track closely. One Tier A account turning into weekly loads changes your quarter.
• Tier B (20 to 25 accounts). Good fit, but missing one piece: no pain signal yet, or the contact is unconfirmed, or volume is unclear. They get a researched sequence and a lighter follow-up. Tier B accounts graduate to A when a signal appears.
• Tier C (everything else). Plausible shippers with no research yet. They get a quarterly touch at most, and they are mostly a holding pen for the next time you do a research session.

Re-tier every Friday. Something you learned during the week (a job posting, a driver comment, a reply) moves accounts up or down. The list should feel alive.

4. How big the list should be

For a broker working alone, about 50 active accounts across A and B, with a Tier C bench of maybe 100. That is the number where you can still remember who each one is, which is the entire point.

The math works in your favor. If you reach 50 well-researched shippers with a proper sequence, you will typically get replies from 8 to 15 of them, real conversations with 4 to 8, and a first load from 1 to 3 within a quarter. That is a better outcome than 2,000 templated emails producing zero, and it costs less, because you never burned your domain or your reputation doing it.

When an account converts, it leaves the prospect list and goes into your customer file. When an account goes dead (wrong fit, private fleet, explicit no), it gets a note and drops to a "closed" tab. Either way, you backfill from Tier C and the list stays at about 50.

5. Getting the contact

In order of reliability:

1. Call the plant. Main line, "Who handles outbound shipping?" Works more often than you'd expect, especially at manufacturers.
2. LinkedIn. Search the company and filter by "logistics," "shipping," "traffic," "transportation." Confirm the person sits at the facility you're targeting, not HQ.
3. Contact databases. ZoomInfo, Apollo, Lusha, and the like are good for turning a name into an email and a direct line. Treat the data as a starting point; it is frequently six months stale.
4. Email pattern check. If you know one address at the company, you know the pattern (first.last@, flast@). Verify with a checker before sending. Every bounce is a small hit to your sending domain.

Record the source next to every email. When a bounce comes back, you want to know which source to stop trusting.

6. The weekly cadence

The list only works if it is touched on a schedule. Mine, roughly:

• Every morning, 45 minutes: send 5 to 10 researched emails to Tier A and B accounts whose Next Action is today. Make 3 to 5 calls to the ones that opened but didn't reply. Log every touch.
• Every afternoon, 15 minutes: process replies, update Notes, set the next action.
• Friday, 1 hour: re-tier, backfill from C, and research 5 new accounts so Monday starts with a full queue.
• Monthly: send a light "market note" touch to every B account that went quiet: a rate you moved, a capacity swing in their lane, a regulatory change that hits their commodity. That one email revives more dead accounts than anything else I do, because it proves you are still paying attention.

That schedule is about 90 minutes a day. It is not glamorous, and it is the thing that separates brokers who have a book from brokers who have a list.

The short version

Define the shipper in one sentence. One row per facility with an Observation column that must be filled before anything gets sent. Fifty active accounts in three tiers. Contacts from the plant, LinkedIn, then a database. Ninety minutes a day on the cadence. Re-tier every Friday.

The research step is the slow part and the part that works. If you want it done for you, Outbound takes a shipper's name, runs the research, and writes the four-email sequence, which fills the Observation column and the outreach in one pass. The cold email template guide covers what goes in each email once the list is built.