The weekly pipeline delta.
What changed in the pipeline since last week, in one table.
Compare my open pipeline in [CRM] today with its state on [date of the last review]. List every deal that was added, closed won, closed lost, changed stage, changed amount by more than [10]%, or moved its close date. For each, show the owner, the value before and after, and the field that changed. Start with the three changes that move this quarter’s forecast the most.
- You need
- CRM
- You get
- A change table sorted by how much each change moves the forecast.
- Watch for
- If your CRM does not keep a history of amount and close-date changes, the prompt can only see today’s values. Turn field history on first.