Your CRM data sucks? 6 hard-won lessons from a recent real-world audit

Your CRM Data Sucks? 6 Hard-Won Lessons from a Real-World Audit

Introduction: The “Powerful-But-Useless” CRM Problem

You’ve invested in a powerful CRM like HubSpot, expecting it to be the engine of your growth. Instead, you have a black box of messy, unusable data.

If this sounds familiar, you’re not alone. I recently worked with a fast-growing service agency whose co-founder put it bluntly: “our data SUCKS.” His team’s usage of their expensive tool was, in his own words, a “two out of ten.”

The frustration was palpable. The Head of Sales couldn’t generate the most basic reports to forecast revenue or track performance, admitting the reporting function “gives me the shits.” They had a powerful tool that felt useless.

This isn’t a unique story. But the path out of the chaos is more straightforward than you might think. The following are six hard-won lessons distilled from my engagement to turn that client’s chaotic CRM into a reliable, predictable engine for growth.

1. Stop Treating Every Contact Like a Deal-in-Progress

The first major issue was a fundamental misunderstanding of the objects within the CRM. The team was skipping the lead stage entirely, adding a contact and then immediately creating a deal. This muddied their pipeline with unqualified prospects and made it impossible to separate active sales cycles from early-stage prospecting.

The solution was to introduce a clear definition for the Lead object (specifically leveraging HubSpot’s Prospecting Workspace).

This distinction is critical because it separates the messy, often lengthy process of prospecting from the structured process of closing. A contact is a permanent record of a person. A lead is a temporary object representing a specific attempt to engage that person. A single contact can have multiple leads over time—one for an inquiry this year, another for an outbound campaign two years from now. This creates a clean, reportable history of each engagement attempt without cluttering the pipeline with unqualified “deals.”

Action Item: Define a “Lead” as a temporary prospecting object. Mandate that all prospecting activities live in the Lead stage before a qualified opportunity earns the right to become a Deal.

2. Your Sales Process Is Probably Simpler Than Your Pipelines

Complexity is the enemy of adoption. The client had created two separate deal pipelines, “Retainer” and “Project,” even though, by their own admission, the sales stages were “exactly the same.” This created confusion, especially when a new opportunity could be either a project or a retainer, forcing the sales team to guess which pipeline to use.

My recommendation was simple: unify the two into a single sales pipeline. The distinction between deal types could be handled with a simple custom property called “Revenue Type” with two options: Project or Retainer.

This approach dramatically simplifies the user experience. The sales team works from one consistent set of stages, eliminating guesswork. Instead of jumping between tabs, they can view the entire pipeline at once to gauge overall health and then filter by “Revenue Type” to analyse project and retainer revenue separately.

Action Item: Review your deal pipelines. If stages are identical across multiple pipelines, merge them immediately and use a custom property to differentiate deal types. Your sales team will thank you.

3. If You’re Not Tracking Expansions, You’re Ignoring Your Easiest Revenue

One of the biggest blind spots for many businesses is tracking revenue growth from their existing customer base. It’s often handled informally, and the revenue never makes it into the CRM, rendering it invisible to reporting. The client flagged this directly:

“We do a lot of current client upgrades which we don’t put into HubSpot… wondering if we should.”

Absolutely, you should. If you don’t, you cannot calculate your true LTV (Lifetime Value).

The solution I established was a clear process: create new deals for all client upgrades and mark them with a “Deal Type = Expansion.” This simple change ensures that revenue from account growth is captured with the same rigour as new business. It makes success in account management a visible, reportable metric.

Action Item: Create a process to log every client upgrade or upsell as a new deal. Use a “Deal Type” property to label it as “Expansion” to separate it from new business.

4. Automate Your Inbound Funnel Before It Leaks

Inbound interest is precious, but it’s worthless if it falls through the cracks. A quick audit of the client’s HubSpot portal revealed a critical leak: their “Contact us” form submissions were not creating a lead, a deal, or even a follow-up task. Opportunities were being missed simply because no process was in place to act on them.

This was one of several “quick wins” we identified to establish a clean baseline. I implemented a simple workflow to automatically create a Lead from every single form submission and assign it to the sales team. This instantly plugged the leak, ensuring every hand-raiser triggered a concrete, trackable next action.

Action Item: Audit all your website forms. Ensure every submission automatically creates a lead, a deal, or at a minimum, a task assigned to a specific person so nothing is ever missed.

5. Turn Your Events From a Cost Center into a Measurable ROI Machine

The client, like many companies, was running marketing events but had no systematic way to connect that activity to sales outcomes. There was no data on how much pipeline or revenue was influenced by their event spend, making it impossible to calculate ROI.

My proposed solution was to leverage Custom Objects within the CRM. By architecting a dedicated “Event” object, rather than relying on messy text fields, we could:

1. Associate every attendee (imported from a list or registration form) with a specific Event record.

2. Run targeted, personalised post-event email outreach.

3. Crucially: Automatically associate any future deals from attendees back to the Event they attended.

This system provides clear, unambiguous data on how much pipeline and closed-won revenue each event influenced. It turns events from an expense line item into a measurable growth driver. The Head of Sales’ reaction to the idea said it all: “I have to have that.”

Action Item: Use a Custom Object to track events. Log every attendee and associate them with the event to start measuring event-influenced pipeline and revenue.

6. You Can’t Report on Data You Don’t Trust

The client’s initial request was heavily focused on fixing their reporting. The Head of Sales was deeply frustrated with the inability to build reliable dashboards. However, in my proposed sequence of work, “Reporting dashboards” was the very last item on the list.

This counter-intuitive order is the most crucial lesson of all. As the Co-founder quickly realised during our call:

“I don’t think we’re close to [dashboards] because I just reckon the data input is wrong.”

Reliable dashboards are the result of a healthy CRM, not the cause of one.

You cannot build meaningful reports on a foundation of inconsistent, incomplete, and untrustworthy data. You must first establish a clean baseline, implement a logical structure (like unified pipelines and clear lead definitions), and ensure consistent data is being captured for every record. Only then can you build dashboards that reflect reality.

Action Item: Postpone major dashboard builds until you have fixed the underlying data inputs. Prioritize defining your objects, structuring your pipelines, and training your team on the correct data entry processes first.

Conclusion: From Mess to Momentum

The health of your reporting is a lagging indicator of your process discipline. Stop chasing dashboards and start fixing the foundational inputs. Get your leads, pipelines, and deal types right, and the reporting you crave will follow naturally.

Turning a CRM from a source of frustration into a strategic asset isn’t about finding a magic feature; it’s about methodically fixing the foundations of how you define, collect, and structure your data.

If you’re reading this and realising your CRM is a “two out of ten”, don’t build another dashboard. Start with the data audit. If you need a second pair of eyes on your architecture to spot the leaks, drop me a message.

Contact

To get in touch, please drop me a line at tom <at> tjmdigital <dot> com