Consulting Business Development Tracker
Three documents and three sheets that run a standing outreach cadence on every past client, then escalate it the moment your delivery calendar fills up.
Free download · No account needed
Past Client Re-engagement Tracker · Halstead Advisory · 16 past clients tracked · audited 06 Aug
Five clients, guessed from memory against the logged date
| Client | Logged last contact | Days since | Guessed from memory | Computed status |
|---|---|---|---|---|
| Aldercott Financial | 13 May | 85 | “We talk all the time” | On cadence |
| Penbrook Analytics | 02 May | 96 | “Recently, I think” | Due |
| Bellcastle Manufacturing | 16 Feb | 171 | “A few months, maybe” | Due |
| Fenhollow Consulting | 29 Jan | 189 | “Not that long ago” | Overdue |
| Crowmarsh Nonprofit | 11 Nov | 268 | “A while, but not too bad” | Overdue |
Two of these five were called “probably fine” from memory. Both were already past the ninety-day cadence, and Crowmarsh Nonprofit, silent for 268 days, was one of three clients who had gone past six months with nobody flagging it.
Page one for a consulting business development tracker is the same seven-column spreadsheet everywhere: stage, value, probability, next action, next date. Griddy's consultant pipeline templates, monday.com's business development tracker, and Stackrows' consulting sales forecast all track an opportunity the same way, and each one depends on someone opening the sheet often enough to keep it honest. None separates a past client from a cold lead, and none gets louder specifically when a consultant is too busy delivering to open it. This pack runs two rules that do not depend on that attention.
A past client already trusts the work, so reaching them again is not a cold pitch. Frederick Reichheld's research at Bain found that acquiring a new customer costs five to twenty-five times what retaining an existing one does, and a former client sits on the cheap side of that math. Halstead Advisory, a solo consulting practice audited for this pack, logged 22 opportunities in a trailing year. Past-client re-engagement was 5 of them and 4 of the wins, worth $118,000 of $225,500 won, 52.3 percent of revenue, against an 80 percent win rate.
That same practice's own log shows why the source needs protecting. Sixteen past clients set a floor of 64 touches a year at a ninety-day cadence, and the practice logged 30. The six busiest months produced 2 of those 30 touches, 6.7 percent, despite being half the year. The escalation rule targets that gap: once three or more of the next four weeks are already booked, every past client untouched in 45 days gets flagged before the busy stretch starts. The same pipeline feeds the practice dashboard, then hands off to the discovery call pack.
What's in the pack
BD Plan
Sets the pipeline coverage target at three times the coming quarter's revenue, then ranks net-new, referral, and past-client re-engagement by which one actually converts. The revenue target itself comes from the rate card pack.
Outreach Cadence
States the standing ninety-day touch and the forty-five-day escalation that triggers once three or more of the next four weeks are already booked, with the reconciled monthly evidence behind both thresholds.
Re-engagement Angles
A library of specific reasons to reach a past client beyond a generic check-in: a change touching the work delivered, a review point the engagement implies, or a milestone noticed in public information.
Pipeline Register
Every opportunity from the trailing year, dated and sourced as net-new, referral, or past-client re-engagement, with its outcome, so a win rate computes by source instead of getting asserted. Whether a won engagement was actually profitable is a separate check.
Past Client Re-engagement Tracker
Every former client with a logged last-contact date, the days since computed against it, and a three-valued cadence status that never comes from memory. Re-engaging one is also the moment to check whether an old restriction is still live.
Referral Source Analysis
One row per person or organization who has actually referred work, not per referral, ranked by win contribution rather than raw count, so a productive relationship is visible against one that sent volume and nothing else.
Overdue Is a Date, Not a Feeling
The standing rule behind every status on the tracker. Cadence is computed from a logged date against a threshold, never estimated from how the relationship feels, because the gap since an unlogged touch is the easiest number in a practice to underestimate.
How to use it
- 1
Open in River, or take it blank
Install the pack and send your open opportunities, past clients, and referral sources, or download the Word documents and CSV sheets and build the registers yourself.
- 2
Log every source
Every opportunity gets dated and classified as net-new, referral, or past-client re-engagement, and every former client gets a real last-contact date instead of an impression of one.
- 3
Let the cadence run
Days since last contact computes each client's status against the ninety and one-hundred-eighty day thresholds, and a forward calendar check applies the escalation once three of the next four weeks are already booked.
- 4
Draft and log the outreach
Draft the specific re-engagement message from a real angle rather than a generic check-in, send it, then log the touch immediately so the cadence clock actually resets.
Frequently asked questions
Is this template free?
Yes. The zip is Word documents and CSV sheets, no account and no card required. Edit with AI is the optional half: the agent reads your open opportunities, past clients, and referral history, then builds all three registers and sets every cadence status from a real date. The rest of the packs sit in the template library.
What format are the downloaded files?
Three Word documents and three CSV sheets in one zip. The Pipeline Register and Past Client Re-engagement Tracker carry the columns that do the work: source, entered date, days since last contact, and computed status. Excel, Numbers, and Google Sheets all open them with nothing to convert.
What does Edit with AI actually do?
It reads your open opportunities, past client list, and referral history, then classifies every opportunity by source, dates every past client's last real contact, and computes each cadence status. From there it checks your forward calendar and flags anyone the escalation rule catches before you get too busy to send the touch.
Does this replace a CRM?
No, and it is not trying to. A CRM tracks contacts and activity generally; this pack runs one specific rule, a past-client cadence that escalates against your own forward workload, which a general CRM has no field for. Qualifying a single new enquiry is a separate job, and turning a qualified one into a signed order is the proposal pack.
Why does a referral source who introduced a past client count differently?
Because the two questions are different. A former client who introduces someone else is a referral source for that new opportunity, logged on the Referral Source Analysis sheet, even though the introducer is also tracked separately on their own cadence as a past client. Conflating the two hides which relationship actually produced the win.
How is overdue actually decided?
From one comparison: today's date minus the logged date of the last real touch, checked against the ninety and one-hundred-eighty day thresholds. It is never estimated from how recently a relationship feels current, because the gap since a touch that did not happen is the easiest number in a practice to underestimate.
Stop losing your best source to a busy quarter
Take the Word documents and CSV sheets blank, or send River your opportunities, past clients, and referral history and get every cadence status computed back.
Edit with AI