Mobile navigation

Q&A 

The importance of clean data: 5 minutes with… Rob Sherwood

Successful publishers have one thing in common – clean data. So, why do so many publishers put up with messy data? We grab five minutes with Rob Sherwood, founder of Adept Data Services, to find out why clean data matters and what publishers need to do to achieve it.

By Rob Sherwood

The importance of clean data: 5 minutes with… Rob Sherwood

Q: How important is clean data?

A: Clean data isn’t optional. It’s the difference between smart decisions and stupid ones. Feed your system bad data and you’ll get bad decisions back, every single time. It’s that simple. You can pour time and money into campaigns, design, or fancy systems, but if the information underneath is wrong, you’re building on sand. Clean data keeps everything honest. Renewals run smoother. Reports actually mean something. Get the data right and the rest of the business suddenly feels a lot easier.

Q: What are the hallmarks of a clean data set?

A: Clean data has three things: accuracy, consistency, and purpose. Every record should be right, current, and there for a reason. You shouldn’t have to stop and wonder if an address is real, if someone’s still a subscriber, or which version of John Smith to trust. Good data has rules. You know how new records are added, checked, and kept up to date. It’s not just neat, it’s reliable. When everyone in the business believes the numbers, decisions get faster and life gets easier.

Q: What are the primary causes of messy data?

A: Messy data doesn’t appear overnight. It creeps in bit by bit. Too many people doing things their own way. Systems that don’t talk to each other. No one clearly in charge. Most publishers are running databases that have been patched and bodged for years. Then you add spreadsheets, manual imports and half-forgotten web forms, and suddenly you’ve got duplicates, inconsistencies and fields being used for things they were never meant for. It’s rarely neglect, just a lack of structure. “Good enough” becomes normal, and before you know it, the mess has taken over.

Q: What should publishers do to put their (data) house in order?

A: First, figure out what data you’ve actually got and where it lives. Most publishers don’t have one clean version of the truth. Readers are in one place, web users live somewhere else, marketing data is in lots of different pots. Get it all mapped out. Then decide what “clean” means for your business and set the rules to match. Strip out duplicates. Fix the validation rules. Standardise names and addresses. And most importantly, make someone responsible for it. Clean data doesn’t just happen. It needs ownership, process, and someone who actually cares enough to keep it that way.

That person doesn’t have to be in-house either. Many publishers choose to outsource data management to specialists who live and breathe this stuff, bringing structure, consistency and accountability without adding to the headcount. The key thing is that someone, internal or external, owns it and keeps it clean.

Q: Once they have a clean set of data, how can publishers ensure it stays that way?

A: Think of it like housekeeping, not a one-off spring clean. Build checks into everyday routines so bad data never makes it in. Automate what you can, run regular audits, and let subscribers update their own details easily. The big one, though, is awareness. When people see that sloppy data means missed renewals, wasted print runs, and annoyed readers, they start to take it seriously. Clean data isn’t just the circulation team’s job. It’s everyone’s.

Q: To what extent does using legacy systems contribute to poor data quality?

A: Legacy systems cause more trouble than most people admit. They’re rigid, under-documented, and built for a world that doesn’t exist anymore. The data structures don’t match how publishers actually work today. That’s when people start using spare fields for random stuff or dumping data into spreadsheets just to get a report out. The system itself might not be broken, but the way it’s being used definitely is. Fixing it doesn’t always mean starting from scratch. Sometimes, you just need to modernise the processes around it. Leave it too long, though, and those bad habits become part of the culture.

Q: What’s in the pipeline from Adept Data Services?

A: We’re keeping it simple. Publishers shouldn’t have to be data scientists to run a smooth circulation operation. Our focus is on making everything join up properly. Subscription data, marketing, fulfilment and finance all talking to each other so the information just flows. We’ve moved our reporting over to MetaBase, but the setup works with any BI tool a client prefers. The goal is flexibility and clarity, not lock-in. We’re also building smarter tools that spot problems before they turn into fires. The aim is simple: less time fixing data, more time looking after readers.

About us

Adept Data Services is a specialist software and bureau business serving the publishing industry. We provide the Avio platform for subscriptions, circulation, CRM, CMS, advertising and reporting, alongside expert outsourced bureau services including data management, audit preparation and compliance.

Our team draws on decades of experience in publishing operations to help publishers streamline workflows, reduce costs and scale their audience management infrastructure. Whether you need an integrated in-house system, a fully managed bureau solution, or a hybrid approach, Adept Data Services delivers flexible, reliable support tailored to your business.

Web: www.adeptdataservices.co.uk

Email: info@adeptdataservices.co.uk

Tel: 01474 526 651