Royce Johnson
← All work

Case study 01 · Global Transportation Company

Enterprise CRM Transformation

Restructuring years of CRM complexity into a cleaner, more usable HubSpot environment for marketing, sales, account management, and Meetings & Events operations.

Focus
HubSpot · CRM Architecture · RevOps · Data Operations · Automation
Role
Hands-on architecture, mapping, configuration, validation, coordination, and implementation

The operating challenge

Complexity had accumulated across the revenue stack.

A global transportation organization had accumulated years of complexity across legacy tools, duplicate Company records, disconnected operating workflows, inconsistent lifecycle data, and manual processes.

Before configuration could begin, the business logic behind those processes had to be understood: what information mattered, how records related, where ownership changed, and how work moved between teams.

The assignment was to turn that operating reality into a CRM environment people could actually use.

How the work progressed

From legacy operations to revenue operations.

01

Legacy Operations

Understand the operating logic, dependencies, and information held outside the CRM.

02

Data Mapping

Translate legacy fields and relationships into a governed CRM data structure.

03

CRM Architecture

Define objects, properties, associations, lifecycle structure, and ownership.

04

Operational Pipeline

Reconstruct Meetings & Events work as a usable stage-based process.

05

Workflow Automation

Route inquiries, assign ownership, and trigger the right operational actions.

06

Revenue Operations

Support campaign execution, attribution, and trusted operational reporting.

Architecture

One connected operating model.

Operational data moved through a deliberate transformation layer into structured CRM records, then into the workflows and reporting used by revenue teams.

Operational data sources
Data integration & transformation
HubSpot CRM
Contacts · Companies · Accounts · Deals
Operational workflows · Marketing · Sales
Reporting & revenue operations

Integrations were delivered collaboratively with the client’s technical teams; my work focused on mapping, validation, and the HubSpot side. HubSpot remained the operating source of truth.

Four core workstreams

01

Clean the CRM

Investigated duplicate and shell Company records while preserving the relationships revenue teams relied on. The work combined deduplication processes, domain-based enrichment, association review, and practical data governance.

Company deduplicationRelationship preservationAccount associationsData governance

02

Connect the data

Mapped recurring operational source data into HubSpot so contacts, companies, ownership, and lifecycle segments could support day-to-day CRM operations. I owned the mapping and validation, working alongside the client’s technical teams, who managed the integration itself. Imports and synchronization were validated at production scale.

Property mappingLifecycle segmentationOwnership mappingImport & sync QA

03

Rebuild operations in HubSpot

Studied an existing Meetings & Events process, then reconstructed its business logic inside HubSpot. The result was a working operating process—not just a new pipeline—shaped around how the team moved requests from intake through resolution.

Operational Deal pipelineCustom properties & formsShared inbox & viewsDocumentation & enablement

04

Activate revenue workflows

Connected the stronger CRM foundation to lifecycle marketing, sales sequences, task creation, event execution, campaign reporting, and attribution support—giving revenue teams a more coherent way to act on the data.

Lifecycle marketingSales tasks & sequencesCampaign executionOperational reporting

Implementation evidence

What I actually built.

The work extended from data architecture through the operating experience used by teams every day. Client screens and records remain private.

01

CRM Architecture

Data model, properties, object relationships, and lifecycle structure

02

Data Operations

Mapping, imports, synchronization QA, deduplication, and governance

03

Operational CRM

Meetings & Events pipeline, custom fields, forms, views, and shared inbox

04

Automation

Routing workflows, lifecycle automation, sales tasks, and sequences

05

Revenue Operations

Campaign reporting, attribution support, and operational reporting

Selected impact

Verified project evidence.

Results are presented conservatively and reflect documented implementation and campaign records.

27,067

Contact records updated in production

0

Failures during the production backfill

$700K

Closed Won associated with the GBTA campaign

Campaign context: 210 contacts across 62 companies, resulting in 21 replies, 9 meetings, 4 deals, and 1 Closed Won deal associated with approximately $700K.

Next step

Facing similar CRM or RevOps complexity?

If your HubSpot environment has outgrown how your teams actually work, I’m happy to talk through where to start.

Start a conversation →