-
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
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
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
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
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
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
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
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.