How to build a target investor list using Crunchbase. 👇

First, you’ll need Crunchbase Pro. At $25/mo, not bad.

Then, I use Airtable, specifically the Linked Table feature.

Step 1: Go to Crunchbase and search for funding rounds (not companies), filter by relevant categories (for funded org), the right funding type (Eg seed), geo, and then do “announced after” and pick a date 2 or 3 years ago.

These are funding rounds by startups relevant to you.
Step 2: Export list to csv. Make sure you have the “investors” column in there.

Import csv to a new Airtable.
Step 3: Go to the “Investor Names” column > Edit Column Type > Link to another table > Create New (title it “Investors”).

What this does is separate the column by comma and create a new row for each investor in a new table.
Step 4: Go to linked “Investors” table. It should auto have a column w all the linked funding rounds. Create a “count” column on this.
Step 5: Sort by Count desc.

What you’ll have is a list of the most active investors in your geo/industry, sorted by activity, w reference to recent deals.
Step 6: You can repeat this search for each industry and geo separately, which will give you more granular data (Eg. “this investor invests locally AND in my sector often”).
Step 7: Once you have this list, use LinkedIn to see if you have intro paths (use LinkedIn premium and search for “current companies > add firm names” and “2nd degree connection” for intro paths.

If no luck, you can try cold emailing them. Or try to reach a portfolio founder.

You May Also Like

The first ever world map was sketched thousands of years ago by Indian saint
“Ramanujacharya” who simply translated the following verse from Mahabharat and gave the world its real face

In Mahabharat,it is described how 'Maharishi Ved Vyasa' gave away his divine vision to Sanjay


Dhritarashtra's charioteer so that he could describe him the events of the upcoming war.

But, even before questions of war could begin, Dhritarashtra asked him to describe how the world looks like from space.

This is how he described the face of the world:

सुदर्शनं प्रवक्ष्यामि द्वीपं तु कुरुनन्दन। परिमण्डलो महाराज द्वीपोऽसौ चक्रसंस्थितः॥
यथा हि पुरुषः पश्येदादर्शे मुखमात्मनः। एवं सुदर्शनद्वीपो दृश्यते चन्द्रमण्डले॥ द्विरंशे पिप्पलस्तत्र द्विरंशे च शशो महान्।

—वेद व्यास, भीष्म पर्व, महाभारत


Meaning:-

हे कुरुनन्दन ! सुदर्शन नामक यह द्वीप चक्र की भाँति गोलाकार स्थित है, जैसे पुरुष दर्पण में अपना मुख देखता है, उसी प्रकार यह द्वीप चन्द्रमण्डल में दिखायी देता है। इसके दो अंशो मे पीपल और दो अंशो मे विशाल शश (खरगोश) दिखायी देता है।


Meaning: "Just like a man sees his face in the mirror, so does the Earth appears in the Universe. In the first part you see leaves of the Peepal Tree, and in the next part you see a Rabbit."

Based on this shloka, Saint Ramanujacharya sketched out the map, but the world laughed