How to Build a Tech Media List

how to build a tech media list
Stage What to settle Planning use
Scope Which beats and outlets match the announcement Keeps off-beat contacts out of the sheet from the start
Columns Name, email, title, location, publication and notes on coverage Gives each row enough detail to personalise a pitch
Tiering A top tier of priority outlets and journalists, with a shortlist of 25-50 key contacts Saves personalised outreach for the shortlist
Maintenance Verify the list every 3-6 months Put review dates in a calendar before the list goes live

Field and shortlist guidance comes from Novos’s media list guide, and the review interval from BuzzStream’s media list guide.

Here is how to build a tech media list: start with a spreadsheet of beat reporters whose coverage matches your announcement, record the fields that let you personalise, and sort contacts into tiers.

This guide is about assembling the list itself. The wider programme it feeds sits within media relations for tech companies, and the work below starts with a blank sheet rather than a pitch.

Set the scope before opening the spreadsheet

A tech media list is a working document of the reporters, editors and outlets most likely to care about one kind of announcement. Its quality depends on relevance, not size.

BuzzStream, citing its PR Trends study, reports that the top reason journalists reject a pitch is lack of relevance. That makes relevance the first filter, applied before a name is typed into any cell. A beat reporter is a journalist who covers a defined subject area, so a reporter on your topic is worth more than a famous name on an unrelated desk.

Novos warns against the opposite habit: adding anyone and everyone with an email address. MediaHQ frames the goal as a Goldilocks balance, a list neither too big and unwieldy nor too small to make an impact.

  1. Describe the announcement in one sentence, naming the product category and the audience it serves.
  2. List the outlet types that plausibly cover it, such as general tech news sites, trade publications for your sector and regional business press.
  3. Set an entry rule: no contact joins the sheet without recent coverage of your topic that you have read.

With the scope fixed, the next job is giving each row a consistent shape.

Design the spreadsheet columns

A spreadsheet is the simplest tool for this job, and MediaHQ lists spreadsheets alongside Google searches, Twitter and LinkedIn as common ways to build a media list. Clear columns matter more than any software choice.

Column What to record Planning use
Name The journalist’s name as it appears on the byline Lets you address the person correctly and spot duplicates
Job title Reporter, editor, producer or similar Shows whether the person writes, assigns or both
Publication The outlet or organisation Supports sorting and grouping by outlet
Location City or region Lets you filter when an announcement has regional data
Contact details Email, plus phone and social accounts where relevant Gives you a fallback channel and a way to follow the person’s work
Topics of interest The subjects the person covers Confirms the beat before any pitch is drafted
Notes on coverage What they have written and what angle they favour Supplies the detail for a personalised opening line

These fields follow Novos’s recommended columns and the name, title, organisation and topics fields that MediaHQ says a list should include.

Add three columns of your own: a link to the most recent relevant article, the tier, and the date you last contacted the person. The article link makes verification quick, the tier drives your outreach order, and the contact date prevents repeat approaches. Use the notes column for outlet habits too. BuzzStream observes that the tech industry tends to lean toward data-rich visualisation, so a note on whether an outlet publishes charts or only text can shape what you offer.

Sketching the column headings by hand next to the laptop is a quick way to settle the structure before any names go in.

Source names from bylines, publications and free tools

You can fill the sheet without paying for a database. The method works from the publications outward, which keeps the list tied to real coverage.

  1. Open each target publication and, as BuzzStream advises, visit the homepage and click on some articles to judge topical relevance. This matters most for a trade publication, where one outlet can serve a narrow audience.
  2. Read the bylines on recent articles about your topic and log each author with the article link. Target the reporters who cover what you are pitching, plus editors or producers, and avoid general news inboxes.
  3. Check competitor coverage. Novos suggests monitoring competitor campaigns to see which journalists are covering them.
  4. Supplement your findings with LinkedIn, Twitter and Muck Rack, which the University of Minnesota’s communications team calls three free ways to supplement your earlier research.

Individual search techniques, such as narrowing down who actually covers a niche, are covered in how to find tech journalists. The sheet only needs the output of that research, one verified row per person.

Mastheads and bylines are the raw material for a self-built list: every name in the sheet should trace back to a published article.

Decide whether a paid database is worth it

A paid database saves research time, but it does not remove the need for relevance checks. BuzzStream points out that with standard database lists, everyone has access to the same journalists, which is the main argument for a list you built yourself.

Costs vary widely. BuzzStream, citing Prowly data, puts database access at from about $258/mo at the low end and $7,200-$10,000 monthly for Muck Rack or Cision. A small team launching a single product will rarely need that scale.

Cheaper routes exist. MediaHQ describes a database covering over 56,000 journalists, over 10,000 organisations and more than 320 topic categories. PR ON THE GO sells a spreadsheet of 1,500+ tech journalist contacts for $39, updated monthly. A purchased spreadsheet can seed your own sheet, but check each row against recent articles before relying on it.

A database suits a team that must cover many sectors or regions quickly. A self-built sheet suits a company with a narrow product category and the patience to read coverage.

Tier the list so effort follows priority

Tiering is ranking contacts by how much they matter to this announcement. Novos says every media list should have a top tier of high-priority outlets and journalists, and advises a shortlist of 25-50 key contacts for personalised outreach. Treat that range as a guide for the shortlist, not a quota for the whole sheet.

  1. Place a contact in the top tier only when recent coverage closely matches the announcement and the outlet reaches your audience.
  2. Put reporters with a looser topical fit in a middle tier, and broader outlets that may pick the story up in a wider tier.
  3. Write a tier label in the dedicated column so you can sort and filter in seconds.
  4. Draft personal notes for the top tier only, and keep handling lighter further down.

If you intend to give one outlet early access, choose from the top tier. The process is described in how to offer an exclusive to a journalist.

Tabs add a second dimension. Novos recommends separate tabs for different audience segments, and a location filter when a release carries region-specific data. A single master tab with tier and location columns, plus filtered views, is easier to maintain than copies that drift apart.

Marking priority rows with a highlighter on a printout mirrors what a tier column does on screen.

Keep the list current

A media list decays. Novos notes that journalists frequently change jobs or areas of focus, and BuzzStream warns that lists can get outdated in just a few months, sometimes weeks. Its advice is to update and verify lists every 3-6 months.

A planner open on the desk stands in for the recurring review slot that keeps contact details from going stale.

For a team with steady announcements, the shorter end of that range is the safer default. A team with rare launches should still verify before each one, because a stale sheet wastes the relevance work done at the start.

  1. Set a recurring calendar slot for the review and keep it fixed.
  2. Open the article link for each top-tier row and confirm the person still writes on your topic.
  3. Update the title, publication and notes, and delete anyone who has moved to an unrelated beat.
  4. Add new names found through fresh bylines, then reassign tiers.

Fix common problems with a new list

  • Replies suggest the pitch was off-topic. Return to the entry rule and re-read each recipient’s recent articles. Remove anyone whose coverage does not match, since relevance is the leading reason journalists reject pitches.
  • The sheet feels unwieldy. Collapse it to a single master tab, add tier and location columns, and use filters rather than duplicating rows.
  • Competitors seem to pitch the same people. That is typical when a list comes from a standard database. Build extra rows from bylines and competitor coverage to find reporters the database misses.
  • Emails stop reaching people. Check whether the journalist has changed outlet or focus and update the row, or remove it if the person has left your beat.
  • Notes are thin. Add a link to a recent article and one line on the angle. A row without that evidence is a candidate for deletion.

Frequently asked questions

Is a spreadsheet enough, or do I need specialist software?

A spreadsheet is enough to start. MediaHQ includes spreadsheets among the common tools for building a media list, alongside searches and social platforms, so the structure you design matters more than the software.

Can I share a purchased list with an agency or another team?

Check the licence first. PR ON THE GO’s terms say the buyer agrees not to sell, publish or distribute the database to any third party, which limits it to in-house use. A sheet built from your own research carries no such restriction.

How much time should I set aside before each release?

Novos recommends spending at least a couple of hours searching for new journalists covering relevant topics before a release goes out.

How should I name and file separate lists?

MediaHQ suggests grouping lists by reach and subject, such as national, regional and specialist, and filing the lists alphabetically under each category.