Quote Volume
Quote Volume: Number of quotes sent in a period.
Formula
Quote Volume = Count of quotes createdComputable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
count_distinct(field.quote_id where in_period(field.quote_sent_at))Unit: count
Data requirements
Grain: Per event · Frequency: Per transaction · Aggregation: event · Staged: no · Main source: CRM.
| Field | Dataset | Type |
|---|---|---|
quote_id | quote | string |
quote_sent_at | quote | timestamp |
snapshot_date | quote | date |
Example SQL (Postgres)
SELECT (SELECT COUNT(DISTINCT quote_id) FROM quote WHERE snapshot_date = :period_end AND (quote_sent_at >= :period_start AND quote_sent_at < (:period_end + INTERVAL '1 day'))) AS quote_volume From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Quote Volume" }) or generate_query({ "metric": "Quote Volume", "adapter": "<your adapter JSON>" }).