Case study

From hand-built spreadsheets to reports that come straight from the data

A small team of policy researchers around a table covered in printed reports and a laptop

A US university policy research center that works with state leaders and legislators and runs events and policy academies.

Education & NonprofitHubSpot auditCRM clean upDocumentation
Everycontact with a state leader now logged, and a live dashboard in place of the old spreadsheet
1place for every engagement, run as deals instead of stuck in email, and outreach tracked in HubSpot instead of counted by hand
169custom properties, many for the same thing, cut back to one trusted field for each
Sound familiar?The person who set up your CRM has left, nobody wrote anything down, and every report is built by hand in a spreadsheet.
The situation

Nobody knew what was true

The previous marketing team had moved on and left no notes. Nobody knew which tools to use, which data was right or which lists to send to. Reporting was done completely by hand, because there was no way to track outreach to state leaders in HubSpot. Our audit found 11,965 contacts with no owner, over 2,000 duplicates, 6,028 bounced contacts still counted as marketing contacts, and 169 custom properties.

What we did

Audit first, then rebuild and write it down

1

Audited everything

Data, users, email, forms, events and integrations, with a plan in order of impact.

2

Cleaned the data

Properties, duplicates, marketing contacts, users and security.

3

Built what they track

An Engagements pipeline, and outreach tracked with HubSpot's leads object, so every contact with a state leader is logged. Issue areas cut from 75 to 14, and 2 playbooks to log outreach the same way every time.

4

Wrote it down

An SOP and data dictionary so the next team doesn't start from zero, plus plenty of hands-on training so the team uses it day to day.

What changed

Before and after

Before

  • No notes from the last team
  • 11,965 contacts with no owner
  • Reporting done by hand
  • Lists nobody trusted

After

  • A written SOP and data dictionary
  • Clean, owned records
  • Outreach tracked in HubSpot
  • Reports built from live data
The result

One setup the whole team understands

Reporting used to be done fully by hand. Now outreach and engagements with state leaders are tracked in HubSpot the same way every time, so the reports come straight from the data. The team knows which data is right and which lists to send to. When people change, the SOP means the knowledge stays.

What this means for you

Why it matters

The team stops guessing. Everyone works from the same trusted data, reports come straight from HubSpot, and when people leave, the knowledge stays.

TransparencyLeaders see every engagement as it happens, not in a quarterly spreadsheet.
One source of truthOne field for each thing, and one list to send to.
ContinuityAn SOP and data dictionary, so the next person isn't starting from zero.
Ready for AIAI tools can only give good answers from clean, labeled data.
Tools used
HubSpot Marketing HubHubSpot Sales HubPlaybooksWorkflowsDashboards

Sounds like your setup?

Tell us what's going on. We'll show you where the quick wins are on the first call.

Book a call