Skip to content
Shows/RevOps 101
RevOps 101·Episode 1·Series

The Anatomy of a CRM Data Model

Objects, associations, and why structure decides everything

Jan 8, 2026·27:00·Paul Maxwell

Video coming soon

No YouTube video has been added yet.

Your browser does not support the audio element.

About this episode

A ground-up tour of how contacts, companies, deals, and custom objects relate inside a modern CRM, and why the data model quietly determines what reporting and automation you can ever build. Paul walks through the associations that make or break a RevOps foundation.

Key ideas

  • 01A CRM is a model of your revenue motion, not a contact filing cabinet
  • 02Associations determine what you can report on more than fields do
  • 03Reach for a custom object only when a property can't carry the relationship
  • 04Misplaced deal data on contacts silently corrupts pipeline reporting

Show notes

What we covered

Every reporting headache and broken automation eventually traces back to the same place: the data model. In this opener for RevOps 101, Paul lays out how a CRM actually stores your revenue reality and why getting the object relationships right up front saves years of cleanup later.

In this episode

  • The four core objects most CRMs share and what each is really for
  • Why associations, not fields, define what you can report on
  • When to reach for a custom object versus a property
  • Common modeling mistakes that quietly cap your reporting
  • A simple test for whether your model matches your revenue motion

Links & resources

  • RevOps Data Model Poster (downloadable reference)
  • HubSpot object and association documentation
  • Paul's field-vs-object decision checklist

Timestamps

Chapters

  1. —Why the data model matters
  2. 4:00The four core objects
  3. 11:20Associations over fields
  4. 18:00Custom object or property?
  5. 23:00Modeling mistakes to avoid

Quotable

“Associations are where the leverage is. Get them right and you can answer questions you never planned for.”

— Paul Maxwell

Full transcript

Transcript~1 min read

Show transcriptHide transcript

Paul: People think a CRM is a place to store contacts. It isn't. It's a model of how your business actually makes money, and every field you add is a claim about that model.

Paul: So before you create a single custom property, ask what object it really belongs to. Is this a fact about a person, a company, or a deal? Because if you put deal-level data on a contact, your pipeline reporting will lie to you six months from now.

Paul: The associations are where the leverage is. A well-associated model lets you answer questions you didn't even plan for. A poorly associated one means you're exporting to spreadsheets forever, reconciling by hand, and never quite trusting the number.

Mentioned

  • HubSpot
  • Salesforce

Related links

  • HubSpot associations documentation

Hosts

  • PM
    Paul Maxwell

    Host

    CEO, RevOps HQ

Topics

  • CRM Strategy
  • Data Modeling
  • Revenue Operations

Downloads & resources

  • RevOps Data Model PosterPDF

Subscribe to RevOps 101

  • YouTube
  • Spotify
  • Apple Podcasts

Related episodes

RevOps 101Reporting You'll Actually TrustMost dashboards get built, admired once, and ignored. Paul explains how to build revenue reporting people trust enough to make decisions on, starting with clean definitions and a single source of truth.
RevOps 101Lead Handoff Without the LeaksLeads die in the seams between marketing, SDRs, and account executives. Paul breaks down a leak-proof handoff: clear ownership, defined stages, and automation that enforces the rules instead of relying on good intentions.
RevOps 101Automation That Doesn't Hide the ProcessAutomation should remove toil, not bury your process in a black box nobody can explain. Paul shares principles for building workflows that stay legible, auditable, and safe to change.
Modern Revenue LeaderRebuilding the Revenue Org Around One Source of TruthMaria Alvarez joins Paul to tell the story of rebuilding a fractured revenue organization around a single source of truth, and the political and technical work that unification actually required.