{"id":75536,"date":"2022-06-03T09:00:55","date_gmt":"2022-06-03T08:00:55","guid":{"rendered":"https:\/\/www.bullhorn.com\/uk\/?post_type=customer_blog&p=75536"},"modified":"2022-05-31T19:00:40","modified_gmt":"2022-05-31T18:00:40","slug":"automation-in-practice-how-to-get-a-useable-database-again","status":"publish","type":"customer_blog","link":"https:\/\/www.bullhorn.com\/uk\/customer-blog\/automation-in-practice-how-to-get-a-useable-database-again\/","title":{"rendered":"Automation in Practice: How to Get a Useable Database Again"},"content":{"rendered":"

This client had a problem that everyone with a database has to some degree: they had junk data.\u00a0<\/span><\/p>\n

Here was their problem\u2014and how they fixed it:<\/b><\/h3>\n

There was a time in this company\u2019s history that they parsed candidate records from external sources en masse. The records consistently missed vital info, such as contact information, phone numbers, emails, resumes, skills, categories, etc. They did, however, have some information sporadically in a few fields. When the recruiters at this company would search their database, many of these incomplete records would come up in their searches, which frustrated the recruiters to the point that they began to look to external sources for information rather than to their own database.<\/span><\/p>\n

Then, Bullhorn Automation<\/a> came along. The team created an automation to archive these junk candidates by utilising criteria that found candidates that didn\u2019t have resumes or contact information, had no submissions or placements, and hadn\u2019t been contacted in over five years.<\/span><\/p>\n

As a result, the company cleansed about 30% of its database, with hundreds of thousands of archived candidate records. With this clean, pristine database, recruiters gained confidence back in their database and looked internally again as their first source.<\/span><\/p>\n

Before Bullhorn Automation, the client had considered hiring a team to do this work manually, forecasting six to twelve months of work. This automation was able to run in the span of just a few hours.<\/span><\/p>\n

An extra benefit of this automation was that it built motivation for additional automations to get the client\u2019s database in an even better place. These could include re-engagement campaigns to reconnect with candidates and client contacts, surveys to fill in missing information, or field and status updates to copy information from one place into another.<\/span><\/p>\n

Here\u2019s how you can do this yourself:<\/b><\/h3>\n

The automation that powered this Automation in Practice is available from a Blueprint.<\/span><\/p>\n

    \n
  1. In the top right corner of your automations page, select <\/span>Add Automation.<\/b><\/li>\n
  2. Scroll down to <\/span>Start from Blueprint.<\/b><\/li>\n
  3. In the Blueprints section, select <\/span>Archive Stale Candidates with Missing Data.<\/b>\u00a0<\/span><\/li>\n
  4. Hit <\/span>Save<\/b> in the bottom right corner.<\/span><\/li>\n
  5. Within the list settings of the automation, you have plenty of options to customise. You can add additional criteria, like candidates who don\u2019t have emails or phone numbers, haven\u2019t been spoken to within a certain amount of time, or haven\u2019t had a submission or placement. Depending on how quickly you\u2019d like to archive these candidates, you can also expand or shrink the time window. However you\u2019d like to implement it, the general idea is that anyone matching these criteria would then get their status set to archive, which would then remove them from the front end of the database and prevent them from showing up in searches.<\/span><\/li>\n<\/ol>\n

    There are plenty of additional automations you can leverage beyond this one. You can find examples <\/span>in the tutorials available<\/span><\/a> to learn how to update information.\u00a0<\/span><\/p>\n

    For example, under the Blueprints section, you can select <\/span>Re-engage Passive Candidates<\/b> for candidates or clients or <\/span>Update Candidate Resume <\/b>to allow candidates to upload a resume via a survey answer that will get parsed automatically into your system. You can even utilise surveys to capture missing data information with <\/span>Capture Missing Candidate Data<\/b>, which finds people missing key data, reaches out to them, and fills in their answers directly into those fields. There are also Blueprints where you can copy information from one place to another, so if you know information on a placement record, you can copy it to a candidate record or submission record.\u00a0<\/span><\/p>\n

    There are a wealth of powerful automations you can use to clean up your database; with Bullhorn Automation, your imagination is the limit.<\/span><\/p>\n

    See this Automation in Practice:<\/b><\/h3>\n

    Watch the video below to see Billy Davis put this automation into practice:<\/span><\/p>\n