Analysis and Reporting

Weekly Lane Performance Summary

An AI prompt that turns a week of lane data into a short summary: volume, margin and on-time by lane, with what changed and why.

3 fields to fill · Updated October 2026

The prompt 3 fields

You are an analyst writing a weekly lane review for [audience]. Here is this week’s data by lane, with last week for comparison: [paste lanes with loads, revenue, cost, margin and on-time percentage]. Write a summary with: the three lanes that changed most and the likely reason, any lane below [margin or on-time target], and one recommended action per problem lane. Start with a three-sentence overview. Use a short table, plain language, and no more than 250 words.

From a spreadsheet to a review people read.

What you fill in

Audience: Ops and sales leads
Lanes: 12 lanes, this week vs last
Targets: 15% margin, 95% on-time
Notable: Fuel up 6 cents

What comes back

Overview: Volume rose 8% to 214 loads. Margin slipped from 17.1% to 15.9%, mostly on two southeast lanes. On-time held at 96%.

What changed

Atlanta to Charlotte: margin fell from 18% to 11%. Three spot loads booked at a loss to cover a gap.
Dallas to Houston: volume up 40% after a new shipper started. On-time steady.
Memphis to Nashville: on-time dropped to 88%. Two late pickups at the same shipper.

Actions

Atlanta to Charlotte: line up one more contract carrier before next week.
Memphis to Nashville: call the shipper about dock delays this week.

Lane reviews, written. Every Monday.

Vic pulls the week’s numbers, compares them to last week, and drafts the review for your approval.

Try Vic→ Get a Demo→

ANALYSIS · WEEK 42

Data pulled214 loads across 12 lanes

Changes found3 lanes moved most

Lane review ready for review

Four ways to make the numbers useful.

Always compare.One week alone says little. Paste last week or a four-week average.

Set targets in the prompt.The AI flags misses only if it knows the bar.

Ask for causes, then check them.Treat the reasons as leads to confirm, not facts.

Cap the length.A review over one page does not get read.

Questions

FAQs

What should a weekly lane report include?

Volume, revenue, cost, margin and on-time by lane, compared with the prior period, plus the biggest changes and the actions you will take.

How should I format the data?

A simple table with one row per lane works best. Copying straight from a spreadsheet is fine.

Can the AI explain why a lane changed?

It can suggest likely reasons from the data you give it. Confirm them with the people closest to the lane.

Which AI tools does this prompt work in?

Any AI chat tool. Paste it, fill the fields, and review the draft before sending. In Vic, the facts fill in for you.

Keep going

Related prompts

Report