Before an AI agent automates your sales process, mine how it really runs: Salesforce OpportunityHistory and pandas

Every few years a new technology arrives promising to fix how companies work: ERP, then CRM, then the cloud, now AI agents. And in many mid-sized companies the same things keep happening. A manager asks for the numbers in Excel because he does not trust the system. Sales reps keep their own notes. Three reports give three totals. An approval that was supposedly automated ends up in a WhatsApp message.

An AI agent follows the process you give it. The risk is that you give it the documented process, while the company runs a different one. This post shows a cheap way to see the process as it actually runs, using data Salesforce already keeps, before you automate anything.

The data you already have

For opportunities, Salesforce writes a row to OpportunityHistory every time the stage, amount or close date changes. No setup needed:

SELECT OpportunityId, StageName, Amount, CloseDate, CreatedDate, CreatedById FROM OpportunityHistory WHERE CreatedDate = LAST_N_DAYS:180 ORDER BY OpportunityId, CreatedDate 

Export it to CSV (Data Loader, a report or the CLI). That is an event log: case id, activity, timestamp, resource. It is the minimum input for basic process mining.

Step 1: build the variants

import pandas as pd log = pd.read_csv("opportunity_history.csv", parse_dates=["CreatedDate"]) log = log.sort_values(["OpportunityId", "CreatedDate"]) # keep only real stage changes (amount or date edits also create rows) prev = log.groupby("OpportunityId")["StageName"].shift() log = log[log["StageName"] != prev] variants = log.groupby("OpportunityId")["StageName"].agg(" > ".join) print(variants.value_counts().head(10)) 

The documented process is usually one line. The output is usually many. Look at the top ten and ask which one the AI agent would be told to follow.

Step 2: find rework and skipped steps

paths = log.groupby("OpportunityId")["StageName"].apply(list) went_back = paths.apply(lambda s: len(s) != len(set(s))) jumped = paths.apply(lambda s: len(s) <= 2) print(f"went back to an earlier stage: {went_back.mean():.0%}") print(f"two steps or fewer from creation to last stage: {jumped.mean():.0%}") 

An opportunity that goes from the first stage straight to Closed Won was probably worked somewhere else and updated at the end. That is the CRM nobody fills in, measured.

Step 3: find where work waits

log["next_stage"] = log.groupby("OpportunityId")["StageName"].shift(-1) log["next_at"] = log.groupby("OpportunityId")["CreatedDate"].shift(-1) log["wait_days"] = (log["next_at"] - log["CreatedDate"]).dt.total_seconds() / 86400 waits = (log.dropna(subset=["next_stage"]) .groupby(["StageName", "next_stage"])["wait_days"] .agg(["count", "median"]) .sort_values("median", ascending=False)) print(waits.head(10)) 

Long waits between two stages are often a handoff between areas, or an approval that happens outside the system.

Step 4: find who moves the work

movers = log.groupby("CreatedById").size().sort_values(ascending=False) print(movers.head()) 

If one or two users move most of the stages for a team of reps, someone is collecting updates from a spreadsheet or a chat and typing them in. Ask them how the information reaches them.

What to do with this before the agent

The numbers do not tell you why. They tell you who to talk to and which questions are still open in the organization:

If you automate before answering these, the agent will do the same things faster, including the wrong ones.

When the ERP is native to the same Salesforce org, as with EGA Futura ERP, the same approach extends to orders, invoices and payments, because the history lives in one database. That makes the log longer. It does not answer the questions for you.

I wrote the business side of this, in Spanish, as why we still ask for the numbers in Excel with CRM, ERP and AI.

Juan Manuel Garrido, founder of EGA Futura.