Sales Forecasting Agent
Forecasts revenue from pipeline stage and velocity.
- Industry
- Retail
- Department
- Sales
- Team
- Deal Conversion
- Kind
- Decision-maker
- Approver
- Head of B2B Sales
- Code
- SAL-17
It forecasts B2B revenue (corporate gifting, gift card, employee scheme and bulk orders, and marketplace commission) for the period from each open deal's stage, age and velocity against historical win rates, with the year-end gifting peak weighted by last year's pattern. It sets the commit, best case and pipeline numbers with the deals behind each, compares its call with the reps' submitted commit and target, flags slipping deals and submits the forecast.
How it works
7 steps, and a person signs off before step 7.
- 01Looks it up
Finds the record the request is about in the loyalty and CRM platform: open corporate deals with stage, value, dates and history, and the reps' submitted commits..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Forecasts, when it decides
Projects what each option will cost or return before it recommends one.
- 05Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 06Asks a person
Hands the work to Head of B2B Sales with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the loyalty and CRM platform: it submits the forecast for the period to the forecast module. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The forecasting method: stage probabilities, velocity by offer type, the seasonal pattern of corporate gifting, how gift card revenue is recognised on redemption rather than sale, and the forecast categories.
Reads from
the loyalty and CRM platform: open corporate deals with stage, value, dates and history, and the reps' submitted commits.
Acts in
the loyalty and CRM platform: it submits the forecast for the period to the forecast module.
Hands back
An object with commit, best_case, pipeline, target, rep_commit, variance_percent, deals (a list, each with deal_id, category commit, best_case or pipeline, weighted_value and slip_days) and gift_card_bookings (an object with bookings and expected_redemption_revenue).
Asks a person when
The forecast differs from the reps' commit by more than 10 percent, or it is below target.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Stage probabilities (%) | Discovery 10, Qualification 20, Proposal 40, Negotiation 70, Commit 90 | Probability by stage. |
| Commit at probability (%) | 70 | Deals at or above this go into commit. |
| Velocity look-back (days) | 365 | History used for velocity, a full year to capture the gifting season. |
| Flag slips over (days) | 14 | Deals forecast to close this much later than stated are flagged. |
| Variance to explain (%) | 10 | A gap this large between our call and the reps' commit is explained. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Weight each deal by Discovery 10, Qualification 20, Proposal 40, Negotiation 70, Commit 90, adjusted for its age against velocity over 365 days.
- Commit only deals at 70 percent or more; a gifting deal whose delivery date is after the period's end is not commit.
- Show gift card sales as bookings and separate the revenue expected on redemption.
- Flag deals forecast to slip more than 14 days.
- Explain any gap over 10 percent between our call and the reps' commit; submitting a call below target goes to the Head of B2B Sales.
See the Sales Forecasting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.