RevOps & CRMadvancedPro

Investigate Salesforce stage aging and forecast hygiene with Claude

Reconstruct opportunity movement, stage age, forecast-category alignment, close-date drift, activity gaps, and next-step quality to produce a defensible forecast cleanup queue.

What you will have

An opportunity-level forecast hygiene register, stage-aging analysis, manager review pack, and recurring inspection runbook.

Setup time

5-8 hours

Time saved

6-10 hours per forecast review

Estimated cost

$20 to $200 per month

Tools used

2 tools

Why this works

A forecast can look healthy while individual opportunities have stale stages, expired close dates, weak activity, or inconsistent forecast categories. Salesforce provides the Opportunity Stage, Forecast Category, Probability, Close Date, Opportunity History, and activity evidence needed to separate genuine progression from administrative optimism. Claude can apply stage-specific thresholds and explain each flag, but it must not infer deal intent from absence alone. The approval gate keeps managers responsible for forecast changes and preserves seller context.

Step-by-step workflow

Preview the workflow

The first 2 steps are open. Pro unlocks the remaining steps, copy-paste prompts, pro tips, tool-by-tool setup guidance, and implementation details.

Define stage-age and forecast policies

30-60 min

Write the allowed age by opportunity stage, valid forecast categories per stage, close-date movement limits, next-step freshness rule, and approved exceptions for procurement or legal holds. Work from Salesforce using opportunity ID, account ID, owner, stage as the minimum evidence set. Complete this work in Salesforce or the controlled working file; no Claude prompt is needed for this step. Save the finished artifact in the forecast hygiene exception ledger with the run date, owner, evidence reference, confidence, and approval status. Treat contracting delays as a separate exception class and do not count it as failure unless the policy says so.

Output

Define stage-age and forecast policies completed as a dated section of the forecast hygiene exception ledger, with opportunity ID, median days in stage, evidence links, owner, and approval status for update stage.

Salesforce

Pro tip

Do not let opportunity ID stand in for account ID; that shortcut creates false positives in stage aging and forecast hygiene. Document the result in the same run folder so the next cycle can compare like with like. Apply it specifically during “Define stage-age and forecast policies.”

Build opportunity history reports

30-60 min

Create reports for open opportunities, Opportunity History, field history, activities, stage entered date, close-date changes, amount changes, and forecast category. Confirm timezone and fiscal-period behavior. Capture owner, stage, stage entered date, amount in a dated working table before interpreting the result. Complete this work in Salesforce or the controlled working file; no Claude prompt is needed for this step. Save the finished artifact in the forecast hygiene exception ledger with the run date, owner, evidence reference, confidence, and approval status. Quality-check the result against close date moved more than twice, then route any contradiction to the named data owner.

Output

Build opportunity history reports completed as a dated section of the forecast hygiene exception ledger, with account ID, opportunities beyond threshold, evidence links, owner, and approval status for reset close date with evidence.

Salesforce

Pro tip

Keep procurement holds visible as its own class because merging it into the main failure rate will distort the decision. Document the result in the same run folder so the next cycle can compare like with like. Apply it specifically during “Build opportunity history reports.”

Pro workflow preview

Previewing 2 of 12 steps

Pro membership

Unlock the full workflow

Get the remaining 10 steps, copy-paste prompts, pro tips, tool-by-tool setup guidance, and weekly new workflows.

$9/month

Reconstruct each opportunity timeline

Calculate stage-age and push indicators

Test forecast-hygiene rules

Separate seller behavior from process defects

Validate high-value and low-confidence deals

Quantify pipeline at risk

See Pro plan

3Reconstruct each opportunity timeline

Locked

4Calculate stage-age and push indicators

Locked

5Test forecast-hygiene rules

Locked

6Separate seller behavior from process defects

Locked

7Validate high-value and low-confidence deals

Locked

8Quantify pipeline at risk

Locked

9Create the manager inspection queue

Locked

10Run the forecast-call approval gate

Locked

11Apply small reversible corrections

Locked

12Package the weekly forecast-hygiene Skill

Locked

Expected results

Records or configurations reviewed

100% of the approved in-scope population

The run reconciles every eligible record or configuration item to the signed source manifest rather than relying on an informal sample.

Evidence validation

Stratified QA before action

Every major finding class and high-impact segment is checked against source records before operational changes are approved.

Decision output

One owner-ready action register

Findings are converted into deduplicated actions with evidence, confidence, owners, approvers, deadlines, and rollback requirements.

Operational reuse

Versioned recurring runbook and Claude Skill

The same inputs, rules, prompts, schemas, validation gates, and metrics can be rerun while preserving a visible change history.

Related workflows

Continue with workflows that share a similar GTM motion, category, or tool stack.

ABMpro

Create a Salesforce account engagement-to-pipeline brief with Claude

A reusable account brief that connects marketing engagement to sales context without overstating causality.

ClaudeSalesforce

4-6 hoursView workflow ->

Sales Enablementpro

Detect Salesforce Opportunity Contact Role gaps with Claude

A buying-group gap register, role-confidence assessment, and seller task queue tied to the current opportunity stage.

ClaudeSalesforce

4-7 hoursView workflow ->

Sales Enablementpro

Build a HubSpot pipeline quality and deal-risk agent with Claude

An evidence-linked deal-risk register, prioritized seller action queue, and reusable weekly Claude Skill for pipeline inspection.

ClaudeHubSpot

5-8 hoursView workflow ->