Your interests at heart. Always.
Lock & Quay Collective
← All our work

Client story · ADC Consulting

From fragmented HubSpot to a governed revenue system.

We helped ADC Consulting turn a fragmented HubSpot portal into a governed CRM foundation, with cleaner data, reliable source capture and a structured lead-management process.

Explore the work

Watch the client’s reaction

Open video in a new tab ↗

The client

Illustration of a consultancy team collaborating on connected sales and CRM processes against a European city backdrop.
Illustration · A European Data & AI consultancy

ADC Consulting is a European Data & AI consultancy operating across Amsterdam, Copenhagen and Stockholm. Its commercial team uses HubSpot to support business development, marketing, event follow-up and pipeline management.

The ambition was clear: make HubSpot the central nervous system for sales and marketing, rather than a database ADC’s team had to work around.

The problem

ADC had used HubSpot for roughly 18 months, but the portal was not giving leadership or the business-development team a trustworthy view of where leads came from, how they progressed or what should happen next.

Several migrations—from Pipedrive to Zoho and then into the current CRM setup—had left behind duplicate and legacy fields. Early discovery identified hundreds of properties with only a small subset in regular use; the audit we led later catalogued 901 properties across Contacts, Companies, Deals and Leads, plus 39 active workflows across four clusters.

The practical symptoms were visible across the revenue process:

  • Lead-source attribution was unreliable, with event and campaign leads sometimes appearing as direct traffic.

    Illustration: Personified Google Ads, Meta Ads, Mailchimp and HubSpot Email each say “This lead is mine!” while a puzzled marketer tries to identify the true source.
  • There was no consistently used lead-management process or lifecycle framework.

    Illustration: Contact cards sit between disconnected lifecycle stages.
  • Deals were often created too early, while follow-up tasks and stage changes depended on individual habits.

    Illustration: A lead enters a deal folder before qualification, with conflicting follow-up calendars.
  • Dashboards were cluttered and did not separate leadership reporting from the day-to-day needs of business development.

    Illustration: Overlapping dashboards mix strategic reporting with daily sales tasks.
  • LinkedIn, Sales Navigator, forms, newsletters and other acquisition activity were not connected into one dependable journey.

    Illustration: Separate acquisition channels have broken paths to a central CRM record.
  • Historical workflows, properties and tasks made it risky to change the system without first understanding dependencies.

    Illustration: Moving one property card pulls on interconnected workflows and tasks.

The core issue was data integrity, governance and adoption.


The approach

We split the engagement into two phases: first understand and audit the system, then implement the agreed changes.

Phase 1: Discovery, audit and architecture

Before changing the live portal, we ran structured workshops to understand ADC’s actual sales and marketing process. We led the review of workflows, properties, integrations and reporting requirements, then used the findings to create a phased governance and implementation roadmap.

Watch the sales-process workshop

Open video in a new tab ↗
Actual sales-process discovery workshop. We built the Miro map with the client team. Twelve minutes condensed into 22.5 seconds at 32× speed. Silent; identities and named assignments are cropped or blurred.

We worked through lead intake, ownership, outreach, meeting booking and deal stages with the client before deciding how the CRM should support them.

Our discovery and audit work included:

  • A sales-process workshop covering lead intake, qualification, ownership, deal progression and handoffs
  • A technical HubSpot audit
  • A workflow architecture map covering all active automations
  • A property dependency review across the core CRM objects
  • A future-state lifecycle and lead-management model
  • A prioritised roadmap that separated foundation work from later reporting and optimisation

We designed the lifecycle model around how ADC’s team actually sold, rather than applying a textbook MQL/SQL template.

Phase 2: Governance and core implementation

In the second phase, we delivered the agreed CRM foundation. We organised its 13 features into three milestones:

1. Data foundation and governance

We used the audit to make explicit decisions about which properties and workflows to keep, merge, standardise, rebuild or retire.

  • Reviewed, merged and deprecated duplicate or legacy properties
  • Consolidated the workflow library and retired obsolete automation
  • Established an agreed governance model before further configuration
Our property-governance working view: standard-field equivalents, merge notes, fill rates and dependencies in one place
From the project View full size ↗
Our property-governance working view: standard-field equivalents, merge notes, fill rates and dependencies in one place. Creator names are blurred. This documents the decisions behind the cleanup, rather than a completed-deletion tally.

2. Core configuration and lead intake

We translated the agreed model into source capture, lifecycle automation and a clearer intake process.

  • Implemented first-touch and last-touch source capture across contacts, leads and deals
  • Automated lifecycle-stage progression
  • Built a dedicated leads pipeline with stage-specific record views
  • Improved the Contact Us and Contact an Expert forms for segmentation, routing and attribution
  • Created a reusable UTM-capture form and walkthrough for LinkedIn campaigns

The redesigned workflow

An actual recorded after-view of the office/currency sync we redesigned into a controlled sequence
From the project View full size ↗
An actual recorded after-view of the office/currency sync we redesigned into a controlled sequence. This core-configuration example shows the dependency logic; it is separate from the lead-intake automation.

The HubSpot configuration

Actual HubSpot fields shown during training: latest UTM source, medium, campaign, content and term
From the project View full size ↗
Actual HubSpot fields shown during training: latest UTM source, medium, campaign, content and term. We cropped out the contact table and identifying UI.

3. Lead management, enablement and handover

We separated lead handling from deal progression, automated record handling and supported adoption with documentation and training.

  • Automated contact creation or updating from intake forms
  • Created or associated company records using captured data
  • Documented the system in ADC’s CRM wiki
  • Delivered live client training and recorded walkthroughs
The lead-stage redesign we walked through during training
From the project View full size ↗
The lead-stage redesign we walked through during training. The previous stages are on the upper row; the redesigned stages are below. The notes show activity-driven progression and the qualified-stage handoff to deal creation. Participant tiles and meeting details are cropped out.

The result

ADC finished the engagement with a cleaner, more controlled CRM foundation and a repeatable way to manage new leads.

An overview of the workflow architecture we delivered, assembled from actual recorded Miro views
From the project View full size ↗
An overview of the workflow architecture we delivered, assembled from actual recorded Miro views. This combines the retain, consolidate, standardise and rebuild sections; it is a composite overview rather than a full-board export.

Operational clarity

We replaced assumptions with an inventory of what existed, how it was connected and what could safely be consolidated. We gave ADC a clear governance path for properties and workflows before adding more automation.

A structured lead journey

We delivered lifecycle automation, a dedicated leads pipeline, stage-relevant record views and automated contact/company handling. This gave ADC a structured alternative to ad hoc deal creation and individual follow-up habits.

Actual HubSpot lead-pipeline, stage, type and label fields shown during client training
From the project View full size ↗
Actual HubSpot lead-pipeline, stage, type and label fields shown during client training. Record details and identifying UI are cropped out; this is a configuration view.

A dependable attribution framework

We delivered first-touch and last-touch capture, hidden UTM fields and improved intake forms. This established the basis for connecting campaigns, events and LinkedIn activity to CRM records without overwriting the original source.

An LQ-style illustration of the attribution framework we delivered: capture the source, preserve first touch and maintain last touch across connected CRM records
From the project View full size ↗
An LQ-style illustration of the attribution framework we delivered: capture the source, preserve first touch and maintain last touch across connected CRM records. This is an explanatory illustration, not a live HubSpot screenshot.

What we delivered

  • Sales-process discovery and future-state architecture
  • HubSpot portal audit and prioritised roadmap
  • Map of 39 active workflows across four clusters
  • Governance review covering 901 CRM properties
  • Property and workflow consolidation
  • First-touch and last-touch attribution framework
  • Lifecycle-stage automation
  • Dedicated leads pipeline and optimised record views
  • Updated Contact Us and Contact an Expert forms
  • Reusable UTM attribution form and training video
  • Contact and company creation automations
  • CRM wiki, Loom walkthroughs and live team training

Adoption, not just configuration

We made documentation and training part of the delivery: a shared CRM wiki, walkthrough videos and live training supported the handover. Both phases were completed.

The client’s own feedback reflected the change:

“Really happy about all the progress that has been made!” — Eelko Huizing, after seeing progress

At the closing meeting, Eelko added:

“We learned a ton. We’re in such a better place than we were. Thanks a lot for all the work.”


See the cleanup in action

We made the dependencies visible before deciding what to change. These are cropped frames from our project recordings; identifying details are blurred.

901 properties reviewed

Across Contacts, Companies, Deals and Leads.

39 workflows mapped

The audit separated what to retain, consolidate, standardise, rebuild or archive.

Actual property audit: fill rates alongside workflow, form and list dependencies
From the project View full size ↗
Actual property audit: fill rates alongside workflow, form and list dependencies. Creator identities and a client-specific row are blurred.
Explore: how we decided what should changeShow detailsHide details

We checked what each property supported, then reviewed ambiguous cases with the client’s team. A low fill rate alone was not enough to justify deletion.

The workflow governance plan from the audit review on 18 May 2026
From the project View full size ↗
The workflow governance plan from the audit review on 18 May 2026. These are decision categories for the 39 workflows, not completed deletion totals.

What to look for: some workflows were worth keeping. Others needed a consistent pattern, consolidation, a rebuild or retirement. Cleanup was a set of deliberate decisions.

Explore: why a low fill rate did not mean “delete”Show detailsHide details

During our blueprint review with the client, we confirmed that OrgChartHub fields supported selected key accounts. We retained the cluster for now, despite low overall fill rates.

A real review-state frame showing 7.55% fill and the dependency checks
From the project View full size ↗
A real review-state frame showing 7.55% fill and the dependency checks. The screenshot precedes the agreed retention decision; the creator's name is blurred.

Watch the review process: five minutes of the property workshop condensed into 15 seconds at 20× speed. Silent, with table details blurred throughout.

Open video in a new tab ↗

The lesson: a field can matter to a small part of the business. Check its purpose and dependencies with the client before removing it.

Explore: why we consolidated a dependency chainShow detailsHide details

Our audit identified deal-currency updates that relied on three workflows executing in the correct order. We recommended consolidating them into one workflow with sequential branch logic.

The original audit finding and recommended fix, captured during the roadmap review
From the project View full size ↗
The original audit finding and recommended fix, captured during the roadmap review.
The architecture map we used to review workflow dependencies and consolidation options
From the project View full size ↗
The architecture map we used to review workflow dependencies and consolidation options. Fine labels are blurred so we can show the structure without exposing the detailed configuration.

Watch the map review: 100 seconds condensed into 12.5 seconds at 8× speed. Silent, with fine text blurred throughout.

Open video in a new tab ↗

The lesson: use a controlled sequence where actions depend on one another. Separate modules still make sense for independent jobs. This illustrates the design rationale; it does not quantify a post-fix performance gain.

See the workflow governance planShow detailsHide details
The workflow governance plan from the audit review on 18 May 2026
From the project View full size ↗
The workflow governance plan from the audit review on 18 May 2026. These are decision categories for the 39 workflows, not completed deletion totals.
Explore: key takeaways from the projectShow detailsHide details
  1. Fix the foundation before adding features. ADC did not need another layer of automation; it needed trustworthy data, clear ownership and agreed governance.
  2. Map dependencies before deleting legacy assets. The workflow and property review reduced the risk of breaking live processes while cleaning the portal.
  3. Design around the real sales process. Lifecycle stages, lead views and routing were based on ADC’s operating reality rather than generic CRM conventions.
  4. Training is part of the implementation. Documentation, Loom walkthroughs and a live handover made adoption a deliverable, not an afterthought.
  5. Measure the next chapter honestly. The engagement established the operating and attribution foundation. Revenue uplift has not yet been formally quantified, so this case study focuses on verified process, system and adoption outcomes.

Your next move

Recognise the problem?
Let’s find the gap.

Tell us where things are getting stuck. We’ll look at the journey and work out what needs to change.

Book a discovery call