Read on Twitter
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.
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.
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.
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.
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.
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.
If no luck, you can try cold emailing them. Or try to reach a portfolio founder.
If you liked this thread, you might like this one https://twitter.com/yoheinakajima/status/1340774204019359744
https://twitter.com/yoheinakajima/status/1340774204019359744
