Weekly Pipeline Digest
What it does
A read-only Monday-morning digest of the open pipeline: totals, movement, stalls, and a short "push list" — so the user is caught up before the team standup.
When to use
- A scheduled weekly run, or on request: "give me the pipeline digest", "what moved in pipeline this week".
Inputs
None required. Optionally a pipeline name, owner, or segment to scope it.
Workflow
- Snapshot now. Search open deals; capture totals (count, value), per-stage counts/value, and each deal's stage + days-in-stage.
- Compare to last week. Retrieve the prior weekly snapshot if one exists; compute deltas (pipeline value, new deals, deals advanced, deals slipped). On the first run, state there's no prior baseline and skip deltas.
- Flag stalls. Mark deals stuck 14+ days in stage with an SLA cue.
- Build the push list. Pick the top 3 deals to act on this week (closest to close, highest value, or most at-risk) with a one-line reason each.
- Write the digest using the template. Keep it skimmable.
- Persist the snapshot for next week's comparison (store the compact totals + per-stage map only).
Output
Notes
- Read-only by design: it reports, it doesn't change deals.
- Reliable across the 80% case because it works on aggregate + stage data, not fragile per-field parsing.