Skip to content

Which lanes should our sales effort go to?

Join your Tai load export to HubSpot. Rank lanes by loads and net revenue per load, find the markets that take in more loads than they send, and see which shippers your best lanes come from.

Open Querri

What you'll need

Querri (Free trial) to join the exports and run the checks

A Tai load export and HubSpot: Step 1 says what each adds

Your lane rules: so every lane is ranked the same way

Free resources

Start your free trial here →

Sample data sets

Synthetic data for a made-up freight brokerage. Not real shipper data.

Need help?

If you have any questions, you can request a demo or email our team.

Before we begin

Sales effort tends to follow the busiest lanes. Busy and profitable aren't the same thing, and a market that takes in far more loads than it sends is a sales opportunity in the other direction. The lanes and rates are in the TMS and the shipper profiles are in the CRM, so a lane plan usually rests on whichever report someone pulled last.

This playbook ranks October's lanes by loads and net revenue per load, finds the markets that need outbound freight, and profiles the shippers behind the strongest lanes.

How it works:

  • • Upload the Tai export and connect HubSpot
  • • Rank lanes by loads and net revenue
  • • Find markets that take in more than they send
  • • Profile the shippers on strong lanes
  • • Build the lane focus list

Follow the steps

Open Querri →
1 Step 1:

Upload the Tai export and connect HubSpot

Two systems, one project:

  • •

    Tai load export (or your TMS load report): every load with origin, destination, equipment, customer total and carrier total.

  • •

    HubSpot: each shipper's industry, region and Tai customer code.

HubSpot connects directly and syncs on a schedule. The Tai export comes in as a file; upload next month's over the old one and every view rebuilds.

Tip: Pull at least seven months of loads, so every lane has a six-month average to compare with.

  • Tai load export
  • HubSpot companies
Querri One project
2 Step 2:

Rank lanes by loads and net revenue per load

Start with volume, and put each lane's earnings next to it:

Prompt

"Rank October's lanes by loads, with net revenue per load against April to September. Which busy lanes slipped?"

Atlanta to Dallas is the busiest lane by far and holding steady. Los Angeles to Phoenix earns 34.3% less a load than its April to September average, the largest drop among lanes with 30 or more October loads. Six of the top 10 lanes are down.

Rank lanes by loads and net revenue per load
LaneOctober loadsPer load, usual to OctoberChange
Atlanta to Dallas (Dry Van)249$168 to $167-$1
Fresno to Denver (Reefer)169$213 to $168-$46
Los Angeles to Phoenix (Reefer)115$119 to $78-$41
Memphis to Charlotte (Dry Van)85$130 to $133+$3

Busiest lanes, October 2026, net revenue per load against April to September.

3 Step 3:

Find the markets your loads deliver into most

Compare loads in and loads out for every city:

Prompt

"Which cities take in far more of our loads than they send out, and how has Dallas moved since April?"

Dallas takes in 216 more loads than it sends out, its widest gap since April; from April to September it ran 143 to 183. Atlanta sent 250 of the 306 loads into Dallas. That makes outbound Dallas worth exploring for backhaul freight.

Find the markets your loads deliver into most
CityInOutImbalance
Dallas30690216
Denver22941188
Charlotte17738139
Phoenix15114137
Columbus891970

Loads in and out by city, October 2026.

4 Step 4:

Match strong lanes to shipper region and industry

Find the lanes that earn the most, then the shippers who send them:

Prompt

"Which lanes earn the most per load, and which shipper industries and regions do they come from?"

13 lanes clear the top-quarter bar of $261 a load, on 242 October loads. 58.7% of those loads come from Food & Beverages shippers and 56.2% from shippers in the West: the profile to look for in new accounts.

Match strong lanes to shipper region and industry
LaneOctober loadsNet revenue per load
Ontario to Miami (Dry Van)11$650
Fresno to Charlotte (Reefer)17$602
Fresno to Green Bay (Reefer)22$522
Fresno to Indianapolis (Reefer)29$512
Detroit to Fresno (Reefer)14$505

Strong lanes, October 2026: top quarter by net revenue per load, 10 or more loads.

5 Step 5:

Build the lane focus list for sales operations

Four numbers for the planning meeting, and where to point the reps.

The narrative Querri writes:

October's busiest lane is steady, two western reefer lanes earn far less a load than usual, and Dallas takes in far more loads than it sends.

What you can create or export:

  • The list, to Excel, CSV or Google Sheets
  • A live dashboard that refreshes with each HubSpot sync and Tai upload
  • A presentation for the meeting, to PDF or PowerPoint
Build the lane focus list for sales operations
Lane or marketOctoberFocus
Outbound Dallas216 more in than outSell freight out of Dallas
Los Angeles to Phoenix (Reefer)$78 a load, down 34%Review rates first
Fresno to Denver (Reefer)$168 a load, down 21%Review rates first
Fresno to Charlotte, Green Bay, Indianapolis (Reefer)$512 to $602 a loadFind similar shippers

The lane focus list, November 2026.

Point the sales team at lanes that pay, and markets that need freight.

Try it on your own data
Querri for freight sales See how Querri helps brokerage sales teams put the CRM and the TMS in the same conversation, from rep activity to loads and margin. See Querri for sales

See Querri for the whole brokerage

Tips for a lane plan built on the loads

Rank by earnings, not only volume

The busiest lane can earn less a load than a dozen smaller ones. Put net revenue per load next to every count before deciding where to sell.

Sell into the imbalance

A market that takes in far more than it sends has trucks looking for freight. Shippers there can get capacity, and the brokerage cuts empty miles.

Teach Querri your rules once. Every answer after that follows them.

What a lane is, what counts as strong, how the imbalance is measured: say each rule once and Querri applies it to every question on that data.

Show me how

Say it in chat

Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.

Prompt

"A lane is origin city to destination city plus equipment type. Save that as a rule for the Tai loads table."

Or bring the document that already says it

Upload your sales plan or territory document like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:

  • Lane: origin city to destination city, with equipment
  • Net revenue: Tai Customer Total less Carrier Total
  • Usual: the prior six months, April to September
  • Strong lane: top quarter by net revenue per load, 10 or more loads
  • Imbalance: loads in less loads out, by city
  • Matching: Tai to HubSpot through the Tai customer code
Prompt

"Read our sales plan and propose the rules it states about target lanes, regions and industries. I'll review them in the Inbox."

Where the rules reach

A rule is attached to the data, not to one person's chat, so it follows the data everywhere:

  • • Every question asked in chat, by anyone in sales operations
  • • Every view the Librarian builds on that data
  • • Every step of a project, including the code it writes
  • • Dashboards and scheduled runs, each time they refresh
  • • Claude and ChatGPT, when they ask Querri

You stay in control

Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.

The payoff at sales planning

Planning starts with the lanes that pay, the lanes to review and the market that needs freight. Changing the bar for a strong lane is a sentence.

Frequently asked questions

What is a lane?
Origin city to destination city, with the equipment: Atlanta to Dallas (Dry Van) and Atlanta to Dallas (Reefer) are two lanes.
What is net revenue per load?
Customer total less carrier total on the Tai load, divided by the number of loads on that lane.
What is the imbalance?
Loads delivered into a city less loads picked up there in the same month. A large positive number means trucks arrive and need freight to leave with.
Why only lanes with 10 or more loads?
A lane with three loads can look like the best or worst in the book by chance. Ten keeps the ranking steady; change it in one sentence.
How are Tai shippers matched to HubSpot?
Through the Tai customer code stored on the HubSpot company. 69 October loads have no HubSpot match and are left out of the industry and region shares.
Do I need a TMS connector?
No. Upload the Tai load export as a file. Upload next month's over the old one and every view rebuilds. HubSpot connects directly and syncs on a schedule.
Does Querri change anything in HubSpot?
No. It reads a copy of the data and never writes back.
How often should this run?
Monthly, before sales planning, on a schedule. A lane that starts slipping shows up in the month it slips.