Manual tracking methods: create Outlook folders for quote requests, track timestamps in a spreadsheet, and compare request time to reply time per rep. This works for post-mortem analysis. It does not alert the team when a quote request sits unanswered.
Start with a simple folder structure. Create an Outlook folder called Quote Requests. When a quote request arrives, drag it into the folder. When you send the response, note the timestamp in a spreadsheet. Track the request time, the response time, and the rep who handled it. At the end of the week, calculate the average time-to-quote per rep.
Identify which metrics matter: time-to-quote per rep, time-to-quote per load type (urgent vs. planned), and coverage rate (how many quote-worthy requests got a response). Coverage rate is the metric most brokers miss. If the data shows 20% of quote-worthy requests never get a response, you know the problem is missed requests rather than pricing or speed.
The spreadsheet should track: request timestamp, shipper name, lane (origin to destination), load type (urgent or planned), rep assigned, response timestamp, and outcome (won, lost, no response). That structure lets you filter by rep, by load type, and by outcome. You can see which reps are fast and which are stuck. You can see which load types get quoted and which get ignored.
The measurement layer needs to work within the existing email workflow rather than requiring the team to log data in a separate system. Tracking lost bookings against response times reveals the cost of slow quoting. Compare win rates for quotes delivered in under 30 minutes versus those taking hours. That comparison tells you whether speed is the variable that matters for your book of business.
The manual method has limits. It requires discipline. Someone has to drag emails into folders and update the spreadsheet. The data is always a day behind. But it is better than no data at all. You need a baseline before you can justify a better system.