Steven, the Linkedin API you guys offer is excellent. But how do I begin to use the API if I do not even have the profiles?
I get this question so often, so we decided to crawl every profile and put it into a Postgresql database. We call this product LinkDB, and this is what you can do with it.
What is LinkDB
LinkDB is a Postgresql database preloaded with Linkedin profiles segregated by region. For example, LinkDB for the US is a PostgreSQL database populated with has 165M Linkedin profiles of Americans.
We store each profile as a row under a JSONB column, and this is the shape of the profile's structured data.
Integrating LinkDB into your product
Suppose you run a recruitment platform that pairs software engineers with big tech firms in Singapore. And your growth team is seeking more users on your platform! Specifically, software engineers. LinkDB is a PostgreSQL database. So we will send this SQL query to LinkDB for Singapore that says:
Find all software engineers in Singapore
To fetch the list of professionals who are currently employed as software engineers
SELECT id
FROM PROFILE
WHERE EXISTS
(SELECT
FROM jsonb_array_elements(parsed_data->'experiences') exp
WHERE (exp->>'title' ilike '%Software Engineer%' OR
exp->>'title' ilike '%Software Developer%') AND
exp->>'ends_at' is null
)
And 10055 software engineers were found along with their Linkedin profile ID.
Find software engineers working at Grab
Grab, the Uber of Southeast Asia has frozen hiring and is looking to downsize its software engineering team no thanks to the COVID19 pandemic. This downsizing event presents a brilliant opportunity to onboard software engineers from Grab into our imaginary recruitment platform!
So let's ask LinkDB for a list of software engineers working at Grab. And we do so by sending this SQL query::
SELECT id
FROM PROFILE
WHERE EXISTS
(SELECT
FROM jsonb_array_elements(parsed_data->'experiences') exp
WHERE exp->>'company_linkedin_profile_url' ILIKE '%linkedin.com/company/grabapp%' )
AND EXISTS
(SELECT
FROM jsonb_array_elements(parsed_data->'experiences') exp
WHERE (exp->>'title' ILIKE '%Software Engineer%'
OR exp->>'title' ILIKE '%Software Developer%')
AND exp->>'ends_at' IS NULL )
In an instant, we have a list of 227 Linkedin profiles of every software engineer working in Grab. This is a headhunter's dream.
Find undergrads who have just matriculated in 2020, majoring in Computer Science with the National University of Singapore
In this imaginary recruitment platform that you are building, you have an internship section for big tech firms because big tech firms want to secure the best undergrads before they graduate. These software engineer internship roles are a perfect fit for Computer Science undergrads. Let's get a list of undergrads who are majoring in Computer science at the National University of Singapore (NUS).
And this is the SQL query to fetch this data:
SELECT id
FROM PROFILE
WHERE EXISTS
(SELECT
FROM jsonb_array_elements(parsed_data->'education') exp
WHERE ( exp->>'degree_name' ILIKE '%Computer Science%'
OR exp->>'degree_name' ILIKE '%Comp%Sci%')
AND exp->>'school' ILIKE 'National University of Singapore' )
and EXISTS
(SELECT
FROM jsonb_array_elements(parsed_data->'education') exp
WHERE exp->>'starts_at' IS NOT NULL
AND exp#>>'{starts_at,year}' = '2020' )
Here, we have 61 undergrads who have just matriculated, and they are majoring in Computer Science with the National University of Singapore. Perfect candidates for internship positions.
Find CEOs in Singapore
With LinkDB, you have built a brilliant recruitment product pre-populated with perfect candidates that your growth team has helped onboarded. But that is only one side of the equation in a marketplace product that is a recruitment platform. You make money when companies pay you for sourcing perfect candidates for them. And your sales department needs leads. They want to talk to decision-makers -- CEOs.
And this is the SQL query to fetch a list of active CEOs in Singapore
SELECT id
FROM PROFILE
WHERE EXISTS
(SELECT
FROM jsonb_array_elements(parsed_data->'experiences') exp
WHERE (exp->>'title' ilike '%CEO%' OR
exp->>'title' ilike '%Chief executive officer%') AND
exp->>'ends_at' is null
)
And LinkDB tells us that there are 9633 active CEOs in Singapore.
Plug LinkDB Postgresql instance into your product for $166.50 / mo
So, you want to build your own awesome recruitment platform? You can, for $166.50 / month, you can access LinkDB and plug it into your product.
These are our pricing plans. Our pricing plan for access to LinkDB starts from $166.50 / mo.
| Lite | Startup (without LinkDB) | Startup (with LinkDB) | Pro | XL |
|---|---|---|---|---|
| $9.90 / mo | $199 / mo | $166.5 / mo (paid annually) | $1500/mo (payment terms of 3 months) | $7999/mo |
| 1000 credits / month | 20,000 / month | 20,000 / month | 200,000 credits / month | 1,250,000 credits / mo |
| $0.01 / credit | $0.01 / credit | $0.0083 / credit | $0.0075 / credit | $0.0063 / credit |
| (No access to LinkDB) | (No access to LinkDB) | Access to LinkDB | Access to LinkDB | Access to LinkDB |
- It costs 2 credits per "row of result" queried from LinkDB. Usage is metered by bytes. Cost per bytes is an average byte size of a row of profile.
- It costs 1 credits for each request made via our Linkedin API
LinkDB will go live in December 2020
LinkDB will go live in December 2020 for databases of US and Singapore. But our subscription plans are available today and they are a better value than our current top up system.
Subscribe now, enjoy deep discounts, and get credits added into your account within 1 business day for use with Proxycurl's Linkedin API. And be the first to integrate LinkDB come December!
Questions and a live demo
As of today, we have a live LinkDB database for 1.4M Singapore profiles. I will be happy to get on a video call with you and write some SQL queries and show you how it can work for you. Just shoot me an email to [email protected].