Tag: lead scoring

  • How to Clean Up HubSpot Data: A Step-by-Step Guide

    HubSpot data cleanup is the process of auditing your CRM, backing it up, fixing properties and formats, merging duplicates, filling gaps, tidying lists and deals, and putting rules in place so bad data stops coming in. Done in that order, it turns a CRM people work around into one they trust.

    You probably know the symptoms. The same company appears three times with different spellings. Half your contacts have no owner or lifecycle stage. Reports disagree with each other, lead scores look random, and reps keep a private spreadsheet because they don’t trust the CRM. Almost every other RevOps project, from forecasting to attribution to automation, depends on getting this right.

    This guide walks through a practical cleanup sequence, with the HubSpot tools that help at each step.

    Before you start: define clean and protect yourself

    “Clean” means different things to different teams, so decide what you’re fixing. Pick the ten or so fields that drive decisions, such as lifecycle stage, owner, lead source, industry, company size, country, email, deal amount, close date, and closed-lost reason. Then name one owner for the project and agree with sales and marketing on a quiet window, so people aren’t editing records while you merge them.

    Also be careful with irreversible actions. In HubSpot, merged records cannot be reverted, so treat every merge as final. You can roll back rejected duplicate pairs for a limited time, but not merges. A backup is your safety net.

    Step 1: Audit what you have

    Start with HubSpot’s data quality tools, found under Data Management, then Data Quality. The overview page summarizes duplicate issues, formatting issues, and enrichment gaps, and the property insights show where properties are unused, empty, or duplicated. Set up the weekly data quality digest while you’re there, so changes show up in your inbox. Then build your own scorecard.

    Check How to find it Why it matters
    Duplicate contacts and companies Manage duplicates tool, plus exports Splits history, inflates counts, breaks reports
    Contacts with no owner or lifecycle stage A saved filter or list Leads go unworked; funnel reports are wrong
    Contacts with no company association A filter on associated company Account-level reporting and scoring fail
    Formatting problems Data quality formatting issues Breaks segmentation and personalization
    Empty key fields Property insights and filtered views Lead scoring and routing lack inputs
    Unused or duplicate properties Property insights Clutter and confusion
    Stale deals Open deals with past close dates Inflates pipeline and distorts the forecast

    Step 2: Back up before you change anything

    Export contacts, companies, deals, and any other objects you plan to touch, including the properties you’ll edit. Record the counts for each object. Export your lists and workflows’ configuration notes too, since you’ll want to know what depends on what. Store the files somewhere the team can find them, and keep them until the cleanup has been validated.

    Step 3: Fix the structure first

    Cleaning records before fixing the properties underneath them means doing the job twice. Review your properties for these issues:

    • Free text where a dropdown belongs. “USA,” “U.S.,” and “United States” are the same value to a human and three values to a report.
    • Duplicate or overlapping properties, such as two fields for lead source.
    • Unused properties with no data and no dependencies.
    • Unclear names and missing descriptions, which lead people to guess.

    Before you delete or merge any property, check where it’s used in workflows, lists, forms, and reports. For guidance on when to create your own, see our explanation of custom vs. default properties.

    Step 4: Standardize formats and values

    The data quality tool flags formatting issues, such as a name stored as “LORELAI GILMORE” that should read “Lorelai Gilmore,” and you can accept or reject its suggestions individually or in bulk on eligible plans. Data Hub Professional and Enterprise also let you set automation so new records with the same issue are fixed automatically. One caveat from HubSpot’s documentation: if a record is later overwritten, for example by an API or integration, with the same bad format, the tool may not flag it again, so fix the source too.

    For values that need consolidating, such as country names, industries, and job titles, use bulk edit or a cleaned import file to map the variants to one standard value. Then change the property to a dropdown so the problem doesn’t return.

    Step 5: Deduplicate carefully

    HubSpot’s duplicates manager compares record properties and surfaces likely pairs, with a daily scan. By default, contacts are compared on properties like name, email, phone, and company name, and companies on domain, name, country, and similar fields. Eligible plans can create custom rules with their own matching criteria. Work in this order:

    1. Companies first. Merging companies consolidates the contacts and deals attached to them, which makes later contact merges cleaner.
    2. Contacts next. Email is the usual unique identifier.
    3. Deals last, reviewing any that look like repeats of the same opportunity.

    Test on a small batch and review associated records before you merge in bulk. Use the similarity score to prioritize, and when you reject a pair, remember that it won’t reappear unless one of the records changes. Decide your merge rule in advance, such as keeping the record with the most recent engagement or the oldest create date, so you keep the best data and the original source.

    Step 6: Fill the gaps

    • Owners: assign owners to unowned records, using routing rules where possible.
    • Lifecycle stage: fix blanks and wrong values, using your agreed definitions. Our guide to HubSpot lifecycle stages explains the rules and the forward-only behavior to plan around.
    • Company associations: associate orphaned contacts with companies, by domain where it’s reliable.
    • Enrichment: the data quality tool shows enrichment coverage by property, which helps you see which fields enrichment can fill.
    • Required fields: make the key fields required on forms and, where your plan supports it, on deals.

    Step 7: Clean your lists, contacts, and deals

    Lists. Audit your lists for stale static lists, duplicates, and unused ones. Consider whether a static list should be an active one that updates itself, and check dependencies before deleting. Our post on active vs. static lists covers when to use each.

    Contacts. Review hard bounces, unsubscribes, and long-unengaged contacts. If you pay by marketing contacts, setting unengaged ones to non-marketing can reduce cost, and archiving or deleting old records should follow your retention and consent policy.

    Deals. Find open deals with past close dates, no amount, or inactive owners, and close, update, or reassign them. Make closed-lost reason a required dropdown. See our guide to HubSpot deal stages for the stage rules that keep pipelines honest, and deal slippage for why stale close dates matter.

    Step 8: Recheck scoring, routing, and reports

    Cleaning changes the inputs to your automation. After the cleanup, review your lead scoring model, since fit scores depend on filled-in fields like industry and company size. Retest routing rules, and spot-check key reports against your pre-cleanup exports. If you’re also planning a platform move, finish the cleanup first, as our Salesforce to HubSpot migration checklist explains.

    A before-and-after snapshot

    Track a handful of measures so you can show the result. These numbers are illustrative.

    Measure Before After 30 days
    Duplicate contact pairs 4,100 150
    Contacts with no owner 9,800 600
    Contacts with no lifecycle stage 12,500 1,200
    Companies missing industry 35% 12%
    Open deals with past close dates 240 20
    Unused properties 112 of 380 20 of 270

    Step 9: Stop the mess from coming back

    • Prevent at the source. Use dropdowns, required form fields, and validation instead of free text.
    • Automate formatting on new records, where your plan allows.
    • Control imports. Use a checklist: clean the file, match on a unique identifier, map fields deliberately, and test a small batch.
    • Review integrations. Check which system writes each field and whether syncs create duplicates.
    • Limit who can create properties and edit key fields.
    • Keep a data dictionary with each property’s meaning, owner, and allowed values.
    • Review quarterly. Use the data quality digest and add the check to your RevOps meeting cadence.

    Mistakes to avoid

    • Merging in bulk with no backup and no test batch
    • Cleaning records before fixing properties and dropdowns
    • Deleting properties or lists that workflows and reports still use
    • Fixing formats in HubSpot while an integration keeps writing bad values
    • Running the cleanup during active campaigns or pipeline reviews
    • Treating it as a one-time project with no owner
    • Deleting contacts without checking consent and retention rules

    Summary

    HubSpot data cleanup works best in a fixed order: define what clean means, audit with the data quality tools, back up, fix properties and dropdowns, standardize formats, deduplicate companies then contacts then deals, fill gaps in owners, lifecycle stages, and associations, clean lists, contacts, and deals, and then recheck scoring, routing, and reports. Because merges can’t be undone, test small batches and keep exports.

    The cleanup only lasts if you prevent the mess at the source with dropdowns, required fields, automated formatting, import controls, integration reviews, and a data dictionary, then review the results every quarter. Track a few before-and-after measures so the effort is visible.

    FAQ

    What is HubSpot data cleanup?

    It’s the process of auditing and fixing your CRM data: merging duplicates, standardizing formats, filling gaps, tidying lists and deals, and adding rules so errors don’t come back.

    Can I undo a merge in HubSpot?

    No. Merged records cannot be reverted. You can undo a rejected duplicate pair for a limited time, so back up and test on a small batch before merging in bulk.

    Where are HubSpot’s data quality tools?

    Under Data Management, then Data Quality. They cover duplicates, formatting issues, enrichment, and property insights. Some capabilities, such as custom duplicate rules and formatting automation, require Data Hub Professional or Enterprise.

    How does HubSpot find duplicates?

    It compares property values on a regular scan, such as email, name, and phone for contacts and domain, name, and country for companies, and assigns similarity scores. Eligible plans can create custom matching rules.

    How often should we clean our HubSpot data?

    Run a full review at least quarterly, and use the weekly data quality digest and automation to catch issues in between. After a migration, a large import, or a new integration, check sooner.

    Should I delete or keep old contacts?

    It depends on your retention and consent policies and applicable privacy rules. Many teams suppress or set unengaged contacts to non-marketing first, then delete according to a documented policy. Check with legal if unsure.

    Do I need to clean data before migrating or adding AI tools?

    Yes. Migrations, scoring, and AI features all inherit the quality of the data underneath them, so cleanup first is cheaper than fixing the same problems in a new system.

    Who should own data quality?

    Usually RevOps owns the standards, tooling, and reviews, while sales, marketing, and customer success own the accuracy of the data they enter. Name one accountable person.

  • AI vs. Automation in Sales: What’s the Real Difference?

    Automation follows rules you set in advance: if a lead fills out a form, route it to a rep. AI makes judgment calls with incomplete information: it reads a reply, weighs context, and decides what to do next. Automation executes a process; AI reasons through one.

    If you’ve sat through a sales tool demo in the last year, you’ve probably heard “AI” used to describe something that’s really just automation with a new label. Honestly, a lot of vendors do this on purpose, because “AI” sells better than “workflow.” That’s not a knock on automation itself. It’s genuinely useful. But if you can’t tell the two apart, you’ll end up buying the wrong tool for the problem you actually have.

    What is sales automation?

    Sales automation is software that handles repetitive sales tasks like lead routing, email follow-up sequences, pipeline updates, and activity logging. Think of it as a set of if/then instructions running in the background of your CRM.

    A simple example: a lead fills out a form on your website, automation assigns them to the right rep based on territory, sends a confirmation email, and logs the new record in your CRM. The steps never change. The logic was decided once, during setup, and the system keeps executing it the same way every time.

    This matters because reps don’t spend most of their week selling. Surveys such as Salesforce’s State of Sales research have consistently found that selling is a minority of a rep’s time, with the rest going to data entry, admin, and internal work. Automation exists to claw some of that time back.

    What is AI for sales teams?

    AI (artificial intelligence) is software that can interpret unstructured information, like the wording of an email reply or a prospect’s behavior on your site, and make a judgment call instead of following a fixed rule. Where automation needs someone to rewrite its rules before its behavior changes, AI can adjust to new information without anyone touching the configuration.

    So instead of “if lead replies, send email #2,” an AI-driven tool might read the reply, notice the prospect mentioned a competitor, and decide to escalate the lead to a human rep instead of continuing the sequence. That’s a decision, not just an execution.

    This is also where the newer term “AI agent” comes in. An AI agent goes a step further: it pursues a goal across multiple steps (research a buyer, draft a message, check for intent signals, follow up) and adapts at each one based on what it learns along the way.

    How are AI and automation actually different?

    Automation AI AI agent
    How it decides Follows rules you wrote Weighs context using a model Pursues a goal and chooses its own actions
    Same input, same output? Yes Not always Not always
    Handles messy input Poorly Well, for classifying and drafting Well, but needs guardrails
    Changes behavior When someone edits the rules As data and context change As results come in, within set limits
    Typical sales use Routing, logging, reminders Scoring, reading replies, call summaries, drafting Research, outreach, follow-up, scheduling
    Main risk Breaks when a prospect goes off-script Confident mistakes Actions taken at scale without review

    A good way to picture it: automation is a conveyor belt, and AI is closer to a person deciding, case by case, what belongs on the belt in the first place. In practice, real tools sit on a spectrum, from fixed rules, to scoring models, to generative drafting, to agents. The label matters less than where a given feature lands.

    One prospect reply, three different responses

    Say a prospect replies to your outbound email: “Interesting, but we’re also looking at a competitor, and our budget closes in March. Could you send pricing for 40 seats?”

    • Automation sees a reply, stops the sequence, and creates a task for the rep. It can’t tell that this reply is different from “unsubscribe me.”
    • AI reads the message, tags it as pricing interest with a competitor mention and a deadline, bumps the lead’s priority, and drafts a response for the rep to edit.
    • An AI agent might also pull account details, assemble a pricing outline, propose meeting times, and loop in an account executive, with a person approving anything customer-facing.

    All three are useful. They just solve different problems, and the second and third carry a risk the first doesn’t: they can be wrong in ways that look reasonable.

    Where each one belongs in a sales process

    Task Best fit Why
    Logging calls and emails to the CRM Automation Same steps every time
    Routing a lead by territory Automation A rule you can write in one sentence
    Reminding reps about stale deals Automation A clear threshold, such as 30 days without activity
    Scoring leads on behavior and history AI Many signals and shifting patterns
    Reading a reply and flagging intent AI Unstructured text
    Drafting a first-touch email AI with human review Needs context and tone
    Researching an account and planning outreach AI agent, supervised Multi-step work that is costly if wrong
    Approving discounts Automation plus a person A policy rule with a named approver

    The default should be automation. Reach for AI only where a human would normally stop and think: scoring a lead, prioritizing an account, or deciding how to respond to an unusual objection. If you can write the rule in a sentence, you probably don’t need AI for it.

    A reality check on the hype

    Two Gartner findings are worth keeping in mind, and both come with caveats.

    First, Gartner estimated in mid-2025 that only about 130 of the thousands of vendors marketing “agentic AI” were real, and it described the rebranding of existing assistants, RPA, and chatbots as “agent washing.” It also predicted that more than 40% of agentic AI projects will be canceled by the end of 2027 because of cost, unclear value, or weak risk controls, while forecasting that 33% of enterprise software applications will include agentic AI by 2028, up from under 1% in 2024. Those are forecasts, not outcomes. The takeaway is that adoption is rising fast, and plenty of projects are misapplied.

    Second, a Gartner survey of 1,026 B2B sellers, fielded in early 2024, found that sellers who effectively partner with AI tools were 3.7 times more likely to meet quota. Two cautions. It’s a correlation tied to how skillfully sellers work with AI, not proof that a particular tool causes the result, and it doesn’t compare AI with automation. The same survey found that half of sellers felt overwhelmed by the amount of technology they use, and overwhelmed sellers were 45% less likely to attain quota. More tools is not the lesson.

    Pro tip: when a vendor says “AI,” ask whether the tool’s next move changes if the input changes unexpectedly. If a lead replies with a question instead of a yes and the system just continues down the same script, you’re looking at automation with a new coat of paint.

    Why this distinction matters for your team

    Here’s the practical risk: if you buy an AI tool expecting judgment and it’s actually automation, you’ll end up with a system that’s either too rigid for real sales conversations or constantly needs manual override. Neither saves time.

    The reverse mistake costs money. Using AI for stable, repeatable steps like updating deal stages adds expense and unpredictability where a simple rule would do. Pairing the right tool with the right task is most of the value.

    If you’re deciding where AI fits in your own sales motion, two good starting points are tasks reps already dislike: summarizing calls and drafting follow-ups. We’ve written up what AI call summarization does for sales teams, an honest look at what AI can and can’t do for sales email drafting, and a guide to AI lead scoring. For the agent end of the spectrum, see what an AI SDR is.

    A quick checklist: automation or AI?

    When you’re evaluating a tool or process, run through these questions:

    1. Does the task follow the same steps every time, regardless of context? If yes, that’s automation territory.
    2. Does it require weighing information that changes case by case (tone of a reply, buying signals, deal risk)? That points to AI.
    3. Can you write the rule as an if/then statement in one sentence? If you can, you probably don’t need AI for it.
    4. Would a human normally pause and think before acting? If so, it’s a decision, not an execution step, which points toward AI.
    5. What happens if the input is slightly unusual? If the system continues on script, it’s automation no matter what the label says.

    Before you buy, add three vendor questions. What does it do when the input is unexpected? Can you see why it made a decision? And when it’s wrong, who finds out, and how quickly?

    Most GTM (go-to-market) tech stacks end up needing both. We’ll cover how the two fit together across a full sales process in our broader guide to AI for sales teams, if you want the bigger picture before picking individual tools.

    Mistakes to avoid

    • Buying on the label. “AI-powered” in a demo tells you nothing about whether the tool decides anything.
    • Using AI where a rule would do. It adds cost and variability to steps that should be boring.
    • Skipping human review on customer-facing output. Confident mistakes are the main failure mode of AI.
    • Adding tools faster than reps can absorb them. Overwhelmed sellers perform worse, not better.
    • Automating a broken process. A faster bad process is still a bad process.

    Summary

    Automation runs rules you wrote in advance and does the same thing every time, which makes it ideal for stable steps like routing, logging, and reminders. AI interprets messy information and makes judgment calls, which suits scoring leads, reading replies, summarizing calls, and drafting messages. AI agents go further by pursuing a goal across several steps, and they need the most supervision.

    Default to automation, and use AI where a human would normally stop and think. Be skeptical of labels: Gartner has described widespread “agent washing” and forecast that many agentic projects will be canceled, and its 3.7x quota finding is a correlation about how sellers use AI, not a verdict on any tool. Test vendors by asking what the tool does with unexpected input, whether you can see its reasoning, and what happens when it’s wrong.

    FAQ

    Is AI just a more advanced form of automation?

    Not exactly. Automation is rule-based, and someone has to rewrite its rules before its behavior changes. AI can adjust to new data on its own. They’re related, but they solve different problems.

    Do I need AI if I already use sales automation?

    Not necessarily. If your biggest time sink is manual data entry or inconsistent follow-up, automation alone may fix it. AI earns its keep when the bottleneck is judgment, not just repetition.

    What’s an AI agent, and is it different from regular AI?

    Yes. A basic AI feature might score a lead or summarize a call. An AI agent pursues a goal across multiple steps, like researching a buyer, drafting outreach, and adjusting timing, without someone defining every rule in advance.

    How do I know if a tool marketed as “AI” is automation in disguise?

    Ask whether its next action changes meaningfully when the input is unexpected. If an odd reply doesn’t change what the system does next, it’s running a script, not making a decision.

    Can automation and AI work together on the same sales process?

    Yes, and for most teams that’s the realistic setup. Automation handles predictable steps like CRM updates and sequencing, while AI handles the parts that need context and prioritization.

    Does using AI guarantee better quota attainment?

    No. Gartner found that sellers who effectively partner with AI tools were far more likely to meet quota, but that’s a correlation tied to skill and use. The same research found that tool overload hurt performance, so fewer, well-used tools beat a crowded stack.