Skip to content
DoerbayBook a call

Growth AnalystKnow what works

Forecast revenue from open deals

Every week, the revenue your open deals should bring this quarter, worked out from how your past deals closed, and which deals carry it.

How it works

  1. Step 1 · Reads

    Reads your open deals

    Every open deal in your CRM with its stage, amount, age, expected close date and last call, email or meeting.

    Example
    Reads your open deals
    Every open deal in your CRM with its stage
    Amount
    Age
  2. Step 2 · Works it out

    Learns from your past deals

    From a year of closed deals: how often a deal still open at each age was won, and how long won deals took.

    Example
    Learns from your past deals
    How often a deal still open at each age was won
  3. Step 3 · Works it out

    Gives each deal its chance

    The win rate of past deals open as long as it has been, which falls the longer a deal sits; your CRM's stage probability beside it.

    Example
    Gives each deal its chance
    Which falls the longer a deal sitsYour CRM's stage probability beside it
  4. Step 4 · Works it out

    Adds up the quarter

    Everything open, the likely case, and the deals near certain to close.

    Example
    Adds up the quarter
    Everything openThe likely caseThe deals near certain to close
    Open and due this quarter: $412,000. Likely: $118,000. Near certain: $54,000 (3 deals in contract).
  5. Step 5 · Keeps watching

    Compares with last week

    What moved the forecast: deals won, lost, added, or slipping past the quarter.

    Example
    Compares with last week
    Week 1Checked: nothing new
    Week 2Checked: nothing new
    Week 3What moved the forecastNew
  6. Step 6 · Makes

    Writes the forecast

    The three numbers, the deals carrying most of it, and the stalled deals worth a call: open far longer than won deals take, with nothing logged lately.

    Example
    Doerbay
    Pipeline forecast, Q4, week 41The three numbersThe deals carrying most of itThe stalled deals worth a callOpen far longer than won deals take
  7. Step 7 · Learns

    Checks its own accuracy

    An earlier forecast's likely case against what really closed since, so you know how far to trust this one.

    Example
    Checks its own accuracyEvery Monday

    An earlier forecast's likely case against what really closed since

What you get

Every Monday, a forecast in Work with three numbers for the quarter (everything open, the likely case, the deals near certain), the open deals by stage with each one's chance from your history, the deals carrying most of it, the stalled ones worth a call, and what changed since last week.

The example is made up.

ExamplePipeline forecast, Q4, week 41
  • Open and due this quarter: $412,000. Likely: $118,000. Near certain: $54,000 (3 deals in contract).
  • Biggest change: a $38,000 deal with a four-entity retailer slipped to January.
  • 4 deals have sat at the demo stage over 60 days: worth a call.

Your part

Keep deal stages and close dates current in your CRM; the forecast is only as good as they are.

What it reads

  • CRM: HubSpot

Related workflows

Answer a question about growth

Growth AnalystWhen you ask

Ask about spend, leads, pipeline or revenue in plain words and get the numbers, each one opening the query it came from.

Weekly growth report

Growth AnalystEvery Monday

Every Monday: what moved last week, channel by channel from spend to revenue, and why it moved.

Find out why a number moved

Growth AnalystWhen you ask

When pipeline, leads or spend move, it traces the change to the channel, campaign or funnel step behind it and says how sure it is.

Forecast revenue from trials

Growth AnalystWhen you ask

The trials ending in the next two weeks and the new monthly revenue they would bring, day by day, with every trial listed.

Want this running on your data?

Tell us on a call. Or watch the Growth Analyst run it in the tour.

Book a callSee it in the tour