Back to Blog Is It Time to Clean House? 6 Steps to Better Manage Your Candidate Database by Doug Ellinger on December 8th, 2016 No matter what time of year it is, if you’re at all like me, you absolutely loathe the idea of cleaning your house or apartment. However, one benefit of cleaning up (or cleaning out) your surroundings is that it frees up time for you to focus on more productive activities. If you get into the habit of maintaining a clean and orderly environment, you will significantly reduce the amount of time you spend searching for ‘lost’ items and getting frustrated over your own disorganisation. The time you save is valuable – very valuable. In recruitment, or in any business for that matter, your database is a lot like your home. Whether you paid to acquire it from someone else, inherited it from a predecessor, or built it from scratch, it holds a lot of value. And, if maintained and updated properly, it will appreciate over time. But, if left alone, it will become cluttered, outdated, and a major source of stress. Your candidate database is a potential goldmine. Here’s how to clean out the pyrite. Click To Tweet Most recruitment agencies use an applicant tracking system to house their client and candidate databases. Applicant tracking systems can be extremely powerful tools, especially when the race is on to search for and find the right candidate for a job order. In fact, according to Bullhorn’s 2016 Recruitment Agency Round-Up: How Do You Compare Report, referrals from previously placed candidates and candidates from the existing database were the two most popular sourcing strategies. Referrals and existing candidates from an ATS remain the most popular sourcing strategies. Click To Tweet So the candidate database you’ve spent many hours and money building up is a potential goldmine. But, mining it is not always easy – especially if you’ve let it get dirty and disorganised. The following tips are designed to help you think about ways to improve the quality of your candidate database so you can turn it into a competitive advantage for you and your agency: Develop a process among your recruiters for screening candidate resumes and bucketing them in your system. This applies to candidates that apply to your posted jobs and candidates that you pull into your ATS through third party tools (aggregators and boards). Use your screened category as a filter when searching for quality candidates going forward. Add skills to your candidates instead of relying solely on keywords. For many jobs, specific skills (e.g., Java, C++, Ruby) are core requirements, so make it easier for you and your team to find these candidates down the road. By doing this, you’ll also reduce your dependency on complex or boolean searches and you’ll avoid those rare candidates who know how to game the system by stuffing keywords into their resume (sometimes invisibly!). If you tackle tips #1 and #2 alone, think how easy it will be to search for your next level 3 software developer that can code in C++ and has already been screened by a recruiter on your team. Establish a process for managing duplicates. When you add a new candidate to your applicant tracking system, your software should have the functionality built in to alert you about any possible dupes, either through email matches, first and last name connections, etc.. If your recruiters let those dupes flow freely into your system without merging records or purging any duplicate or outdated record(s), your database is going to get messy. This could cost you time and money down the line when you need to fill a highly competitive job order for a key client. Monitor your team’s activity. Establish criteria for how you expect your recruiters to vet new records entering the database and set volume or percentage goals for candidate screening, categorising and cleansing. Even more, report out on the percentage or volume of candidates that have been properly screened/categorised/tagged and draw comparisons across your team. Set a baseline and continually increase your expectations. Hire someone to clean your existing database. Once in a while, your house gets to the point where you can’t even fathom starting a clean up process. If your database has gotten away from you, think about hiring outside help – an intern, a low cost FTE, an outsourced freelancer and put them to work on organising and tagging your records. Please view this as an ongoing effort, though, and not a one-time project. Investigate third-party tools that will help you structure incoming data. Various technologies that integrate into applicant tracking systems can help you parse resumes into pre-existing or customised taxonomies (e.g., skills, industries, professions, qualifications, languages, etc.) making searching easier and more efficient. For more recruiting tips and trends, check out the report, Recruitment Agency Round-Up: How Do You Compare?