Monday pipeline brief
1. The numbers
Section titled “1. The numbers”{ "tool": "pipeline_metrics" }Open deals, open and weighted amounts and MRR per currency, won this month, and stale contacts.
2. Deals closing in the next 14 days
Section titled “2. Deals closing in the next 14 days”{ "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"] }3. Won and lost last week
Section titled “3. Won and lost last week”{ "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.
4. The action list
Section titled “4. The action list”- Not contacted in 48 hours: who to call.
- Stuck deals: what to unblock.
Reporting rule
Section titled “Reporting rule”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 €.