Revenue operations

RevOps data management. The ownership model behind trustworthy numbers.

RevOps data management is the discipline of keeping revenue data accurate, complete, consistent and current: deduplicating records, standardising fields, enriching thin ones, and auditing the database on a fixed cadence. Gartner's 2020 research put the average cost of poor data quality at 12.9 million dollars a year per organisation, which is why this needs to be a routine, not a side project.

The short answer. Data management is a cadence, not a clean-up.

RevOps data management is the set of routines that keep a revenue database usable: deduplication, field standardisation, enrichment of thin records, and a named owner accountable for each data domain. Most teams already own a version of this, a spreadsheet macro here, an annual clean-up sprint there, but it rarely gets run as a discipline with its own cadence and owner, which is exactly why the same duplicate leads and stale fields tend to reappear eighteen months after the last clean-up.

Gartner's 2020 research into data quality, based on a survey of 154 reference customers across sixteen data quality vendors, put the average financial cost of poor data at 12.9 million dollars a year per organisation, driven by delayed decisions, wasted marketing and sales spend, and reporting errors that send a team chasing the wrong number. Our guide to why the CRM has to be RevOps' single source of truth covers the system-level case for this. This piece is about the operational practice: what actually keeps the data inside that system reliable once the system itself is built correctly.

How it works in practice. Four data quality dimensions worth measuring separately.

"Clean data" is too vague a target to manage against, so the practical version breaks it into four dimensions, each with its own check. Accuracy asks whether a field's value is actually correct, a job title, a company size, an email address that still reaches someone. Completeness asks whether the required fields are filled in at all, not whether what's there is right. Consistency asks whether the same thing is recorded the same way everywhere, "SaaS" in one record and "Software as a Service" in another break every segmentation report built on top of them. Timeliness asks whether a record still reflects reality, a contact who left the company eight months ago but is still logged as the champion on an open deal.

Each dimension needs a different fix. Accuracy and timeliness respond well to enrichment tools that cross-check a record against an external data source and flag drift. Completeness is mostly a CRM configuration problem, solved with required fields and validation rules at the point of entry rather than a clean-up after the fact. Consistency is a governance problem: a picklist instead of a free-text field, and a naming convention documented somewhere a new hire can actually find it.

Field-level ownership is what stops these four dimensions drifting apart again. A single named owner per data domain, deal data, account data, contact data, is accountable for that domain's quality even though sales, marketing and customer success all touch it day to day. When three departments share a field with no single owner, in practice nobody treats it as theirs to fix, and it decays until a forecast meeting exposes the gap.

A working cadence. Five routines, run on a fixed schedule.

  1. Weekly: automated duplicate and decay flags. Run standard deduplication rules on new records and flag contacts that have gone quiet on email, bounced, or shown no activity for a set period, for someone to review rather than auto-delete.
  2. Monthly: required-field completion check. Pull a report of records missing a required field past the stage where that field should exist, and route it back to the owning team rather than letting incomplete records simply age in the pipeline.
  3. Quarterly: full database audit. Measure duplicate rate, completion rate against required fields, and the proportion of contacts with no activity in the last two quarters, against the same benchmarks every time, so the trend line means something.
  4. Quarterly: governance review. Check whether any new custom fields, picklists or integrations have been added outside the agreed process, a common source of the consistency problem described above.
  5. Annually: enrichment source review. Confirm the enrichment or verification tool the team relies on is still returning accurate matches, since a source that quietly degrades in coverage can make a database look cleaner than it actually is.

None of this needs to be expensive tooling from day one. A team without budget for a dedicated deduplication platform can run the weekly and monthly steps from CRM-native reports and a shared spreadsheet; the cadence matters more than the tool in the first year, and the tool becomes worth paying for once the manual version is reliably eating a day a week.

Getting buy-in beyond RevOps. Reps do not resist data entry, they resist pointless data entry.

Most of the resistance a data management routine runs into is not really resistance to the idea of clean data. It is resistance to filling in fields that feel disconnected from anything the rep actually gets out of the CRM that day. A required field added because someone in marketing wanted a report, with no visible benefit to the person filling it in, gets skipped or filled with a junk value the moment the quarter gets busy. Tying a field's existence to something the rep already relies on, accurate territory assignment, correct commission calculation, lead routing that sends the right deal to the right person, changes the incentive without a single new policy document.

Making entry easier at the point of capture matters as much as enforcing it afterwards. A form with twelve required fields at first contact produces either an abandoned form or twelve rushed, low-quality answers; a shorter form that asks for the two or three fields genuinely needed at that stage, with the rest captured progressively as the relationship develops, produces fewer blank fields overall and less bad data to clean up later. The same logic applies inside the CRM itself: a picklist takes less effort to fill in correctly than a free-text field, which is a large part of why consistency problems concentrate in the free-text fields nobody bothered to convert.

Executive sponsorship closes the loop. A data management cadence that only RevOps cares about competes for attention with whatever the sales or marketing leadership is pushing that quarter, and usually loses. Naming data quality as a metric a VP of sales or a CRO reviews alongside pipeline and forecast numbers, even briefly, in a monthly meeting, is often the single change that moves a cadence from something RevOps chases people to complete into something the wider team treats as part of doing the job properly.

A worked example. Where a growing team's pipeline numbers stopped adding up.

A US-based B2B team I worked with had a forecast that consistently overstated the quarter by fifteen to twenty per cent, and the initial assumption was a sales process problem, reps sandbagging or over-committing stages. The real cause turned out to be data: roughly a quarter of open opportunities belonged to contacts who had left their company months earlier, still logged as the active champion because nobody owned the routine of checking. Layered on top of that, duplicate account records meant some pipeline value was being counted twice across two versions of the same company created eighteen months apart by different reps.

Neither problem was hard to fix technically. Assigning a named data owner, adding a quarterly stale-contact review, and running a one-time deduplication pass brought the forecast within a normal, small margin of error inside two quarters. The harder part was cultural: the sales team had quietly stopped trusting the CRM's numbers and was keeping a shadow tracker, and rebuilding that trust took longer than the technical clean-up itself. That is usually the real cost of neglected data management: not the bad number on its own, but the shadow systems everyone builds once they stop believing the real one.

Pitfalls to avoid. Where data management quietly stalls.

Treating a clean-up as a one-off project is the most common failure. A single deduplication sprint feels like progress, and it is, until the same duplicate rate reappears a year later because nothing changed about how records get created in the first place. A clean-up without a cadence behind it is a temporary fix to a permanent problem.

Buying a data quality tool before assigning an owner is the second. Software can flag duplicates and stale records all day; it cannot decide who acts on the flag. A tool layered onto a database with no accountable owner produces a longer list of known problems, not fewer of them.

Automating too aggressively is the third. Auto-merge rules and enrichment overwrites are efficient, but they occasionally merge two genuinely different accounts that share a similar name, or overwrite a correct field with a stale value from an external source. Automation should flag and queue for a quick human check on anything above a low confidence threshold, not act unattended on every match.

The fourth is measuring effort instead of outcome. A team that reports "we cleaned three thousand records this quarter" without tracking the duplicate rate, completion rate or forecast accuracy those records feed into cannot actually tell whether the work is holding. Our RevOps consulting engagements build the ownership model and the cadence together for exactly this reason: a cadence with no owner drifts, and an owner with no cadence burns out re-cleaning the same records every few months. Where the gap is closer to standing up the CRM's data model from scratch, that scope sits inside our RevOps as a service work instead. Our wider RevOps framework guide and the metrics worth tracking both assume the data underneath them is reliable; this is the routine that keeps it that way.

Common questions.

What does RevOps data management actually cover?

The ongoing practice of keeping revenue data accurate, complete, consistent and current: deduplicating records, standardising how fields get filled in, enriching thin records, assigning a named owner to each data domain, and auditing the database on a fixed cadence rather than only when a report looks wrong.

Who should own data quality in a RevOps team?

A single named owner per data domain, usually inside RevOps, who is accountable for that domain's accuracy even though sales, marketing and customer success all create and edit records inside it. Shared ownership across three departments tends to function as no ownership at all, because each team assumes another team is watching the field.

How often should a CRM database be audited?

Quarterly for a full audit, covering duplicate rates, required-field completion and stale or decayed records, with lighter automated checks running continuously in between. A once-a-year clean-up lets enough bad data accumulate that the audit itself becomes a multi-week project instead of a routine one.

What is the difference between data hygiene and data governance?

Data hygiene is the cleanup itself: deduplicating, standardising and enriching records. Data governance is the set of rules and ownership that stop the database getting dirty again afterwards, required fields, naming conventions, who can create a new custom field. Hygiene without governance is a repeating clean-up job with no end.

Can data management be fully automated?

Parts of it, deduplication rules, enrichment lookups and decay-based flags, run well as automation. Automation without a human review step tends to merge records that should not have been merged or overwrite a correct value with a stale one from an enrichment source, so the routine still needs a person checking a sample of what the automation actually did.

Not sure how much of your pipeline is sitting on stale or duplicate records?

Book a short call and we'll scope a data audit, an ownership model and a cadence built to actually hold, not another one-off clean-up.

Let's talk ↑