A Common Situation

In certain cases, you have a list of companies attending an event you go to - or a list of member companies you found on a bio association member directory list.

The Usual Way

You manually or with ChatGPT research the companies to figure out which ones may fit your ideal customer profile. It’s a lot of digging, waiting, reading, … then you still need to find the right contacts, working email addresses… and then you need to figure out what to communicate.

The AcademicLabs Way

1. Search the full list of companies in one query (Search By ‘Company Name’)
2. Filter criteria of interest, e.g. Preclinical Therapeutic Biotechs, in your Territory, active in Small Molecules (or ADCs)
3. Bulk analyze all companies with AI to assess Customer Fit and get tailored email sequences
4. Export leadership with valid emails
5. Contact [30] of the best-fit customers with relevant hypertailored emails within 2 hours instead of 2 weeks

Practically, how do search the full list of companies in one query?

<aside> 💡

Let’s use Excel first to build the query

</aside>

1. Column A: Download/copy/scrape a list of companies into 1 Excel column

2. Column B: Use the following formula to add quotes around each company name to ensure we search for that name instead of the individual terms: ="""" & A2 & """”

   

3. Columns C, row 2 (just one cell): Use the following formula to build the search query with each company name (with quotes) separated by OR: =TEXTJOIN(" OR "; TRUE; B2:B1101)

   

<aside> 💡

Now let’s use AcademicLabs - in a smart way

</aside>

1. AcademicLabs platform: select inCompanies via Search By only Company Name as specific field to search by: