• Spotter
  • Posts
  • The Hubspot Cleanup Guide

The Hubspot Cleanup Guide

A Practical Audit for Teams Who Actually Use the Platform

By Noah Stambovsky – HubSpot Onboarding Specialist | Creator of Spotter

Introduction

If HubSpot feels like a pile of good intentions tied together by duct tape and overdue tasks, you're not alone.

This guide is here to help you:

  • Pinpoint what's not working

  • Fix what you can this week

  • Automate the stuff you shouldn't be doing manually

It's structured around five essential areas of your portal that, when working properly, help your marketing, sales, and ops teams actually trust the data and focus on revenue.

Let’s start cleaning.

Contact & Company Hygiene

The Problem:

  • Duplicate contacts, incomplete properties, mismatched company records

  • Lifecycle stage says "Customer" but they churned last year

  • Reporting and segmentation are a mess

Quick Audit:

  • Do you have duplicate Contacts and Companies?

  • Are your picklist fields consistent and standardized?

  • Is data like job title, industry, and lifecycle stage complete?

Fixes:

  • Add custom lifecycle stages: "Churned Customer" and "Lost Opportunity"

  • Use deduplication tools and bulk update key fields

  • Sync company data down to contacts with workflows

Pro Moves:

  • Create workflows that:

    • Update lifecycle stages when deals close lost or churn

    • Copy churn/disqualification reasons to company records

    • Set churned/lost contacts to "non-marketing"

Lifecycle Stage Logic

The Problem:

  • Lifecycle stages used like sales statuses

  • Contacts stuck in outdated stages

  • Inconsistent or manual updates ruin reporting

Quick Audit:

  • Are lifecycle changes automated?

  • Are reps manually overriding lifecycle stages?

  • Are leads sitting in "Subscriber" or "Lead" for too long?

Fixes:

  • Separate lifecycle from sales motion (use Lead object or status field)

  • Automate lifecycle transitions based on:

    • Form fills

    • Meeting bookings

    • Deal creation

Pro Moves:

  • Copy key attribution data at MQL conversion (original source, conversion page)

  • Use workflows to disqualify leads and log reasons for future re-engagement

Workflow Chaos

The Problem:

  • Contacts get 3 emails in one day from different workflows

  • Old workflows send alerts to inactive users

  • You don’t know what your workflows are doing anymore

Quick Audit:

  • Are marketing workflows sending duplicate emails?

  • Are internal notifications routing to the right teams?

  • Are workflow names clear and organized?

Fixes:

  • Add "last marketing email" checks before sends

  • Clean up and rename workflows using folder structure

  • Use unenrollment criteria to prevent objects from getting stuck

Pro Moves:

  • Add Slack alerts for skipped steps and errors

  • Build internal-only alert workflows to catch misfires early

Reporting That Doesn’t Lie

The Problem:

  • Reports filtered by wrong date fields

  • Multi-select properties duplicate rows

  • Sales dashboards show dead deals as live

Quick Audit:

  • Are reports built on created date instead of close date?

  • Are reps filtered by name or role?

  • Are you using lifecycle as a funnel stage AND sales status?

Fixes:

  • Use rolling date filters (e.g. "last 30 days")

  • Replace multi-select fields with workflow-mapped dropdowns

  • Standardize reporting filters across teams

Pro Moves:

  • Report on average and median time in deal stages

  • Use pivot tables in custom reports to correlate source and conversion

  • Create lifecycle snapshot fields for historical trend reporting

Automation That Actually Helps

The Problem:

  • Leads routed manually

  • No follow-up tasks triggered on deal stage changes

  • No way to re-engage churned or disqualified leads

Quick Audit:

  • Are follow-ups automated?

  • Are tasks created when deals advance?

  • Are there workflows based on disqualification or churn reason?

Fixes:

  • Automate lead assignment, follow-ups, task creation

  • Build a nurture path based on disqualification reasons

  • Delay redundant internal notifications using checkbox logic

Pro Moves:

  • Trigger re-engagement 90 days after disqualification

  • Automatically create a Deal when a Lead is Qualified

  • Sync events/conversions to ad platforms using Ads > Events tool

Ready to Tidy Up?

You don’t need to fix everything at once. Start with one section.

And if you want help from someone who knows the inside of HubSpot like a mechanic knows an engine:

If you have a specific HubSpot question, feel free to email me.

Spotter is brought to you by Modern Driven Media.