Most dashboards in steel service centers are built once, shown at a meeting, praised by the GM, and then ignored by everyone who was supposed to use them daily. The problem is not the technology. It is the design. Dashboards fail when they show too much, update too slowly, or measure things that do not connect to the decisions people make every day.
What the Sales Team Actually Needs to See
A sales rep starts the day with three questions: What do I need to follow up on? What is my number? Where is there opportunity? A useful dashboard answers all three on one screen, with data updated in real time.
Open quotes. Every quote that has been sent but not yet converted to an order, sorted by age. Quotes older than 5 days are going stale. The rep needs to follow up or close them out. The dashboard should show: customer name, quote amount, days since sent, and the likelihood of conversion (based on the customer's historical close rate).
Revenue and margin. Month-to-date revenue, margin percentage, and comparison to target. The rep should see their number at a glance: "$342,000 shipped this month, 21.8% margin, $158,000 to target." This creates daily accountability without waiting for the monthly report.
Top opportunities. The customers who have not ordered recently but historically order monthly. The open RFQs from new prospects. The quotes where the customer asked for a revision (high buying intent). These are the calls that generate revenue today.
What the Sales Manager Needs
The sales manager's dashboard adds team-level views. Rep performance comparison: revenue and margin by rep, quote volume, close rate, and average order value. This data fuels coaching conversations. "Your close rate is 28% this month versus your usual 35%. Let's look at the quotes you lost and figure out what changed."
Pipeline health: total open quote value, weighted by probability. A $2 million pipeline at 30% average probability produces an expected $600,000 in revenue. If the monthly target is $500,000, the pipeline is adequate. If it is $800,000, the team needs to generate more quotes.
Product mix: what categories are selling and which are slowing. If structural steel is up 20% and flat-rolled is down 10%, the sales manager adjusts focus and communicates with purchasing about inventory allocation.
Design Principles That Drive Adoption
One screen, no scrolling. If the rep has to scroll or click through tabs to find their numbers, they will stop checking. The most important metrics fit on a single screen. Everything else is secondary.
Real-time data. A dashboard that updates daily is a report. A dashboard that updates in real time is a tool. The rep who checks at 10 AM and sees that a $45,000 quote was just accepted knows to call the customer immediately and confirm delivery details. The rep who finds out tomorrow has lost a day.
Actionable, not informational. Every metric on the dashboard should suggest an action. Open quotes suggest follow-up calls. Revenue gap suggests prospecting. Low margin suggests pricing review. If a metric does not suggest an action, remove it.
Mobile accessible. The outside rep checks the dashboard from their car between customer visits. The dashboard must be readable on a phone screen. This means large numbers, clear labels, and no dense tables.
The Metric That Matters Most
If you can only show one metric on the sales dashboard, make it the quote-to-order conversion rate. This single number captures the effectiveness of the entire sales process: pricing competitiveness, follow-up discipline, customer targeting, and responsiveness.
A 30% conversion rate means you need to generate roughly $3.3 million in quotes to ship $1 million. A 40% conversion rate means $2.5 million in quotes for the same $1 million. That 10-point improvement in conversion rate is equivalent to adding a sales rep, without the salary.
The dashboard that gets used is the one that helps people do their jobs better. Build it around the decisions your team makes every day, keep it simple, keep it current, and it becomes the first thing they check every morning.