Audit intermediate Works with: Any AI

Salesforce Pipeline Hygiene Audit From an Export

Table output Has example

• ☁️ Salesforce

Find stale, inflated and unreliable opportunities.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Audit our pipeline using this Salesforce export: opportunity, owner, stage, amount, close date, created date, last activity date, next step and last stage change: [PIPELINE_EXPORT]. Today's date: [TODAY]. Our rules for stages and activity: [RULES]. Inactive days limit: [DAYS]. Target and coverage rule of thumb: [COVERAGE_RULE].

Calculate the number and value of open opportunities, those with close dates in the past, no activity for the limit, no next step, no amount, and in the same stage for more than twice the typical time, with arithmetic and the share of total value. Compute pipeline coverage (open pipeline divided by target) and compare with our rule. Example (invented export of 180 open opportunities worth 2.4 million): close date in the past 27 (15 percent), value 410,000. Give a cleaned pipeline estimate with and without questionable deals, showing both sums. State the sample size and mark assumed field names [VERIFY].

Return a table by owner and by issue, a clean-up list for managers, and questions for each owner. Do not assume bad faith; most gaps come from habit and unclear rules. Separate facts from suggestions, and suggest 15-minute weekly hygiene routines.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Invented export of 180 open opportunities worth 2.4 million. Close date in the past: 27 (15 percent), value 410,000. No activity for 14 days: 41 (22.8 percent). No next step: 38. No amount: 6. Pipeline coverage: open pipeline 2.4 million against a remaining target of 900,000 is 2.7 times; excluding questionable deals (27 + 41 minus 12 overlapping = 56 deals worth 780,000) coverage is (2,400,000 - 780,000) / 900,000 = 1.8 times. Clean-up list is sent to each owner.

• salesforce