For independent metals service centers · US & CanadaCarbon · Stainless · Aluminum · Alloy · Red metals
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.