How to Forecast Revenue for a Booked-Call Funnel

If you sell on calls, you can forecast revenue for a booked-call funnel far more accurately than most businesses can forecast anything. The funnel is short, the stages are countable, and the conversion rates between them are fairly stable week to week. Yet most coaching and consulting businesses forecast by looking at last month’s revenue and adding a hopeful percentage.

A good call-funnel forecast answers two questions: how much revenue is already likely from calls on the calendar and deals in progress, and how much will the next month of ad spend produce, and when will that cash arrive. The second part, timing, is the one most forecasts skip, and it’s the reason so many of them are right about the total and wrong about the month.

The core formula

At its simplest, revenue from a booked-call funnel is:

Booked calls × show rate × close rate × average cash collected per close

Say you book 200 calls next month, 70 percent show, you close 22 percent of shows, and each close collects $4,500 in the first 30 days. That’s 200 × 0.70 × 0.22 × $4,500 = $138,600.

Each of those four inputs hides decisions, so let’s take them one at a time.

Getting the inputs right

Booked calls

Count unique people with a scheduled sales call, not calendar events. Reschedules and duplicate bookings inflate the number. If you run setter calls before closer calls, forecast them as separate stages, because they have separate show and conversion rates.

To project bookings forward, work from spend: cost per booked call by channel, times planned budget. Use a trailing 4 to 8 week average rather than last week’s number, which bounces around.

Show rate

Show rate is shows divided by calls that were scheduled to happen in the period. Two definition traps:

• Rescheduled calls. Decide whether a reschedule counts as a no-show and a new booking, or neither. Either is fine; be consistent.
• Calls that weren’t sales calls. If onboarding or support calls land in the same calendar, strip them out or your show rate will look artificially high.

How shows are recorded matters too. If your no-show data relies on reps updating a field, it will be patchy. Automated detection is more reliable. In Callix, a recorded call with no conversation isn’t marked a no-show on that alone; it checks who joined the meeting, so the rep alone is a No Show and the prospect joining counts as a show even if nothing was recorded.

Close rate

Close rate on shows, not on bookings. Keep the two separate so you can tell whether a bad month was a show-rate problem (pre-call nurture, lead quality) or a close-rate problem (sales execution, offer fit).

If you close on multiple calls, be explicit about whether close rate means “closed on the first call” or “closed eventually.” For forecasting, “closed eventually, within N days” is the right number, paired with timing data.

Cash per close

This is where high-ticket forecasts most often go wrong. A $12,000 program sold on a six-month payment plan collects $2,000 in month one. If you forecast with the sticker price, you’ll be right about bookings and wildly wrong about cash.

Model it explicitly: what share of closes pay in full, what share are on plans, and what’s the typical first payment. Also apply a refund or default rate based on your history.

Timing: the part most forecasts skip

A call booked on the 28th of the month shows on the 3rd of the next month, closes on a follow-up the 10th and pays the first installment on the 12th. A forecast that assigns that revenue to the month it was booked will be off every time.

You need the typical lag between each stage:

Stage transition	Median lag (example)
Ad click to booked call	2 days
Booked call to held call	4 days
Held call to close	6 days
Close to first payment	1 day

With those lags, a lead coming in during the last week of the month mostly converts next month. For a growing ad budget that’s a meaningful shift, and it’s why months with rising spend often look like they have worse ROAS than they really do.

Medians are usually more useful than averages here, because a handful of prospects who take three months to close will drag an average far from the typical case. Track both if you can.

If you’re using Callix, Time Between Events measures exactly this: how long leads take to get from one event to the next, like Booked Call to Closed, as a median or an average. You set them up under Settings → Knowledge Base → Time Between Events and add them to any metric card, report or table, so lag can be broken out by campaign or rep instead of being one blended number.

A worked example

Here’s an illustrative forecast for November for a coaching business with a $9,000 program.

Already on the books on November 1:

• 60 sales calls scheduled for November 1 to 7
• 25 prospects in follow-up after a first call, historically 30 percent close within 14 days

Planned new activity:

• $40,000 Meta budget at a trailing cost per booked call of $210, so about 190 new booked calls
• About 80 percent of those calls happen in November, given the 4-day booking-to-call lag; the rest slip into December

Rates (trailing 8 weeks):

• Show rate 68 percent
• Close rate on shows 20 percent
• 40 percent pay in full ($9,000), 60 percent on a plan ($1,500 first payment, then $1,500 a month)
• Refund rate 5 percent

Calculation:

Source	Held calls	Expected closes in November
Already scheduled	60 × 0.68 = 41	8.2
Follow-ups in progress	already held	7.5
New bookings held in November	152 × 0.68 = 103	20.7, minus about 4 that close in December
Total		about 32

Cash per close: 0.4 × $9,000 + 0.6 × $1,500 = $4,500. After a 5 percent refund rate: about $4,275.

New-close cash: 32 × $4,275 = about $137,000. Add installments from existing payment plans (pull this straight from your processor, say $48,000), and November’s forecast is roughly $185,000.

Then build a range. Run the same math with show and close rates one standard deviation below and above your trailing average. A forecast of “$160,000 to $205,000, most likely $185,000” is more honest and more useful than a single number.

Where forecasts break

Lead quality shifts. A new campaign or creative angle can bring a flood of bookings that show and close at half your historical rate. Forecast new campaigns at a discount until you have four weeks of data.

Rep capacity. Close rates drop when closers are overbooked. If your forecast assumes 250 held calls and you have two closers who can comfortably run 80 each, the math is wrong before it starts.

Seasonality. December and summer months often see lower show rates in many niches. Look at the same month last year.

Definition drift. If someone changes what counts as a qualified call or a no-show mid-quarter, your trailing rates stop meaning what they used to. Write definitions down. The guide on setting up lifecycle stages in your CRM is useful here.

Attribution gaps. If 20 percent of payments can’t be matched to a lead, your cash per close and close rate will both be understated. Fix matching before tuning the forecast.

Forecasting by campaign and rep

Once the overall forecast is working, break it down. The same formula applied per campaign tells you which channels are carrying next month. Applied per rep, it shows whether a capacity or performance issue is coming.

This is also where forecasting ties back into budget decisions. If campaign A books calls at $180 that close at 25 percent, and campaign B books at $140 that close at 12 percent, B’s cheaper bookings produce a worse forecast per dollar. Our post on forecasting pipeline from marketing-sourced leads covers the longer-cycle B2B version, and tying ad spend to closed-won revenue explains the plumbing needed to get campaign-level close rates.

Working backward from a revenue target

Forecasting also runs in reverse, and the reverse version is often more useful for planning. Start with the revenue you need and work back to the budget and calendar it requires.

Say you want $250,000 in new-client cash next month. At $4,275 per close, that’s about 59 closes. At a 20 percent close rate, you need about 293 held calls. At a 68 percent show rate, about 431 booked calls. At $210 per booked call, about $90,000 in ad spend, and enough closer capacity to run nearly 300 calls.

That last line is where reverse forecasts earn their keep. If you have two closers, the target isn’t a marketing problem; it’s a hiring problem. If cost per booked call rises as you scale spend, which it usually does, the budget needed is higher than the linear math suggests. Running the numbers backward surfaces those constraints before you commit to the target.

Keeping it updated

A forecast is only useful if it’s reviewed. A simple weekly rhythm:

1. Update trailing rates (show, close, cash per close, lags) every Monday.
2. Compare last week’s actual held calls and closes against forecast.
3. Investigate any stage that missed by more than 15 percent; that’s where the problem is.
4. Roll the forecast forward with the latest bookings and planned spend.

After two or three months, you’ll know your funnel’s rhythm well enough that the forecast stops being a guess and starts being a planning tool, one that tells you in week one whether the month is on track, while there’s still time to do something about it.