RevOps byTom Schoorstra.
All case studies·HR Software50-200 employees

From scattered deals to full customer visibility

With no central customer record, historical data was lost with every renewal. A custom License object now ties everything together.

Up to 1 year
Forecast horizon
~0% faster
Reporting time
Complete
Customer visibility
Now possible
Churn tracking

The problem

Challenge

The team worked entirely from deals, with no overarching customer record

Every renewal meant duplicating a deal, losing historical context

No way to see total customer value, track churn risk, or forecast renewals

How we solved it

Approach

01

Step 1

Analyzed how customer data flowed through the existing deal structure

02

Step 2

Designed a custom License object as the central customer record

03

Step 3

Planned integrations with the backend to pull in product usage data

04

Step 4

Built a migration path for existing customer data

The build

Solution

Created a License object that connects to all related deals: new, renewal, upgrade, and churn
Integrated with the backend via Zapier to sync user activity and roles
Built reporting for ARR, contract value, and Monthly Active Users per customer
Enabled renewal forecasting based on license end dates

Technologies used

Stack

HubSpotZapierCustom objectsBackend integration

Want similar results in HubSpot?

Whether it's automating manual processes, cleaning up your CRM, or building custom integrations — let's talk about what HubSpot can do for your team.