Opportunities with a next step and date
Shows whether the pipeline is being actively managed.
Consulting and professional services firms · CRM setup and cleanup
A CRM your partners will actually use for pipeline reviews
In consulting firms the real pipeline often lives in partners' heads and personal spreadsheets. The CRM holds a mix of old prospects, duplicate contacts from event imports, opportunities stuck at the same stage for a year, and clients who moved companies long ago. Pipeline meetings become a round of verbal updates, and forecasting revenue for the next quarter is guesswork.
How it often works today
- Partners track their own opportunities in spreadsheets or notebooks because the CRM stages do not reflect how consulting deals progress.
- Contacts who changed jobs remain linked to old companies, so alumni relationships and referral paths are invisible.
- Follow-on work from existing clients is rarely logged as an opportunity, so the firm undercounts its most likely revenue.
- Referral sources such as lawyers, bankers and past clients are not tracked, so the firm cannot see which relationships generate work.
We would agree a simple pipeline model that fits how consulting work is actually sold, including relationships, referrals and follow-on work, then clean the existing data and make updating it easy. Partners get a pipeline view they trust, and business development stops depending on who remembers what.
The improved workflow
Design a consulting pipeline
Agree stages that match your sales process, such as conversation, discovery, proposal, verbal and signed, with clear exit criteria for each one.
Clean contacts and companies
Merge duplicates, update job changes, archive dead records and link contacts to current employers, with a person reviewing merges in batches.
Track relationships and referrals
Add fields for referral source, relationship owner and alumni status, so the firm can finally see which networks and introducers produce paid engagements.
Make updates nearly automatic
Connect email, calendar and approved call summaries so activity is logged without typing, leaving partners to confirm stage and next step.
Run pipeline reviews from the CRM
Use one shared pipeline report in weekly or biweekly reviews, so the meeting focuses on decisions rather than collecting updates.
How we deliver this: AI automation for small business or fractional CTO leadership, scoped in writing and run over 90 days. See pricing or the sample scope.
What we would measure
Duplicate and stale contact rate
The data quality baseline the cleanup addresses.
Forecast accuracy by quarter
Tests whether the pipeline reflects reality.
Engagements attributed to referral sources
Helps partners invest in the relationships that produce work.
Where people stay in control
- Bulk merges and deletions are reviewed by a person and backed up first, since lost relationship history is hard to rebuild.
- Sensitive notes about clients or prospects are kept to what is appropriate for a shared system, with private details restricted to the relationship owner.
- Contact enrichment and email logging respect privacy laws and client preferences, and personal email accounts are excluded from syncing.
Example
Finding follow-on work hiding in plain sight
For example, in an illustrative case a 30-person HR consultancy cleans its HubSpot account and adds a stage for follow-on work. During the first pipeline review, partners log eleven follow-on conversations with current clients that had never been recorded. Two are close to signing. The cleanup also reveals that a handful of employment lawyers referred a large share of last year's new clients, so the managing partner schedules time with each of them.
Tools typically involved
What the first 30 days look like
In the first 30 days we would export the CRM, measure duplicates and stale opportunities, interview partners about how they actually sell, and draft the pipeline stages and fields. Partners would approve the design before any data changes.
Common questions
Our partners hate updating the CRM. How do we change that?
By making it take almost no effort and by using it in every pipeline meeting. If email and calendar activity log automatically and call summaries suggest updates, the partner only confirms stage and next step. When the managing partner runs reviews from the CRM, the incentive to keep it current follows.
Should we switch from HubSpot to Salesforce, or the reverse?
Rarely as a first step. Most consulting firms of this size are well served by either platform when it is configured for their process. A switch is expensive and disruptive. We would clean and configure what you have, and recommend a change only if a clear limitation remains.
How long does a consulting CRM cleanup take?
For most firms, pipeline design and the main data cleanup fit within the first 60 days, with adoption measured in the final month. The slowest part is often partner review of their own contacts and opportunities, so we would schedule short, focused sessions rather than one long one.
The business case
Does it pay for itself?
Illustrative defaults for a consulting firm. Replace them with your numbers.
What this workflow costs today
a month in staff time, before any lost sales
Monthly fee + assumed tools +
Break-even: new clients a month (at first-year value)
Or: staff hours recovered and redeployed
Break-even additional revenue
Value of +1 point of win rate
First 90 days, service fee
Worth a closer lookTest the assumptions
Illustration only, not a forecast or guarantee. Recovered staff time becomes a cash saving only if spending actually declines or the time goes into paid work. Tool costs are an assumption; we replace every number here with yours before recommending a scope.
CRM setup and cleanup in other industries
Financial advisory firmsInsurance agenciesNonprofit organizationsReal estate brokeragesStaffing and recruiting agencies
CRM setup and cleanup: full guide
Related guides
Change management for new softwareGetting staff to adopt new toolsHow to choose a CRMHow to automate lead follow-up without losing the personal touch
Terms used here
Next step
Bring one expensive workflow. Leave with a clear next step.
In 30 minutes we look at one recurring workflow, what it costs you today and whether there is a credible case to improve it. If there is not, we will say so.
Book a 30-minute workflow review
Not ready to talk? Take the 3-minute check
30 minutes with Phil or Martin. No technical brief, no pitch deck. Phil or Martin replies personally, usually within one business day.