Invoice Cycle Time
Invoice Cycle Time: Time from billing event to invoice delivery.
Formula
Invoice Cycle Time = Median of (Invoice sent - Billing trigger 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.invoice_date - field.billing_trigger_date where in_period(field.invoice_date))Unit: days
Notes: Calendar days, as revops.md states. A business-day count differs when the interval spans weekends or holidays.
Data requirements
Grain: Per event · Frequency: Per transaction · Aggregation: event · Staged: no · Main source: Billing.
| Field | Dataset | Type |
|---|---|---|
billing_trigger_date | invoice | date |
invoice_date | invoice | date |
snapshot_date | invoice | date |
Example SQL (Postgres)
SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (invoice_date - billing_trigger_date)) FROM invoice WHERE snapshot_date = :period_end AND (invoice_date >= :period_start AND invoice_date <= :period_end)) AS invoice_cycle_time From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Invoice Cycle Time" }) or generate_query({ "metric": "Invoice Cycle Time", "adapter": "<your adapter JSON>" }).