Skip to content

Monday pipeline brief

{ "tool": "pipeline_metrics" }

Open deals, open and weighted amounts and MRR per currency, won this month, and stale contacts.

{ "tool": "query_records", "type": "deal",
"filters": [{ "field": "stage.outcome", "op": "eq", "value": "open" },
{ "field": "expectedCloseOn", "op": "lte", "value": "today+14d" }],
"sort": "expectedCloseOn:asc",
"fields": ["name", "stage", "expectedCloseOn", "amountCents", "currency", "organizations"] }
{ "tool": "query_records", "type": "deal",
"filters": [{ "field": "closedAt", "op": "gte", "value": "today-7d" }],
"sort": "closedAt:desc",
"fields": ["name", "stage", "closedAt", "lostReason", "amountCents", "currency"] }

stage.outcome (in stage) tells won from lost.

Report amounts per currency, never summed across currencies, and say which pipeline each figure belongs to. Amounts are minor units: 480000 EUR is 4 800,00 €.