Quotes · live · metalzone.curiopal.com/api
Quotes
asking…
Total Quotations
—
asking…
Total Quotation Value
—
asking…
Win Rate
—
no decided quote on the ledger
Avg. Response Time
—
no enquiry behind a quote: rfq holds no rows, so there is no received_at to measure a response from. The quote carries one date, its QUOTE_ISSUED event.
Conversion to Order
—
no imported sales order names its quote (the Sales sheet carries no quote id), so sales_order.quote_id is null on all of them and the conversion rate is 0 of the quotes won
QuoteIssuedCustomerMaterialOpportunityLinesQuantityValueValid untilStatusOwner
asking metalzone.curiopal.com/api for the quotes…
Value is Σ qty × price over the quote lines. The sheet names no decision date, so a won or lost quote's decision event carries its issue date and the report says so; an expired quote's carries valid_until. Opportunity and owner are NONE on every row: neither has a column on a quote. Open a row for the lines, the price stack and every sourcing option considered.
Quotation Funnel
quotes by status, in the schema's words, with the value behind each
no quote on the ledger
quote_status is draft, issued, revised, won, lost and expired. The board's Sent, Under Review and Approved are defined in neither the schema nor the workbook, so no bar is drawn under them.
Quotation Value by Material
quoted value per form, summed over the quote lines
asking the catalog…
qty x price on every quote line, grouped by specification.form · every form is aluminium, so the board's steel groups do not appear
Recent Activities
the quote events on the ledger, newest first
asking the ledger…