Target Company Research Prompt Builder

Fill in what you know once — Section 1 builds the detailed company pull (full research tracker), Section 2 builds an optional wide-net bulk pull, Section 3 maps your target companies to your LinkedIn connections (and, optionally, your message history with them), Section 4 finds named department contacts via web search. v5

Shared Inputs

Fill in at least one of these — use more than one if you have them, and they'll be combined. These feed both Section 1 (Detailed Company Pull) and Section 2 (Bulk Company Pull) below.

Each company here seeds the discovery/competitor-cascade methods below — roughly 2+ searches apiece before any expansion. 5-10 tends to give the cleanest results.

Be as specific as you can — free-text phrases don't map cleanly to a single NAICS code, so a vague phrase here is more likely to produce a bad code extraction. The prompt asks Claude to state which keyword it used, so you can catch a bad match early. Not sure how to phrase it? Browse official industry names and definitions at the Census NAICS Search — you don't need to find your own code, just borrow their wording.

NAICS codes in this tool are a supporting layer (up to 5 per company, for classification and per-company verification), not the main way new companies get found — a code alone is too broad to search by. New companies mainly come from competitor lookups, analyst/category lists, conference exhibitor lists, and live job postings tied to what you named above.

Phrased as a filter Claude applies while researching. Leave blank to include companies of any size.

Leave the ZIP code blank to search all locations with no distance restriction. If you enter a ZIP, the radius defaults to 100 miles but can be changed. This is separate from "Preferred location / work arrangement" further down, which is about your own job-search preferences rather than filtering candidate companies by distance.

Section 1 — Detailed Company Pull

The main tool — full per-company research (up to 36 columns) and a fully formatted Excel tracker, built from the Shared Inputs above plus everything you set below.

Section 1 · Scope & purpose

"Find new companies" = Claude does its own moderate discovery (competitor cascade, analyst lists, conference exhibitor lists, job postings) bundled into the full research pass — good for "I have a few companies, expand modestly and research everything fully." "Just enrich these" = Claude only researches the exact company names you typed — no new companies added. If you ran Section 2's Bulk Company Pull (below) and pasted your pruned list into "Company(s) you know" above, choose "Just enrich these" here — Section 2 already did the wide discovery, so a second discovery pass isn't needed and would just add expensive-to-research companies you didn't vet.

The Section 2 equivalent of "Target list size" — a loose volume dial for this discovery pass (competitor cascade, analyst lists, conferences, job postings). Unlike Section 2, every company found here gets full research, so totals above ~50–75 tend to come back thinner per company — batch it, or use Section 2's wider, cheaper Bulk Company Pull (below) instead, if you need more.

"Yes" has Claude build a wider candidate pool using the discovery method below (competitor cascade, analyst/category sources, conference exhibitor lists, job postings), rank the whole pool against your purpose, then fully research your top companies (Tier 1 — every column) while giving the rest (Tier 2) a lighter pass with a slimmer column set.

"Yes" broadens the search to suppliers, vendors, and related-but-differently-classified industries. "No" keeps it tightly scoped to your exact code(s).

The most important field — it tells Claude how to judge Category, Key Contact, Opportunity Fit, and Why This Fits for every company. Be specific.

Not a file upload — paste text directly (resume, CV, bio, LinkedIn summary, or just a few sentences — whatever you have). No length limit, but a tight paragraph of relevant highlights tends to work better than pasting a full multi-page document — it's easier for Claude to weigh correctly. Sharpens the Suggested Job Title Keywords column and gives Claude something real to reason from for Warm Introduction Path (former employers, overlapping experience) instead of guessing generically.

"Yes" (default) asks for the full formatted tracker: color-coded rating columns, a computed Suggested Priority Rank column, clickable Website links, autofilter, frozen panes, zebra striping, and separate Notes/Summary tabs — the same conventions used throughout this project, spelled out explicitly so you get them in any chat, not just this one. "No" asks for a plain data-only spreadsheet if you'd rather skip the extra formatting.

"Yes" (default) adds a second sheet with one-click LinkedIn Jobs, Indeed, and Google Jobs search links per company — built from the Company and Suggested Job Title Keywords columns using Excel HYPERLINK() formulas, so the links stay live and update automatically if you edit either cell later. This is a search-link generator, not a source of actual live postings — for real postings data, that's a separate tool/step (see the User Guide).

"Yes" (default) adds a simple two-column "Job Post Finder" tab — Company Name in column A and Suggested Job Title Keywords in column B, copied straight from the main tracker, one row per company. No formulas or hardcoded job boards, just plain data: run the target list first, then come to this tab and copy a company name plus its keyword variants to paste into whichever job board or search engine you want to check by hand. This complements the Job Posting Quick Links tab above rather than replacing it — that one gives pre-built clickable links to three specific platforms using a single title; this one gives you the raw company-and-keywords pair, with all title variants, to search anywhere yourself.

"Yes" (default) adds a plain four-column "Outreach Contacts" tab — Company, Key Contacts / Priority Titles, Warm Introduction Path, and Category, in that exact order, copied straight from the main tracker. These four columns aren't adjacent on the main sheet, so pulling them together today means Ctrl+click-selecting four separate columns by hand — easy to get the order wrong or skip one by mistake. This tab puts them side by side instead, so you can just click-drag the whole block and paste it directly into the Outreach Message Builder's bulk-paste box (a separate companion tool), no multi-select needed.

"Yes" (default) adds a tab of real, upcoming industry conferences and trade shows relevant to your stated industry/purpose — one row per event, not per company, since the same event is often relevant to several companies on your list at once. Each event's "Relevant To" field reuses your Category column, so it stays connected to however you've grouped your companies.

Different from the tab above — this one is one row per company (not per event), tracking each company's own public activity: recent LinkedIn posts/announcements, podcast or webcast appearances, and upcoming events/tradeshows they're attending or speaking at. This is much harder to verify reliably via search than a public conference calendar, so expect real gaps — Claude is instructed to leave rows blank rather than invent activity that isn't actually findable.

M&A research columns optional

0 of 10 fields filled in
Fill in at least one starting-point field or a purpose to see your prompt appear here.

Section 2 (optional) — Bulk Company Pull

A separate, cheap, wide-net prompt. Instead of full 31-column research per company, this asks Claude to build a fast flat list — Company, Website, Inferred NAICS Code, one-line description, Source — using the same competitor-cascade / analyst-list / conference-exhibitor / job-posting discovery methods as Section 1, just without the deep per-company research. Meant to be pruned by hand afterward: delete the rows that aren't relevant, then paste the survivors into "Company(s) you know" above and set Section 1's Discovery scope to "Just enrich these" so the full research pass only spends effort on companies you've already confirmed you want.

Since there's no per-company deep research here, this can go wider than Section 1's ~50-75 ceiling. Still bounded by how much a given seed/industry can actually support — Claude will say so if it can't find enough distinct real companies rather than padding the list.

Fill in at least one Shared Input above (company, industry, or NAICS code) to see this prompt appear here.

Section 3 (optional) — LinkedIn Contact Enrichment

This is a separate, focused prompt for cross-referencing your LinkedIn data export against your Top Targeted Companies to surface warm introduction paths. It always maps your target companies to your connections (Connections.csv). If you also attach your messages (messages.csv), it adds your conversation history with each of those connections, so you can see who you've already talked to, who's waiting on you, and who you've never contacted. Works best with 25 or fewer companies: the more companies you list, the more Claude has to fuzzy-match against for every single contact, which slows down the processing and can hurt match quality.

Run it separately from the Target Company Prompt Builder above: run that tool first, then paste your Top 25 companies below to build this prompt. Download the .txt, then paste that prompt into Claude and attach your LinkedIn export file(s) to the same message. There's no need to upload or paste the CSVs here — this tool never touches the actual files.

"Connections + Messages" (default) attaches both Connections.csv and messages.csv and gets you all four tabs below. "Connections only" attaches just Connections.csv and gets you the Summary and Contact Matches tabs. Use it if you don't have your messages file, or would rather not share your message history. Either way you still get the full company-to-connection map.

Paste your top 25 companies from the Target Company spreadsheet above to see this prompt appear here.

NOTE:

Steps to export your LinkedIn data (connections and messages):

  • Log into desktop LinkedIn.
  • Click your Me icon at the top of the page.
  • Select Settings & Privacy.
  • Click Data privacy on the left menu.
  • Click Get a copy of your data.
  • Choose Download larger data archive, including connections, verifications, contacts, account history, and information we infer about you based on your profile and activity. (Or, if offered, pick just Connections and Messages for a smaller, faster export.)
  • When LinkedIn emails you that the archive is ready, download and unzip it. The two files this prompt uses are Connections.csv and messages.csv.

What you get back (an Excel workbook, .xlsx):

  • Summary — one row per target company: contacts matched, current vs. former, match confidence counts, and (with messages) how many you've messaged, how many are waiting on you, how many are waiting on them, how many you've never messaged, total messages, and your last message date. Built from live formulas, with a TOTAL row.
  • Contact Matches — target companies mapped to your connections, one row per match: Company, Matched Contact Name, Contact's Title, Contact's LinkedIn Profile URL, Current or Former, Match Confidence (High / Medium / Low), Company as Listed in CSV, and a Match Note explaining any non-exact match (subsidiary, regional entity, parent company, "Ex" employer). A former employee can still be a useful warm intro, but it's a different kind of connection than someone there now, so the two aren't blended together.
  • Target Connections (with messages) — each matched connection with their message history rolled up: conversations, messages sent and received, first/last message date, who sent last, a preview of the last message, and a Status: Never messaged, You reached out - no reply yet, They reached out - no reply from you, Awaiting their reply, or Your move - they replied last. Rows where it's your move are shaded orange; rows waiting on them are shaded yellow.
  • Messages (with messages) — every message in your conversations with those connections, grouped by company and contact, oldest to newest.

If a target company has no matching contact in your CSV, it's still included as "No match found" rather than omitted, so you can see coverage across your full list. Note that LinkedIn's export only shows each connection's current employer, so "Former" is flagged only where the data says so (for example, "Ex EY" or a "Retired" title), and anything sent after your export date won't appear.

Section 4 (optional) — Department Contact Finder

A separate, focused prompt that finds named individuals at a target company who work in or near a specific role/department — sourced from public web research (LinkedIn profiles, company team pages, press, case studies), not your own contacts. This is the fulfillment step for the main tracker's Key Contacts / Priority Titles column, which often comes back as a placeholder like "Practice-level title only — no named individual confirmed" — this prompt exists to turn that into real names. Works best with 15 or fewer companies, since each company/role pair needs its own live web search — a heavier per-company lift than Section 3's fuzzy-match.

Run it separately: paste your target companies below, along with the role/department you're targeting — the shortest variant from your tracker's Suggested Job Title Keywords column tends to work better here than the full title (e.g. "Cyber Risk OT" rather than "Managing Director, Cyber Risk OT" — dropping the seniority level widens the search instead of narrowing it to one level). Download the .txt, then paste into a new chat with web search enabled.

Pulled from your tracker's Suggested Job Title Keywords if you have one open — use the shortest variant. This is what the search matches against, tiered by closeness (see below).

"Yes" (default) also returns Tier 2 (adjacent practice, broader scope) and Tier 3 (umbrella/parent practice) matches when an exact match is thin — every result is still labeled with its tier, never blended in silently. "No" returns Tier 1 exact matches only, and says so plainly when a company has none, rather than substituting a looser match.

Fill in your target companies and a target role/department above to see this prompt appear here.

Match tiers used in this prompt:

  • Tier 1 — Exact: title or team name matches the target role/department directly.
  • Tier 2 — Adjacent: same general practice area, broader scope than the target.
  • Tier 3 — Umbrella: parent practice or risk/functional area likely overseeing the target area.

For each match found, the report has Company, Matched Person's Name, Title, Department/Team (as stated in the source), Match Tier, Source, and a Confidence rating (High/Medium/Low). Companies with no usable public results are listed as "No public matches found" rather than dropped. The result is formatted as an Excel workbook (.xlsx), with rows ready to paste back into the tracker's Key Contacts / Priority Titles column.