Learn 3 essential tips for keeping you database clean and increase your candidate experience

3 tips to clean your database

Learn 3 essential tips for keeping you database clean and increase your candidate experience
Reading time: 2 minutes

The best database I ever saw belonged to Crone Corkhill in 2001. It was the most accurate and up to date. It was the key to their success and why they dominated Secretarial recruitment at the time. I remember watching a consultant putting a client on hold, standing up and shouting out a fellow consultant for not updating a candidate, then sitting down and continuing a very pleasant conversation.

Databases full of poor or irrelevant rubbish are a real thing. I recently came across an article on Forbes on data cleaning. Data scientists spend 60 percent of their time on cleaning and organising data, and with 19 percent, collecting data sets comes second. But it seems like this is the total opposite with recruitment.

Most of the time we gather more data and fill up our database instead of cleaning it. I remember FSS having a Data Builder team in the early 2000’s. But hardly any recruitment agency has the time or the right people to clean up their database. In our webinar ‘Cleaner Data: a better Candidate Experience’ we address the impact a cluttered database has.

A cluttered database can cost you valuable time in finding the right candidate or contractor when in a race for your biggest client. That’s why I got 3 tips for you on how to clean your database.

1. Define the required information for candidates and contacts

The required data fields in your database must be relevant. Think along the lines of the obvious: First Name, Last Name, Phone, Email, Location and Current Job Title and Company. A current Salary and CV are needed for a candidate. Think of the things you need to quickly contact and assess who the person is. Too many will be equally as bad as too few as it needs to be practical, your consultants are busy and need to buy into the importance too.

Therefore, if you have records that are blank in these core fields, find them and do something with them. Think about how you are going to filter out this data. Our tips would be: missing contact details, outdated notes and information and incomplete data will cause you problems.

2. Run searches and transfer data to hotlists

Now you have identified your fields you can start to filter your data, this will create multiple search results or hotlists. But before you do so you need to keep your next action in mind on how you will be segmenting (categorising) your data. The next step is to create hotlists based on your categories and the filtering can begin.

Filter out all contacts with no contact details, by looking for blanks. Sometimes people are reluctant to share details, or you don’t have them at the time. That’s why contact details can include faulty information, like 'asdf@email.com' or phone numbers that only have zeros.

When you have found all blanks put them into the correct hotlist. Hotlists will be your working sheet and will hold all contacts and candidates that have faulty information or missing data. Not exclude this from your other searches and you can focus on the outdated and the incomplete data.

3. Archive old data

Up next is to amend, archive or delete the data. The hotlist with missing data will be best off deleted or if necessary, archived. The other hotlists, however, will be your working sheets.

For the lists with missing and or faulty data, this is where your Data Controller or Marketing team will be best to advise. You can send these lists an email with a data request, if relevant. Otherwise, archiving these candidates will be your best choice. If a candidate returns to your agency, you will still be able to pick out the archived data. Just keep data regulations compliance in the back of your mind.

There is still a lot of manual work involved in cleaning out your data. It also depends on the capabilities of your CRM or database. Data scientists heavily rely on their clean data, so why don’t recruiters? With data regulations right around the corner, you need to start thinking of ways to keep your database clean.

Stop gathering bad data, start cleaning first. Cleaning your database will make you money, you will find people you have lost connection with, and either place them or place with them.

Find out more

If you would like to know more about how to clean your data and how to become GDPR compliant watch the recording of our webinar 'Get Your Bullhorn GDPR Ready'.

Author: Raymond Pennie

Read our Blog

Success Stories

See how we work with our clients to maximise their Bullhorn investment.
Here’s how Rural Health West is automatically deduping Bullhorn records overnight. Download PDF
Rural Health West - Kyloe DataTools
Learn More
"It was very easy and required little work on our end since Kyloe managed the project so well."
Pinnacle Consulting & Recruitment - Data migration
Learn More
"Kyloe DataTools accelerates your ability to deploy some pretty powerful AI."
RBW Consulting - Kyloe DataTools
Learn More
MERJE’s journey with Kyloe AI for Bullhorn Download PDF
Merje and Kyloe AI for Bullhorn
Learn More
Getting Bullhorn ready for generative AI with Kyloe DataTools Download PDF
GDH - Kyloe DataTools
Learn More
"The Kyloe team were amazing support and a pleasure to deal with."
Miller Leith - Bullhorn implementation, including Bullhorn Automation
Learn More
"Lost paperwork is a thing of the past – documents are automatically saved to the correct Bullhorn record, which is game-changer!"
Ignite Recruitment - Kyloe AwesomeDocs
Learn More
"Improving data quality in our business has just taken us to the next level... Once you've got that really solid base, you can send off automations and make proper data-backed decisions."
Pioneer Selection - Kyloe DataTools
Learn More
"After ten years with Adapt, Kyloe moved us to Bullhorn migrating almost 500,000 candidates and contacts plus their notes."
Maclean Moore - Bullhorn implementation
Learn More
"Kyloe are clearly the people to go to for this kind of project. I wouldn’t hesitate to work with them again in the future.”
The IN Group: Post-acquisition migration
Learn More
"Data quality heavily affects any other integrations you might have."
Recolution Group - Kyloe DataTools
Learn More
"I would definitely recommend Kyloe AwesomeDocs if you're looking at streamlining any labour-intensive admin processes.It enables Consultants to do what they do best – sell!"
Employment Solutions - Kyloe AwesomeDocs
Learn More
"Kyloe AwesomeDocs integrates seamlessly into our Bullhorn system and deals with the entire workflow, from generating contracts and agreements to sending them for signature using Kyloe's DocuSign integration."
Talent International - Kyloe AwesomeDocs
Learn More
"Kyloe DataTools is a no-brainer for us. It helps us overcome some known Bullhorn limitations and help us manage complex data rules in bulk."
Talent International - Kyloe DataTools
Learn More
"Kyloe DataTools allowed us to effectively merge records automatically and consistently in Bullhorn."
Dartmouth - Kyloe DataTools
Learn More
"...I would highly recommend partnering with Kyloe on Bullhorn Automation."
Lex Consultancy - Bullhorn Automation (formerly Herefish) enablement
Learn More
"Our project team were so knowlegable..."
Tucker Stone - Bullhorn implementation
Learn More
"Kyloe DataTools is an invaluable asset in streamlining data management processes and optimizing the utilization of Bullhorn to its full potential."
Greystone Recruitment - Kyloe DataTools
Learn More
"Kyloe AwesomeDocs is an integral part of our business and saves our consultants a significant amount of time when generating contracts and resumes, freeing up resources to focus on other things."
Technical Resources - Kyloe AwesomeDocs
Learn More
Here's how Jackson Nurse Professionals is automating tasks in Bullhorn to free up resources with Kyloe DataTools Download PDF
Jackson Nurse Professionals - Kyloe DataTools
Learn More
"With Kyloe AwesomeDocs it is really easy to set up unique agreements that fulfil particular client and candidate needs."
isgSearch - Kyloe AwesomeDocs
Learn More
"...we want to partner with the best service providers, and Kyloe was truly excellent."
Fuel Recruitment - Bullhorn Growth Edition implementation
Learn More
Here’s how IDR is dramatically improving Bullhorn data quality and efficiency with Kyloe DataTools Download PDF
IDR - Kyloe DataTools
Learn More
How Hanover are using Kyloe DataTools to improve data quality, compliance, and Bullhorn Automation Download PDF
Hanover - Kyloe DataTools
Learn More
"...they gave advice on how get the most out of Bullhorn's functionalities in a way that worked for us."
Talentpath - Bullhorn implementation
Learn More
"After 12 years on JobAdder we had a lot of data to migrate, and processes to review and implement - Kyloe came highly recommended from Bullhorn."
Keegan Adams - Bullhorn implementation from JobAdder
Learn More
"We've grown really quickly, but we wouldn't have been able to scale the business this quickly without having Kyloe AwesomeDocs in our armoury."
TR2 - Kyloe AwesomeDocs
Learn More
" I would highly recommend Kyloe to anyone requiring support on their implementation. "
Fraser Dove International - Bullhorn implementation
Learn More
"Before Kyloe DataTools, we managed our data manually and it was pure chaos... Now recruiters can focus on what they know best, recruiting."
North Highland - Kyloe DataTools
Learn More
“If you're about to transition to Bullhorn, Kyloe is a no brainer.”
Maxwell Recruitment & Training - Bullhorn implementation
Learn More
"Kyloe’s Bullhorn knowledge was exceptional!"
Whitehall Resources - Bullhorn implementation, Automation & Analytics
Learn More
"I feel we went from the Stone Age to the most advanced technology that does what we need to do overnight." Download PDF
IDR Healthcare - Kyloe AwesomeDocs
Learn More
"We're seeing many more submissions, many more placements... streamlining has created a lot of business for us”
CrossMed Healthcare - Kyloe AwesomeDocs
Learn More
"Implementing Kyloe AwesomeDocs while migrating to Bullhorn just made sense. We can't imagine our contract generation process without it. I would highly recommend it to any recruitment company."
Paxus - Kyloe AwesomeDocs
Learn More
"I would highly recommend their Bullhorn expertise."
Davies Resourcing Solutions - Database merge following Bullhorn M&A
Learn More
“By the end of our Bullhorn implementation by Kyloe we were delighted to consider them as trusted partners."
RGF Staffing - Bullhorn implementation
Learn More
"Our project team were extremely knowledgeable on what was a very complex project."
The Brightwater Group - Bullhorn implementation
Learn More
"The Bullhorn Automation implementation with Kyloe was awesome."
Andvaris - Bullhorn Automation implementation
Learn More
“I would 100% recommend partnering with Kyloe on your Bullhorn Automation setup."
Sphere Digital Recruitment - Bullhorn Automation (formerly Herefish) implementation
Learn More
"Kyloe DataTools is the most powerful tool we have at our fingertips - we use it every day."
LRS Healthcare - Kyloe DataTools
Learn More
"With Kyloe AwesomeDocs our submission rate has increased by 20% - 30% - it's like a time machine!"
Lead Health - Kyloe AwesomeDocs
Learn More
“The Kyloe team was vital on our migration project - their management skills were incredibly beneficial to guide us on defining our new Bullhorn workflows."
Trinnovo Group - Bullhorn database merge
Learn More
"By generating contracts using Kyloe AwesomeDocs we are minimizing our error margins and keeping everything centralized in Bullhorn"
LRS Healthcare - Kyloe AwesomeDocs
Learn More
"Kyloe AwesomeDocs has streamlined the submission packet creation process saving a significant amount of time..."
How we help healthcare recruiters win more business
Learn More
"For us, it's definitely been a time-saving, but also it's really reliable and dependable as well."
Yolk - Kyloe AwesomeDocs
Learn More
"Kyloe AwesomeDocs made our contractor setup process quick and easy – reducing the time from 30 to 2 minutes!"
North Highland - Kyloe AwesomeDocs
Learn More
"Kyloe made the migration to Bullhorn far less painful than anticipated..."
The Panel - Bullhorn implementation
Learn More
"Kyloe DataTools means we no longer have to rely on recruiters to manually update data..."
North Highland - Kyloe DataTools
Learn More
“We must have saved 1,000s of hours thanks to Kyloe..."
Pioneer Selection - Kyloe AwesomeDocs and Kyloe Workflow
Learn More
"Kyloe set the bar (high!) for what an implementation project should look like"
Wapiti Medical Staffing - Bullhorn implementation, customization and integration
Learn More
“Kyloe AwesomeDocs has made a huge difference to the efficiency of our processes."
Allen Recruitment - Kyloe AwesomeDocs
Learn More
"Kyloe were able to enhance value and streamline complexity"
HRM - Implementation and customisation
Learn More
"I’d highly recommend Kyloe for anyone looking to get started with Herefish..."
HiPo - Bullhorn Automation (formerly Herefish) enablement
Learn More
"Kyloe had extensive knowledge of Adapt, Bullhorn and our integrations."
Macdonald and Company - Bullhorn implementation
Learn More
“Kyloe delivered, and guided us perfectly through the whole project."
ageneo - Bullhorn implementation
Learn More
"With DocuSign, contracts are generated, signed and saved back to Bullhorn."
Agri Labour - Kyloe AwesomeDocs
Learn More
"Kyloe can help you customise Bullhorn, use the opportunity to bring your wish list to life”
Cherry Professional - Bullhorn implementation and customisation
Learn More
"Contract generation is now down to four minutes - 10 times faster than before"
Precise Consultants - Kyloe AwesomeDocs
Learn More
"Kyloe AwesomeDocs is intuitive, powerful and can be used with minimal training."
Petroplan - Kyloe AwesomeDocs
Learn More
Bullhorn implementation to offices across the globe in five months.
The Planet Group - Bullhorn implementation
Learn More
Migration, implementation, and training for Bullhorn in under 3 months
i-Pharm - Bullhorn implementation
Learn More
Implementation
Learn More
Customisation
Learn More
Our clients come in all shapes and sizesSee how they've used Kyloe solutions to maximise their Bullhorn investment.
Kyloe AwesomeDocs
Learn More
Our clients come in all shapes and sizesSee how they've used Kyloe solutions to maximise their Bullhorn investment.
Kyloe DataTools
Learn More
Our clients come in all shapes and sizesSee how they've used Kyloe solutions to maximise their Bullhorn investment.
Kyloe Workflow
Learn More
Data Improvement
Learn More
AI powered recruitment
Learn More
Streamlined Communications
Learn More
Paperwork Automation
Learn More
Kyloe For Healthcare
Learn More
Bullhorn Automation
Learn More
Mass data updates
Learn More
Bullhorn data migration
Learn More
Our clients come in all shapes and sizesSee how they've used Kyloe solutions to maximise their Bullhorn investment.
Kyloe AI for bullhorn
Learn More
Customised workflows
Learn More
Pain-free implementation
Learn More
Automation success
Learn More
Merged data
Learn More
Mergers and acquisitions (M&A)
Learn More

How can we help you?

There's almost nothing our Bullhorn experts can't do!
Get started

Solutions

Get more out of Bullhorn with solutions that are as unique as your needs.
Kyloe AI Assist - Interactive demo
Kyloe AI Assist interactive demo
See what it's like to run pre-defined AI prompts directly from within Bullhorn with our generative AI...
Learn More
Kyloe AI for Bullhorn
Recruitment AI
...
Learn More
Kyloe Workflow demo
Kyloe Workflow demo
See what it's like to automate and streamline how you send and track communications and schedule interviews...
Learn More
Kyloe for light industrial interactive demo
Kyloe for light industrial interactive demo
See what it's like to submit candidates in mass while maintaining accuracy and professionalism....
Learn More
Kyloe for Healthcare Interactive demo
Kyloe for Healthcare interactive demo
See what it's like to accelerate your submissions, manage risks, and stand out from your competitors with...
Learn More
Kyloe AwesomeDocs for Invenias Interactive demo
Kyloe AwesomeDocs for Invenias interactive demo
From Candidate NDAs and Right to Represent letters to proposals and terms of business, Kyloe AwesomeDocs...
Learn More
Kyloe DataTools interactive demo
Kyloe DataTools interactive demo
See what it's like to automatically dedupe, identify gaps, and make mass data updates....
Learn More
Kyloe AwesomeDocs - Interactive demo
Kyloe AwesomeDocs interactive demo
See what it's like to generate leads, dramatically reduce busywork, and accelerate signing speed....
Learn More
Document automation
Kyloe AwesomeDocs for Bullhorn
Built with Bullhorn users in mind, Kyloe AwesomeDocs sits within your platform for a seamless experience. Set...
Learn More
Data quality
Kyloe DataTools for Bullhorn data management
Your Bullhorn CRM sits at the heart of your business, but the data within it can become duplicated, inaccurate...
Learn More
Templated communications
Kyloe Workflow
Kyloe Workflow automates and streamlines how you send and track communications and schedule interviews with...
Learn More
Light industrial document automation
Kyloe AwesomeDocs for light industrial
Kyloe AwesomeDocs for light industrial allows staffing companies to submit candidates in mass while...
Learn More
Healthcare automation
Kyloe for Healthcare
Speed and accuracy is everything in the healthcare staffing industry. Accelerate your submissions, manage...
Learn More
Executive search document automation
Kyloe AwesomeDocs for Invenias
From Candidate NDAs and Right to Represent letters to proposals and terms of business, Kyloe AwesomeDocs...
Learn More