Quote Cycle Time
Quote Cycle Time: Time from quote request to quote delivery.
Formula
Quote Cycle Time = Median of (Quote sent date - Quote requested date)Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
(median(field.quote_sent_at - field.quote_requested_at where in_period(field.quote_sent_at))) * 24Unit: hours
Data requirements
Grain: Per event · Frequency: Per transaction · Aggregation: event · Staged: no · Main source: CRM.
| Field | Dataset | Type |
|---|---|---|
quote_requested_at | quote | timestamp |
quote_sent_at | quote | timestamp |
snapshot_date | quote | date |
Example SQL (Postgres)
SELECT ((SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (EXTRACT(EPOCH FROM (quote_sent_at - quote_requested_at)) / 86400.0)) FROM quote WHERE snapshot_date = :period_end AND (quote_sent_at >= :period_start AND quote_sent_at < (:period_end + INTERVAL '1 day'))) * 24) AS quote_cycle_time From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Quote Cycle Time" }) or generate_query({ "metric": "Quote Cycle Time", "adapter": "<your adapter JSON>" }).
What It Tells You
Speed of quote generation process.