Alchemy is the study of focused transformation. I have always been fascinated by Alchemy because the aim is to take some low value resource, like lead and turn it into a high value resource like gold. In a way, a production line is an alchemical process. We take raw material through a specific, repeatable process and we transform it into something more valuable.
Boolean Search: The Raw Material
One of the raw materials of sourcing is Boolean search strings. A good search string can return valuable information. But often this raw material is too difficult refine. The information returned, while valuable, requires too much effort to extract. For example, a search string for attendance list may produce a document with 20 pages of good contact information. There is only one catch. The list is in a PDF file. If you have been a sourcer you know the pain. You have great, detailed information locked in a PDF file. If you have ever tried to extract information from a PDF file and convert it into Excel you will know that the cleanest way to get the information is to manually copy the information into Excel.
We want to take the raw material of a Boolean search and transform it into actionable information that results in our being able to make additional hires. Hires are our gold.
How To Transform Your Search Into A Hire
So how do we transform our searches into hires? First, we create a string that will give us lists of useful contacts. Most sourcers are familiar with how to create a search string that will return lists of information so I won’t go into detail here. However, too often our searches return PDF files. A PDF file and in the past would have most likely been disregarded. However I have created a process to turn the information locked in those PDF files into actionable information. First download the file to your hard drive.
Below is an example of an attendance list in PDF format:
Next you need to find a tool called Tabula. It can be found by clicking here.
Upload your PDF file and select the range you would like to extract data from as in the example below
I then select “repeat this selection.” This will select the same selection on every page for the rest of the document after the appropriate fields have been selected. Next select “Download All Data.” This will download the data into an Excel spreadsheet. The data should look something like this.
From this point is it simply a matter of formatting.
Once the data is in this form it can be used to create a mail merge email campaign, uploaded into an applicant tracking system or matched into LinkedIn Recruiter via their data stacking tool that is called Talent Pipeline. To import the connections into your LinkedIn Recruiter seat simply follow the instructions below.
Lists can have as many as 5,000 contacts. Fill out the required information and select continue.
LinkedIn will automatically identify the candidates that already have a LinkedIn profile. You can then tag your list and put the contacts in a project folder. The first name, last name and email should automatically match fields. This will allow you to validate the data you have acquired and it will match the information against a LinkedIn profile. This means that we are not solely dependent on Inmails.
Even if you do not have a LinkedIn Recruiter seat you can manually search for the profiles from your personal account. You can then reach out to them via the information you obtained from your search string. From here we can email and call our prospects. Following this sourcing alchemy process we can turn our led Boolan search strings into prospects we can contact and ultimately convert into golden hires.Get In Touch