How to Run a Mid-Year CRM Health Check

Most small business CRMs are not broken at year-end. They are broken by the end of April. Two quarters of fast-moving leads, a financial-year reset, and a few new starters who were never properly trained on the tool, and the database starts to drift. The fix is a mid-year health check: a half-day review that catches the issues while they are still small.

This guide walks through the nine checks that matter for a UK small business CRM. It is written for the sales or office manager who actually runs the tool, not for a CRM consultant. The checks are concrete: each one has a question, a way to answer it from inside the CRM, and a clear pass or fail.

The timing is deliberate. The UK tax year started on 6 April under HMRC ↗ rules, calendar Q1 has just closed, and most teams have set their first round of new financial-year goals. There is enough fresh data to find problems and enough runway to fix them before the second half of the year.

Why mid-year, not year-end

A year-end CRM review usually arrives too late to act on. The renewals have already lapsed, the unclean data has already shaped the wrong forecast, and the team has already built workarounds in spreadsheets that will be impossible to unwind in January. Mid-year is the point where you can still change the trajectory of the second half.

It is also the moment when the gap between what the CRM should be doing and what it is actually doing is most visible. Goals are recent enough that the team remembers them. Pipeline is full enough that data issues show up. Automations have run through enough cycles that the broken ones have shown themselves.

The nine checks

1. Data quality: are the contact records still trustworthy?

Pull a sample of 50 contacts and check five fields on each: name, email, phone, company, and last activity. If more than five records have a missing or wrong value in any one field, you have a data quality problem that will affect every campaign you run for the rest of the year.

The fixes are not glamorous: deduplicate, fill missing fields from email signatures, mark dormant records as archived. For a deeper dive on the cleanup itself, see cleaning up your CRM data: a practical guide.

Pass mark: under ten percent of records with a problem field. Fail: over twenty percent. Anything in between needs a follow-up cleanup session within the next two weeks.

2. Pipeline hygiene: is every deal still real?

Run a report of all open deals where the last activity is more than thirty days old. If that list is more than a quarter of the open pipeline, the pipeline is lying to you. Forecasts built on stale deals are noise dressed up as data.

For each stale deal, take one of three actions: close it as lost, reset the next step with a date, or reassign it to someone who can move it. No fourth option. The temptation to leave them sitting in case something changes is exactly how they got stale in the first place.

3. Stage definitions: does every stage have an exit criterion?

Look at each pipeline stage and write down what has to be true for a deal to leave it. If you cannot write a one-line exit criterion in under thirty seconds, the stage is loose. Loose stages are why deals jump from “qualified” to “verbal” without proof of either.

Tighten the definitions, share them with the team, and put them somewhere visible inside the CRM. Stage criteria that live only in the manager’s head are not criteria at all. The fuller treatment sits in how to build a sales pipeline that actually works.

4. User access: who has logged in this quarter?

Pull the user list and the last-login date. Anyone who has not logged in for sixty days needs a conversation. Either they are not using the tool (in which case why are you paying for the seat?) or they have built a workaround that is now the de-facto system (in which case you have a parallel CRM running in spreadsheets).

The half-honest middle ground, the user who logs in once a week to update a single record, is the most expensive of the three. They are paying for a seat but not getting the leverage. Train them up or move them to a viewer-only seat.

5. Automations: are they still doing what you set them up for?

Every automation drifts. The original lead-capture rule was for a form that no longer exists. The follow-up sequence references a discount code that expired in February. The internal alert pings a sales rep who left in March.

Open every active automation and answer two questions for each: is the trigger still valid, and is the action still appropriate? If you have more than ten automations and have not done this since January, plan on at least an hour. The wider playbook in CRM workflow automation beyond the basics covers what good looks like.

6. Integrations: is data still flowing both ways?

Most small business CRMs have three to five integrations: email, calendar, accounting, marketing, and a website form. Each integration is a place where data can silently stop syncing. Symptoms are quiet: a missing meeting in the contact timeline, a paid invoice that still shows as outstanding, a website lead that never made it into the database.

For each integration, run a known-good test. Send a test email and check it appears against the contact. Book a meeting and check it shows up. Submit the website form yourself. The test takes five minutes per integration and catches problems that would otherwise take weeks to surface.

7. Reporting: do the four numbers still match the goals?

Open the dashboard. Are the metrics on it the ones you actually use to run the business? Most CRMs ship with default dashboards that mix vanity metrics (total contacts, open emails) with the numbers that matter (deal velocity, conversion by stage, revenue by source).

Cut the vanity metrics. Replace them with the four or five numbers you would want to read first thing on a Monday morning. The principles in building a CRM dashboard that your team will actually use apply directly.

8. Consent and compliance: would the ICO be happy with what they found?

UK GDPR and PECR are not optional, and the Information Commissioner’s Office ↗ publishes regular enforcement notices against small businesses who have got marketing consent wrong. Five things to check in the CRM record:

• Lawful basis recorded against every contact
• Per-channel consent flags (email, post, phone, SMS) with date and source
• Suppression list honoured across every campaign tool
• Retention rules in place, with archive dates on dormant records
• Audit trail showing who changed consent and when

The ICO advice for small organisations ↗ is the reference worth bookmarking inside the CRM. For a fuller checklist that ties this together, see CRM and GDPR: a compliance checklist for UK small businesses.

9. Goal alignment: does the CRM still reflect what you set out to do?

In April, most small businesses set financial-year goals: revenue, new clients, retention, average deal size. By May Day, the CRM should have those goals visible somewhere a sales rep cannot avoid them. If the goals are buried in a spreadsheet on the operations director’s laptop, they may as well not exist.

Add the four to six headline goals as targets in the dashboard. Make them visible on the home screen. Make the gap between current and target updateable in under a minute. Goals that take effort to find are goals that quietly slide.

A scoring framework that actually helps

Tracking the nine checks one by one is fine for a single pass. To make them comparable across years, score each on a simple scale.

Check	Score 0	Score 1	Score 2	Score 3
Data quality	More than 30 percent records with issues	15 to 30 percent	5 to 15 percent	Under 5 percent
Pipeline hygiene	Over 40 percent stale	25 to 40 percent	10 to 25 percent	Under 10 percent
Stage definitions	No written criteria	Some stages defined	Most stages defined	All stages, exit criteria visible
User access	More than 25 percent inactive	10 to 25 percent	5 to 10 percent	Under 5 percent
Automations	Not reviewed in 12+ months	6 to 12 months	3 to 6 months	Under 3 months
Integrations	Untested in 12+ months	6 to 12 months	3 to 6 months	Tested this quarter
Reporting	Default dashboard only	Some custom reports	Tailored dashboard	Tailored, used in monthly meeting
Consent	No lawful basis recorded	Recorded for some	Recorded for most	All contacts, with audit trail
Goal alignment	Goals not in CRM	Goals in CRM, hard to find	Goals visible on dashboard	Goals visible, updated weekly

A total score out of 27 gives you a year-on-year comparison. Most small businesses score 12 to 18 the first time. Anything above 22 is genuinely well-run. Below 10 is a CRM that needs a strategy rethink, not a tidy-up; five signs your CRM strategy needs a rethink covers what to do next.

What to fix first when the score is low

Resist the urge to fix everything at once. The temptation after a health check is a sprawling improvement plan that nobody finishes. A better approach: pick the two checks with the lowest score, and assign one owner and one deadline to each. Two weeks per item. Leave the rest until the next mid-year check.

Two checks fixed properly beats nine improved superficially. The compounding benefit of clean data is only available when the data actually stays clean, which means real ownership and real deadlines, not a bullet list at the end of a meeting.

For the broader cadence that keeps a CRM healthy across the year, see how to run a weekly CRM review in 15 minutes and the monthly companion in CRM reports every small business should run monthly. Weekly catches the small drift, monthly catches the patterns, and a mid-year check catches the structural issues neither of the others is designed to find.

The one-page summary that earns its keep

The output of a mid-year CRM health check should fit on a single side of A4: nine scores, two improvement targets, two named owners, two deadlines. Anything longer is a report that nobody will read in October. The reason the check works is not the depth of the audit, it is the discipline of the next step. A short, ruthless summary delivers that. A thirty-page document quietly does not.

Run it now while the financial-year goals are still fresh. The half day you spend in early May is the half day that buys you a clean second half of the year.