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

3 tips to clean your database

December 5, 2017
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.
“We must have saved 1,000s of hours thanks to Kyloe..."
Pioneer Selection
Learn More
“AwesomeDocs has made a huge difference to the efficiency of our processes."
Allen Recruitment
Learn More
"Kyloe executed a very smooth transition from Adapt to Bullhorn for us."
TSG Staffing
Learn More
"Kyloe had extensive knowledge of Adapt, Bullhorn and our integrations."
Macdonald and Company
Learn More
"Kyloe were able to enhance value and streamline complexity"
Learn More
A painless transition from Bond Adapt to Bullhorn
Prism Executive Recruitment
Learn More
"Kyloe solutions are intuitive and always have the end users experience in mind"
Premier Group
Learn More
“Kyloe delivered, and guided us perfectly through the whole project."
Learn More
“AwesomeDocs reduced workload by 30-40%."
The Delta Companies
Learn More
"With Docusign, contracts are generated, signed and saved back to Bullhorn."
Agri Labour
Learn More
"Kyloe can help you customise Bullhorn, use the opportunity to bring your wish list to life”
Cherry Professional
Learn More
"Kyloe did a first-class job - delivered on time and within budget."
Retail Management Consultants
Learn More
"AwesomeDocs is intuitive, powerful and can be used with minimal training."
Learn More
Bullhorn implementation to offices across the globe in five months.
The Planet Group
Learn More
Bullhorn and BBO integration launch on schedule and within budget.
Aim Consulting
Learn More
"CV Formatter is an essential addition to the Bullhorn CRM"
Target Recruitment
Learn More
"Our training showed us how Bullhorn plays a central role in building relationships"
Learn More
"The Kyloe Training team were extremely helpful and personable with out staff."
Michael Taylor Search and Selection
Learn More
"Thanks to Kyloe's tailored training programme, we now have a team that fully understands the value of Bullhorn."
Learn More
"Kyloe Partners were our implementation team for Bullhorn CRM – and we are so glad we chose them!"
Allen and York
Learn More
"My business is very satisfied with the work Kyloe have done within a short timescale."
CRA Recruitment
Learn More
Migration, implementation, and training for Bullhorn in under 3 months
Learn More
Video: Sending contracts 10 times faster with AwesomeDocs
Precise Consultants
Learn More
"Kyloe held a webinar training session for us which we all found incredibly helpful."
HW Group
Learn More

How can we help you?

There's almost nothing our Bullhorn experts can't do!
Request more details
Learn more


Get more out of Bullhorn with solutions that are as unique as your needs.
Document automation
From CVs to contracts, and terms of business to non-disclosure agreements, AwesomeDocs is the end-to-end...
Learn More
Templated communications
Send bulk email or SMS to clients and candidates. Workflow automates and streamlines the time consuming tasks...
Learn More
Data improvement
Duplikit & DataCleaner
Getting duplicate results when searching, or finding gaps in key information? It's probably time to clean...
Learn More
Canvas report templates
We know how hard it can be to build Canvas reports from scratch, that's why we've built templates for you....
Learn More
Further solutions
Further solutions
Streamline and automate your processes with these tools....
Learn More
AwesomeDocs for healthcare
Our experience within the healthcare sector has taught us that it's a complex...
Learn More
Temporary workers
Fill temporary roles faster
In response to rising demand for certain products and services during the coronavirus crisis, some companies...
Learn More
Learn More
Bullhorn training to suit your needs
Ensure your users know how use Bullhorn effectively with our range of on-site and remote training options....
Learn More
Data updates
Make your Bullhorn data work harder
Your database is one of your most valuable assets. It sits at the heart of your business, from sourcing...
Learn More
Reporting and analytics
Unlock your data
Intelligent recruitment is informed by strong data. Let us help you get the metrics you need to take your...
Learn More
Acquisitions and divestments
Acquisitions and divestment services for your data
Migrating data onto Bullhorn following a merger or acquisition, or splitting an existing database following...
Learn More
Process and system review
Let us solve your unique pain points
A truly custom experience, our consultants listen to your challenges, understand your goals, undertake a full...
Learn More
Automations and validations
Bullhorn automations and validations
Automate your workflows and processes across the recruiting lifecycle, and add validations to ensure...
Learn More
Bullhorn integrations
Build a Bullhorn that seamlessly combines recruitment, business development, and finance by integrating...
Learn More