How-to guide

How to build a 90-day renewal forecast

A 90-day renewal forecast is the shortest-feedback-loop retention tool you have, and most SaaS teams either skip it or run it as a spreadsheet exercise that nobody trusts by week two. This guide walks the full process: cohorting the 90-day window, tagging every account with a CSM-assessed status, pulling the supporting usage and sponsor data, assigning save motions, rolling the whole thing up to a defensible NRR and GRR projection, running the bi-weekly review with VP Customer Success and VP Sales, and closing the loop with a 90-day retrospective. Run it as a monthly cadence and you will see renewal risk two quarters earlier than your board does.

Before you start

What you need.

Time: 1 week to design, monthly refresh

  • A clean customer renewal date index: every active account tagged with its contract renewal date, auto-renew flag, and term length, pulled from billing rather than the CRM
  • Health score inputs you already collect: product usage frequency, admin activity, seat utilization, support ticket sentiment, and open success plan commitments, with a documented green, yellow, red threshold for each
  • A CSM-assessed status call on every account in the 90-day window: a written judgment captured in the CRM, not a verbal update in standup
  • Executive sponsorship signals: last touch date with the economic buyer, champion status (active, dormant, departed), and any recent reorganization or buying-center change on the customer side
  • Finance alignment on renewal categories: a shared definition of what counts as committed, likely, risk, and churn, co-signed by the VP CS and the VP Finance before the first forecast runs
Build a 90-day renewal forecast

Step by step.

  1. 1

    Segment accounts into the 90-day renewal cohort

    The first move is to isolate the right pool of accounts, because a forecast that mixes the next 30 days with the next 180 loses signal in both directions. Pull every account whose renewal date falls inside the next 90 days from the billing system, not the CRM, and reconcile the list against finance before anyone touches it. Enrich each account with contract value, segment, plan tier, acquisition channel, CSM owner, and account executive owner. The output is a single locked list for the quarter that nobody can quietly add to or remove from without a written reason. Treat the list as the source of truth: every downstream tag, save motion, and roll-up points back to it. If an account slips in or out mid-cycle, that is a change management event, not a spreadsheet edit.

    • Pull the renewal list from the billing system on the first business day of each month and lock it inside 24 hours
    • Enrich each row with contract value, segment, plan tier, CSM owner, and AE owner so the forecast rolls up cleanly later
    • Separate auto-renew accounts from negotiated-renewal accounts because the save motion and the forecast confidence differ
    • Store the locked list as a snapshot so every subsequent forecast refresh can be compared apples-to-apples
    Tip: If your billing system and your CRM disagree on who is in the 90-day window, trust billing and fix the CRM. Running the forecast off CRM renewal dates is the single most common reason the number drifts from finance's reality.
  2. 2

    Tag each account with a CSM-assessed status

    Every account on the locked list gets exactly one of four tags: committed, likely, risk, or churn. Committed means the renewal is co-signed in writing with the economic buyer, usually through a QBR or a formal renewal plan. Likely means the health score is green, the sponsor is active, and there is no known blocker, but no written commitment yet. Risk means the health score is yellow, a signal has fired, or the sponsor has gone quiet, and the account needs an active save motion. Churn means the account has either told you it is leaving or shown behavior that makes a renewal implausible inside the window. The CSM makes the call in writing in the CRM, with a one-sentence rationale, and the status is time-stamped so you can see drift between forecast cycles. Gainsight renewal research consistently shows that teams that force a four-tier call with written rationale forecast renewals two to three points more accurately than teams using a free-text status field.

    • Lock the four categories in writing and co-sign the definitions with finance so nobody re-interprets them mid-quarter
    • Require a one-sentence CSM rationale on every tag, captured in the CRM with the author and timestamp
    • Flag any account whose tag has drifted two levels or more between cycles for a formal re-review
    • Audit tag accuracy at the retro by comparing the status at day 90 to the actual renewal outcome
    Tip: Resist the urge to add a fifth tag for complicated cases. Four is enough tension to force a decision, and five is the number at which the forecast quietly becomes a free-text field with color codes.
  3. 3

    Pull supporting usage and executive sponsor data

    A status tag is only as credible as the evidence behind it, so every account on the list needs a short evidence pack attached before the first review. Pull the trailing 90 days of product usage, the trailing 90 days of admin activity, the trailing 90 days of support tickets with sentiment, and the last touch date with the economic buyer. Mark whether the champion is still in-seat, has changed roles internally, or has left the company, with LinkedIn job-change alerts wired to the CRM. Pavilion operator surveys have shown that champion departure inside the final two quarters raises churn probability sharply, so it is worth tracking as a first-class signal, not an afterthought. The evidence pack lives on the account record itself so the CSM, the AE, the VP CS, and the VP Sales see the same picture when they walk the list.

    • Standardize the evidence pack: usage curve, admin activity trend, support sentiment, last sponsor touch, and champion status
    • Wire LinkedIn job-change alerts into the CRM for every named champion and executive sponsor
    • Surface the evidence pack on the account timeline rather than in a separate dashboard so it travels with the forecast
    • Refresh the evidence pack monthly on the same day the renewal list is locked
    Tip: If the CSM cannot point to the evidence inside the account record, the status tag is a guess. Treat missing evidence as an automatic downgrade to risk until the pack is filled in.
  4. 4

    Assign a save motion to every risk account

    Every account tagged risk gets a named save motion inside 48 hours of the status call, and no risk account sits on the list without one. A save motion is a scripted intervention with a trigger, an owner, a sequence of steps, a success criterion, and a stop rule. Pair the CSM with the account executive and, when needed, a technical specialist or an exec sponsor from your side to re-anchor the relationship. OpenView retention benchmarks show that teams running a disciplined save motion on risk accounts recover 25 to 40 percent of them inside the window, which is a meaningful compounding lever when the alternative is treating risk as inevitable. Measure each motion: how often it fires, how often it moves the account from risk to likely or committed, and the actual renewal rate afterward. Retire motions that do not demonstrably move the needle.

    • Write each save motion as a one-page runbook: trigger, owner, steps, success criterion, stop rule, escalation path
    • Match the motion to the risk signal: a champion departure motion is not the same as a usage-decline motion
    • Set a two-week stop rule so motions that fail to move the account escalate rather than drift
    • Track outcomes per motion and retire the ones that do not move the needle at the quarterly retro
    Tip: The best save motion is the one you ran at day 60, not day 20. Measure save success by how early the motion fires in the window, because late saves rarely compound into clean renewals.
  5. 5

    Roll the forecast up to an NRR and GRR projection

    The point of the forecast is to produce a defensible NRR and GRR number for the 90-day window that finance and the board can trust. Translate the four status tags into weighted assumptions: committed accounts roll in at 100 percent of contract value, likely accounts at a documented confidence rate, risk accounts at a lower documented rate, and churn accounts at zero plus any already-signed downgrade. Add expansion and contraction from the same list so the net number is a single roll-up, not two. Report the gross number and the net number side by side with four quarters of history visible so the trend is obvious. SaaS Capital survey data shows that private SaaS teams that publish both numbers monthly catch retention drift one to two quarters earlier than teams that publish only net. Reconcile the forecast against the billing system before any VP CS, VP Sales, or finance conversation so nobody is arguing about the denominator inside the meeting.

    • Document the weighted confidence rate for each of the four tags and lock the rates with finance before the forecast runs
    • Fold expansion and contraction into the same roll-up so NRR and GRR come from a single defensible list
    • Publish both numbers on a single dashboard with four quarters of history visible at a glance
    • Reconcile against billing before any cross-functional review so the meeting debates the plan, not the math
    Tip: If your net number is strong but your gross number is weak, you are papering over churn with expansion inside the 90-day window. Surface both so the forecast tells the full story.
  6. 6

    Review the forecast bi-weekly with VP CS and VP Sales

    A forecast without a cadence rots inside a cycle. Run a bi-weekly 30-minute review with the VP Customer Success, the VP Sales, the CSMs who own accounts on the list, and the account executives attached to those renewals. Walk the list in order of contract value, update the status tag on any account that has moved, review the active save motions, and surface any new signals that have fired since the last meeting. The output of the meeting is a short written note: which tags moved, which motions fired, which renewals landed, and which risks escalated. Pavilion and OpenView operator practice both show that the bi-weekly cadence is the shortest viable loop for mid-market renewals: weekly is too noisy because tags do not move that fast, monthly is too slow because risks drift past the save window. Treat the review like a pipeline review, not a status update.

    • Lock a recurring bi-weekly 30-minute slot with VP CS, VP Sales, CSMs, and AEs on the list, with no slip
    • Walk the list in descending contract value order so the biggest renewals get the first minutes
    • Capture a short written note at the end of every meeting: tags moved, motions fired, renewals landed, risks escalated
    • Escalate any account that has sat in risk for two consecutive reviews to the VP CS and the VP Sales the same day
    Tip: If the bi-weekly review turns into a reporting meeting rather than a working meeting, the forecast is already slipping. Protect it the way a sales team protects pipeline review.
  7. 7

    Update the forecast with win and loss data as renewals land

    Every renewal that lands or churns inside the 90-day window becomes evidence for the next cycle, so the forecast is only alive if you feed the outcomes back into it. Record each outcome in the CRM against the original status tag: committed accounts that renewed, committed accounts that did not, likely accounts that moved up or down, risk accounts that were saved or lost, and churn accounts whose actual exit matched or diverged from the call. Capture a one-paragraph win or loss note on every outcome so the pattern surfaces by cycle three or four. Gainsight benchmarks show that teams that run a structured win-loss capture on renewals get materially better at tagging risk inside two quarters, which is one of the cleanest compounding levers in customer success. Share the aggregated patterns with product and go-to-market so the forecast becomes an input to the broader retention operating system rather than a CS-only artifact.

    • Record every renewal outcome against its original tag so forecast accuracy is measurable
    • Capture a one-paragraph win or loss note on every outcome, with the economic buyer named
    • Aggregate patterns quarterly and share the themes with product, marketing, and go-to-market
    • Promote the strongest patterns into standard early warning signals or save motion triggers
    Tip: A loss note that says the account churned for pricing is not a loss note. Push every CSM and AE to name the real reason, including the ones that reflect poorly on your own motion.
  8. 8

    Retrospect at 90 days and recalibrate the model

    At the end of every 90-day window, run a formal retrospective before the next cycle locks. Measure forecast accuracy by tag: what share of committed accounts actually renewed, what share of likely accounts moved up or down, what share of risk accounts were saved, and what share of churn accounts matched the call. Audit the weighted confidence rates against the real outcomes and recalibrate them with finance if the gap is more than a few points. Review the save motions: which ones fired, which ones moved the needle, which ones should be retired, and which new patterns deserve a new motion of their own. Close with a short written retro note that goes to VP CS, VP Sales, VP Finance, and the CEO so the forecast quality is visible outside of CS. The retro is the mechanism that keeps the forecast honest, because without it the four tags quietly drift into optimistic territory and the next cycle starts with a bias nobody has priced in.

    • Measure forecast accuracy by tag and publish the result inside the retro note
    • Recalibrate the weighted confidence rates with finance if the accuracy gap is material
    • Audit the save motion library: retire the ones that did not move the needle and promote the new patterns worth scaling
    • Share the retro note with VP CS, VP Sales, VP Finance, and the CEO so the forecast stays trusted outside CS
    Tip: A retro that only reviews what went well is a comfort meeting, not a retrospective. Force the hard call on the tags that were wrong, because that is the only way the next forecast gets sharper.
Avoid

Common mistakes.

  • Running the forecast off CRM renewal dates instead of billing. The CRM drifts, finance will not reconcile against it, and the first VP Finance challenge will shred the credibility of the forecast inside a single review.
  • Collapsing risk and churn into a single tag. The save motion for a risk account and the exit motion for a churn account are different, and merging them hides the accounts that could still be saved behind the ones that cannot.
  • Letting the status tag live in a free-text field with color codes. The forecast becomes unreadable at scale, finance will not trust it, and the retro cannot measure accuracy because there is no clean category to compare against.
  • Skipping the bi-weekly review when the quarter gets busy. The two reviews that get cancelled are always the ones where a risk tag was about to move, and the forecast never recovers inside the window.
  • Reporting the net number without the gross number. Expansion inside the 90-day window can mask real retention weakness, and the board eventually notices the gap at the worst possible moment.
FAQ

Frequently asked questions.

What is a 90-day renewal forecast?

A 90-day renewal forecast is a locked list of every account whose renewal falls inside the next 90 days, with each account tagged committed, likely, risk, or churn and rolled up to a projected NRR and GRR number. It is a shorter cycle than the annual plan and a longer cycle than the weekly save-motion standup, which is why it sits so well between CS and finance.

Why 90 days and not 60 or 180?

Ninety days is the shortest window that still gives save motions time to work and the longest window where CSM status calls stay credible. Sixty days leaves no room to run a ninety-day save play, and one hundred eighty days is far enough out that the status tag becomes a guess rather than an assessment.

Who owns the renewal forecast, CS or finance?

Customer success owns the operating cadence, the tags, and the save motions. Finance co-signs the category definitions and the weighted confidence rates, and reconciles the roll-up against billing. Treat it as a shared artifact with a single roll-up to the board rather than a CS-only line item.

How accurate should a 90-day renewal forecast be?

Mature teams land inside a few percentage points of the actual renewal outcome by category inside two to three cycles. Early cycles will show wider gaps on the risk and likely tags, which is the exact signal the retrospective is designed to catch and the weighted rates are designed to correct.

How is the renewal forecast different from the sales pipeline?

The sales pipeline tracks new revenue that has not been earned yet, with probabilities tied to deal stage. The renewal forecast tracks recurring revenue you already earned, with probabilities tied to account health, sponsor engagement, and save motion status. They roll up to different leaders, use different categories, and need different cadences.

What tools do I need to run a 90-day renewal forecast?

You need a billing system as the source of truth for renewal dates, a CRM that can hold the status tag, the evidence pack, and the save motion runbook on the account record, and a shared dashboard that rolls the list up to NRR and GRR with four quarters of history. If any of those three live in a spreadsheet, that is the first thing to migrate.

See it in Strkr

Related product surfaces.

Strkr forecasting Strkr CRM All features

Run the renewal forecast on the system that keeps CS and sales aligned

Strkr gives customer success, sales, and finance a shared view of renewal dates, health scores, status tags, save motions, and the NRR and GRR roll-up, so the 90-day forecast stops living in spreadsheets and starts living in the system of record.

Try it free. Bring your team next week.

No sales call, no migration consultant, no four-month implementation. Enter your card, get 14 days of the full Pro tier, cancel any time before day 14 with zero charge. Spin up a workspace, import your CSV, and have something useful before lunch.