StrataOps

INSIGHTS · WARNING SIGNS

Seven signs your CRM needs an audit

Your CRM needs an audit when you've stopped trusting it: duplicate records, fields nobody fills in, deals sitting untouched for months, a forecast built in a spreadsheet, and sales and marketing quoting different numbers. Recognise three or more of the seven signs below and it's time for a proper look. Each one has a cost, and I've put that cost next to it.

None of this means anyone did a bad job. It means the company grew and the systems didn't catch up, which is normal and fixable.

1. The same company exists three times

Sales logs "Acme Ltd", marketing imports "ACME Limited", a LinkedIn export adds "Acme". Now three people work the same account without knowing, activity history splits three ways, and reporting counts one prospect as three.

The cost: embarrassing double-contacts, wasted rep time, and numbers you can't trust at the most basic level.

2. Fields nobody fills in, and fields nobody trusts

Open any record. If half the fields are blank and the filled ones are anyone's guess, your team has already voted with their keyboards. Reps stop entering data when they stop believing anyone uses it, and a doom loop begins: bad data makes reports useless, useless reports remove the reason to enter data.

The cost: every report built on those fields, which is usually all of them.

3. Deals sit untouched for 60 days and nobody notices

Sort your pipeline by last activity. If deals have sat silent for two months while still showing as live, your pipeline isn't a pipeline, it's a memorial. Close dates that slip quarter after quarter are the same symptom in different clothing.

The cost: the expensive one. Revivable deals go cold for want of a nudge, and your coverage ratio is fiction because a chunk of the pipeline is already dead.

4. The forecast is a spreadsheet with a guess inside

If your monthly numbers mean exporting to Excel, "adjusting" figures everyone knows are wrong, and an evening of formatting, the CRM has failed at its main job. A forecast should come straight from the system and broadly match what actually happens.

The cost: an evening a month of someone senior's time, and board decisions made on hunches dressed as data.

5. Sales and marketing report different numbers

Marketing celebrates 40 leads. Sales says they got 12, and 8 were students. If two teams looking at the same funnel see different realities, your definitions have drifted: what counts as a lead, when it qualifies, who owns it. The CRM should enforce those definitions; in a messy one, each team quietly keeps its own.

The cost: friction between teams, meetings spent arguing whose number is right, and no reliable read on what's working.

6. Automation you're scared to touch

Somewhere in your workflows is one nobody understands. The person who built it left, it fires emails at odd moments, and everyone's tacit agreement is to leave it alone. When a team fears its own automation, the tools have become the master rather than the servant.

The cost: you can't improve what you daren't touch, so every new process gets bolted on around the mystery, adding to the tangle.

7. A GDPR question would ruin your week

If someone asked tomorrow for lawful basis on every contact you email, how would that go? Stale consent, contacts imported from who-knows-where, and no deletion routine aren't only compliance risks. They're the sign that data has been accumulating rather than being managed. Deletion is rarely the only fix: I've brought a database that was 60 per cent stale back to a working asset.

The cost: regulatory exposure, plus a database that loses value every month it decays.

What does a CRM audit actually involve?

A structured review of five areas: CRM setup, data quality, pipeline discipline, follow-up and reporting. It ends in a scored result and a prioritised fix list, so you see what matters most rather than everything at once. It is not someone tutting at your naming conventions.

Mine runs two weeks, scores you out of 100, and you own the findings outright whether or not we work together again. Most audits also surface at least one revivable deal, which has a pleasing way of covering the cost.

What's the quickest way to check?

Run the quick version before committing to anything. A free commercial systems health check asks a few honest questions across the five areas above and gives you a score with the three fixes worth doing first. If you recognised yourself here, it will tell you how bad it actually is, which beats wondering.

Frequently asked questions

How often should you audit your CRM?

A full audit once a year suits most growing teams, with lighter data-quality checks running continuously. Audit sooner if you've changed CRM, restructured sales, or stopped trusting the numbers.

What's the difference between a CRM audit and a health check?

A health check is a quick, self-scored first look that points you at the weakest areas. An audit is a two-week diagnostic that goes in properly and ends with a prioritised plan you own.

Can a messy HubSpot be fixed, or should we start again?

Usually fixed. A rebuild is occasionally the right call, but most "broken" HubSpots are a design and discipline problem, not a tooling one. The audit tells you which you have before you spend on either.

The easiest way to get clarity

You can answer a lot of this in three minutes without talking to anyone. My free commercial systems health check scores your CRM, pipeline, data and follow-up out of 100 on screen, and sends you the three fixes worth doing first if you want them.

Take the free health check →