Continuing our series on finding and owning small fleets that run in lanes and don’t need to post on load boards—today we get tactical. This one is about rolling up your sleeves and rebuilding your carrier database so your team can finally stay off the load board for good
Here’s the Problem
You have a database of 20,000 carriers. It’s every carrier you’ve ever sold a load to, going back years. It feels like an asset. It looks impressive in the system. But be honest with yourself about what it actually is.
Those 20,000 carriers are just names. How many of them are single-truck owner-operators? How many are no longer in business at all? And of the ones still running, how many even remember who you are? Six months after one load, most of them don’t. You’re a phone number they took once. That’s not a relationship, and it’s certainly not capacity you can count on.
There is no tactical or strategic value in a giant carrier list when you can’t maintain even a minimal level of contact, and you have no reasonable expectation that any specific carrier will be in position to take your load when you need it. A number in a database that can’t help you cover freight is just digital clutter.
That is the key difference between a static list of names and an active, living database of known, useful vendors. One sits there. The other works for you. The whole point of this exercise is to convert the first into the second.
Let’s Start Fixing the Problem
First, the hard part: you’re going to tear down and rebuild your carrier database. There’s no shortcut around it. We do this for our customers every single day, and if you’d rather hand it to a team that does it for a living, that’s what we’re here for. But if you want to roll up your sleeves and do it yourself, here’s how to get started.
Get your data into a workable format. If you have a TMS with an indexed carrier database and search functionality, start by exporting all your carriers to a spreadsheet. A spreadsheet is far easier to manage, sort, and update in large chunks than working record-by-record inside the system. If you don’t have a TMS and you’re already managing your carriers in a spreadsheet, good news – you’re halfway there.
Once your data is out and workable, here’s the sequence:
- Identify the inactive and out-of-service carriers. This is your first pass. Flag every carrier that’s no longer operating, no longer authorized, or has clearly gone dark. This is the dead weight you’re going to strip out.
- Upload all carriers with active/inactive status to your database. Bring the full list back in, but now carrying the active/inactive flag you just created. You’re not deleting history, you’re labeling it.
- Put a check on all inactive carriers in your TMS. Mark them clearly so they never surface when a load is generated. They’re out of the working pool but still on record if you ever need to look back.
- Sort by size (power units) — 10 to 75. Now the important part. Using your spreadsheet, sort by fleet size and isolate the carriers running between 10 and 75 power units. These are your high-propensity carriers – your 5-star carriers. Big enough to have real capacity and a business to protect, small enough to need your freight and stay loyal. These are exactly the carriers you want popping up in your TMS the moment a load is created.
And finally: tag them with a lane identifier. This is what makes the whole database actionable. Tag each 5-star carrier with the lanes they run so you know who to reach when freight moves on a given corridor. Most TMS platforms can already identify carriers and send tender offers by shipment – the capability is sitting right there. It just goes unused, mostly because the database is so buried in dead weight that nobody trusts it enough to automate off of it. Clean the list, and that feature suddenly becomes powerful. For those working out of a spreadsheet, it’s just as simple: tag each carrier with a sort key you can search on the instant a load is available.
A Word of Warning
This is going to take time. Since you almost certainly don’t have live automations pulling from government sites to verify and update carrier status, a lot of this is going to be manual, and it’s going to be tedious. That’s the honest truth, and it’s a big part of why so many brokerages never do it and why their databases stay bloated and useless. It’s also exactly the kind of heavy lifting we’ve automated on our end, but if you’re doing it yourself, budget the hours and push through. The payoff is worth it.
Where This Leaves You
When you finish, you’ll have done something most brokers never do. Out of those 20,000 names, you’ll have identified probably two to three thousand carriers that can repeatedly haul the majority of your freight – safely, predictably, and without fear of the load-board unknown. That’s a real, workable, high-value network hiding inside the clutter you had all along.
But here’s the catch – at this point, they’re still just names. A clean, well-sorted, lane-tagged list is a foundation, not a finished house. You’ve identified your 5-star carriers. You haven’t developed them yet.
That’s where we go next. In the following email, we’ll cover how to turn these 5-star carriers into your carriers – how to make them know you, trust you, and want to haul your freight over your competitors’ every time.