File format
Quote history upload format
One CSV (or XLSX saved as CSV), one row per quote line, covering the last 6–12 months. Most service-center ERPs (Stratix, INVEX, Eniteo, P.S. Data, Epicor) can export this from a quote register or quote-to-order report. Column names are matched case-insensitively and a few common aliases are accepted (listed in brackets).
Required columns
| Column | Type | Example | Notes |
|---|---|---|---|
quote_id [quote_no, quote_number] |
text | Q-104233 | |
quote_date [date, created_at] |
date | 2026-03-14 | Any common date format |
customer_id [customer, cust_no] |
text | C-0412 | Can be hashed/anonymized |
metal [metal_family, commodity] |
text | carbon / stainless / aluminum | Free text is normalized |
form [product_form, shape] |
text | sheet, plate, bar, tube, beam | |
weight_lbs [weight, line_weight] |
number | 4,820 | Total weight of the line |
unit_price [price] |
number | 61.50 | |
price_uom [uom] |
text | cwt / lb / ton / ft / ea | Converted to $/cwt using weight |
outcome [status, result] |
text | won / lost / open / expired | "ordered", "converted" → won; "dead", "declined" → lost |
Strongly recommended (each unlocks a section of the report)
| Column | Unlocks |
|---|---|
unit_cost [cost, book_cost, avg_cost] (same UOM as price) |
Needed for the margin analysis. Lines without cost are left out of it. |
quantity [qty] + product_code [item, part_no] + grade + description |
Same-product price dispersion |
salesperson [rep, sales_rep] |
Rep-level discount patterns |
branch [location, warehouse] |
Branch comparisons |
request_received_at and quote_sent_at (timestamps) |
Speed-to-quote vs. win rate |
processing_charge, freight_charge |
Separates material margin from services |
lost_reason, competitor_price |
Calibrates the win curve |
Optional
replacement_cost per line, if your ERP tracks it. If absent, the report uses a public
market index by metal and month to estimate replacement cost and flag quotes priced off stale
book cost.
What we do with it
The file is processed to produce the Margin Leak Report and is not used for anything else. Customer IDs and rep names can be anonymized before upload; the analysis does not need real names.