Skip to content

Which shippers are tendering fewer loads than usual?

Join your Tai load export to HubSpot and your tender allocations. See which shippers sent fewer loads than their usual week, who is behind their quarter, and who hasn't heard from you.

Open Querri

What you'll need

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

A Tai load export, HubSpot and your allocation sheet: Step 1 says what each adds

Your volume rules: so every shipper is judged 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

A shipper rarely says it's moving freight elsewhere. It just sends fewer loads, and a busy week across the rest of the book hides it. The loads are in the TMS, the allocations are in a spreadsheet and the last call is in the CRM, so spotting a quiet shipper has depended on an account manager noticing.

This playbook compares every regular shipper's week with its own usual week, checks contract shippers against their quarterly allocation, and shows when each one last heard from Brinlow.

How it works:

  • • Upload the Tai export and connect HubSpot
  • • Compare each shipper's week with its usual
  • • Check contract shippers against allocation
  • • See which quiet shippers nobody called
  • • Build Monday's call list

Follow the steps

Open Querri →
1 Step 1:

Upload the Tai export and connect HubSpot

Three sources, one project:

  • •

    Tai load export (or your TMS load report): every load with its shipper, customer code and pickup appointment.

  • •

    Tender allocation (Excel): each contract shipper's committed loads for the quarter.

  • •

    HubSpot: each shipper's account manager, and every call, email and meeting.

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

Tip: Pull at least 14 weeks of loads, so every shipper has 13 weeks to set its usual week.

  • Tai load export
  • Tender allocation
  • HubSpot companies and activities
Querri One project
2 Step 2:

Compare each shipper's week with its usual weeks

Hold every regular shipper against its own last 13 weeks:

Prompt

"Compare each shipper's loads last week with its average over the 13 weeks before. Which shippers that usually send 3 or more a week are under 70% of their usual?"

The company is 2.6% under its usual week, well within normal. Underneath, 15 of the 54 shippers that usually send 3 or more loads a week are under 70% of their usual. Druvall Paper sent 9 against a usual 22.

Compare each shipper's week with its usual weeks
ShipperThis weekUsual weekShare of usual
Druvall Paper922.041%
Aldermoor Beverage1020.250%
Falwick Provisions1121.850%
Wickvale Dairy815.053%
Company673690.997%

Loads in the week of October 26, 2026, against each shipper's usual week.

3 Step 3:

Check contract shippers against their quarterly allocation

For shippers with a committed volume, measure the quarter so far:

Prompt

"For contract shippers, how far along are they on their Q4 tender allocation, 32 days into the quarter?"

32 days in, 20 of 62 contract shippers are under 90% of the pace their allocation implies. Tamley Polymers has sent 5 loads against 12.5 expected.

Check contract shippers against their quarterly allocation
ShipperQ4 allocationLoads to datePace
Tamley Polymers36539.9%
Yarvale Supply43960.2%
Ellshaw Coatings39966.3%
Nashlow Supply39966.3%

Q4 2026 pace for contract shippers, November 1 (32 of 92 days).

4 Step 4:

See which quiet shippers nobody has called

Bring in HubSpot, and look at the last contact for each down shipper:

Prompt

"For each shipper that's down, when did anyone last call, email or meet with them in HubSpot?"

Most down shippers heard from Brinlow in the last few days; the median gap is 2 days. Druvall Paper hasn't been contacted since October 7, 26 days.

See which quiet shippers nobody has called
ShipperAccount managerLast contactDays
Druvall PaperMaya LindenOctober 726
Grantdale StoresBrooke HollowayOctober 258
Quinvale PaperElena KowalOctober 276
Aldermoor BeverageMaya LindenNovember 11

Last HubSpot contact for shippers down this week, as of November 2, 2026.

5 Step 5:

Build Monday's call list by account manager

Four numbers for Monday, and the calls to make first.

The narrative Querri writes:

The week looks normal in total, but 15 regular shippers sent far less than usual, and one of them has gone almost four weeks without a call.

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 Monday's call list by account manager
ShipperThis week (usual)Last contact
Druvall Paper9 (22.0)26 days
Aldermoor Beverage10 (20.2)1 day
Falwick Provisions11 (21.8)1 day
Stanwood Farms11 (20.3)1 day

Monday's call list, week of November 2, 2026.

Call the shipper that went quiet this week, not next quarter.

Try it on your own data
Querri for logistics account management See how Querri helps account managers see every shipper's volume, service and margin, from every system, in one place. See Querri for account management

See Querri for the whole brokerage

Tips for catching a quiet shipper early

Measure each shipper against its own week

A company total down 2.6% says nothing. A shipper at 41% of its usual week says a lot, and it's visible the week it happens.

Put the last call next to the drop

A shipper that's down and was called yesterday is in hand. One that's down and hasn't heard from you in weeks is the first call.

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

What a usual week is, when a shipper counts as down, what pace means: 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 shipper is down when this week's loads are under 70% of its average over the prior 13 weeks, and it averages 3 or more a week. Save that as a rule for the Tai loads table."

Or bring the document that already says it

Upload your account management playbook 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:

  • Week: Monday to Sunday, by pickup appointment
  • Usual week: average of the prior 13 weeks, empty weeks as zero
  • Regular shipper: 3 or more loads a week on average
  • Down: under 70% of the usual week
  • Q4 pace: loads to date against allocation times days gone
  • Last contact: latest HubSpot call, email or meeting, any owner
Prompt

"Read our account management playbook and propose the rules it states about volume reviews, contact frequency and escalation. 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 any account manager
  • • 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 on Monday

Each account manager starts the week with the shippers that went quiet and when they were last called. Changing the 70% rule is a sentence.

Frequently asked questions

What is a shipper's usual week?
Its average loads a week over the 13 weeks before this one, counting weeks with no loads as zero. Change the window in one sentence.
Why only shippers with 3 or more loads a week?
A shipper that sends one load every other week can look down by chance. Three a week keeps the list to shippers where a drop means something.
What does under 70% mean?
This week's loads are less than 70% of the usual week. It's a starting threshold; set it tighter or looser in one sentence.
How is Q4 pace measured?
Loads so far this quarter against the allocation times the share of the quarter gone. On November 1 that's 32 of 92 days.
How are Tai shippers matched to HubSpot?
By company name for the last contact, and the account manager comes from the HubSpot company. Two down shippers have no allocation and are left out of the pace check.
Do I need a TMS connector?
No. Upload the Tai load export as a file. Upload next week'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 or logs an activity.
How often should this run?
Weekly, Monday morning, on a schedule. A shipper that goes quiet shows up the week after, not at the QBR.