CRM data quality

Do you need a CRM data quality consultant, or a tool?

Bad CRM data is rarely a matching problem. It is usually an ownership problem that a tool cannot see.

The short answerA CRM data quality consultant measures how bad the data is, fixes the records that matter, and puts rules in place so they stay fixed. Tools handle matching, merging and enrichment at volume. They cannot decide which fields matter, who owns a record, or what a stage means, which is where most bad data starts. Sapwood begins with a free read only audit that counts duplicates, missing owners, blank sources and stage gaps, priced by what each costs a year.

Which four counts show how bad it is?

  • Duplicate rate. The share of companies that exist more than once. The free duplicate checker gives you this from an export.
  • Records without an owner. Contacts and companies nobody is responsible for, which nobody will ever follow up.
  • Blank original source. New records with no source, which is why attribution reports come back empty.
  • Stage gaps. Open deals missing the fields their stage requires, which is why the forecast needs a spreadsheet beside it.

If any one of these is above ten percent, reporting built on the CRM is already wrong in ways that cost money. The audit checklist shows how to run all four in an afternoon.

What does a consultant do that a tool cannot?

A deduplication or enrichment tool needs rules before it can help. Which domain is the matching key, which record survives a merge, which fields enrichment may overwrite, and who owns the result. Those are decisions about how your business runs, and they have to be made before the tool is switched on.

The consultant also finds where bad data comes from. A form that creates a new company every time, an integration writing to the wrong field, a lifecycle stage two teams define differently. Fixing the source is what stops the cleanup from needing to be repeated next quarter. Our comparison of CRM data quality tools covers which ones are worth adding once the rules exist.

How does the cleanup run?

Four weeks for most mid market CRMs
WeekWorkWhat you get
1Read only audit of records, fields, sources, stages and integrationsA written report ranked by what each gap costs a year
2Merge rules agreed, then duplicates merged in priority orderOne record per company, with history kept
3Owners, sources and required stage fields filled where they matterRecords somebody is accountable for
4Rules at creation: duplicate checks, validation, required fields, routingData that stays clean after we stop

On one rebuild for a 22 person team, that meant 148,000 records corrected, one record per company, and duplicates blocked at creation rather than cleaned up later. The full write up has the detail.

What does CRM data quality work cost?

Scoped CRM cleanups and rebuilds commonly run $10,000 to $25,000 or more, depending on data volume and how many teams are involved. Sapwood covers the work inside the $4,000 a month retainer, with the audit first and free. See typical RevOps consulting fees for the wider market.

Questions

What does a CRM data quality consultant do?

Measures how bad the data is, fixes the records that matter, and puts rules in place at creation so the CRM stays clean, including the ownership and stage definitions a tool cannot decide.

Should we buy a data quality tool first?

Usually not. A tool needs merge rules, matching keys and field ownership decided first. Buying it before those exist tends to automate the mess.

How long does a CRM cleanup take?

About four weeks for most mid market CRMs: an audit, merges in priority order, owners and required fields, then rules at creation.

How much does CRM data cleanup cost?

Scoped cleanups commonly run $10,000 to $25,000 or more. Sapwood covers it inside a $4,000 a month retainer after a free audit.

Do you work in HubSpot and Salesforce?

Yes. The same method applies in both, and in the sync between them when both are in use.

Want to talk it through?

Leave an email and I will reply myself, usually the same day. No sequence, and no calendar link unless you ask for one.

One reply from a person. Nothing else.

Got it. You will hear from hello@sapwood.io.

Would rather just book time? Here is the calendar.