Audit Pipeline
Identify and report pipeline hygiene issues to improve stage accuracy and forecast reliability.
Inputs
- Pipeline — CRM pipeline ID or name to audit (e.g., "Sales Pipeline", "Enterprise")
- Scope — Date range or team filter for the audit; default is last 90 days
- Stage filter — Specific stages to check (optional); default audits all stages
- Check severity — Audit rule sensitivity: basic, standard, or comprehensive; default is standard
- Report format — Output style: summary, detailed, or action-items; default is summary
Steps
- List all deals in {Pipeline} within {Scope} and group by stage.
- Run standard hygiene checks: missing fields, stale updates, incorrect stage progression, owner assignment gaps.
- Flag deals with no activity in {days}, mismatched close dates, or age beyond stage SLA.
- Count deals per stage and calculate average stage duration against benchmarks.
- Identify orphaned or hung deals (no forward movement for {threshold}).
- Compile findings by severity (critical, warning, note) and stage.
- Generate {Report format} output with summary metrics, top issues, and recommended actions.
Constraints
- Audit only {Pipeline}; do not modify deal data or assignments.
- Report only findings; do not auto-reassign or auto-close deals.
- Scope limited to deals with activity or creation within {Scope} window.
Done when: Pipeline health report identifies all stale deals, missing data, and stage progression issues, ranked by impact.