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.