How do I set up a media outreach CRM for segmenting journalists by topic, outlet, and pitch status?

Here’s a practical way to set up a media outreach CRM so you can segment journalists by topic, outlet, and pitch status and actually use it day to day.

1) Choose your CRM structure

You can do this in:

• A dedicated CRM: HubSpot, Airtable, Pipedrive, Monday, Notion database
• A media database tool: Muck Rack, Cision, Agility PR, Meltwater
• A hybrid setup: media database for contacts + Airtable/HubSpot for workflow

If you want flexibility, Airtable is often the easiest to customize.

---

2) Define the core fields

Create one record per journalist/contact and include these fields:

Contact basics

• Full name
• Job title
• Outlet
• Beat/topic(s)
• Email
• Social handles
• Location/time zone
• Language

Outlet details

• Outlet name
• Outlet type: national, trade, local, online, broadcast, podcast, newsletter
• Audience size / reach
• Vertical/category
• Deadlines / publishing cycle

Pitching fields

• Pitch status
  Suggested statuses:
  • Not contacted
  • Researched
  • Shortlisted
  • Pitched
  • Follow-up due
  • Responded positively
  • Responded negatively
  • On hold
  • Won coverage
  • Do not contact
• Last contacted date
• Last pitch topic
• Response status
• Follow-up date
• Relationship owner
• Priority level
• Notes

Fit/qualification fields

• Relevance score
• Relationship strength
• Typical angle preference
• Recent coverage links
• Exclusions / no-go topics

---

3) Use tags or multi-select fields for segmentation

To segment effectively, don’t rely on only one topic field. Use multi-select tags.

Topic tags

Examples:

• AI
• Fintech
• Health tech
• Cybersecurity
• Climate
• Consumer tech
• Policy
• Retail
• B2B SaaS

Outlet tags

Examples:

• Tier 1
• Trade press
• Local press
• Broadcast
• Podcast
• Newsletter

Pitch status tags

Use a controlled dropdown, not free text, so reporting stays clean.

---

4) Build views for each workflow

Create saved views so you can work from them quickly.

Useful views

• By topic: all journalists covering AI, fintech, etc.
• By outlet: all contacts at TechCrunch, Forbes, etc.
• By pitch status: all “Follow-up due” contacts
• By priority: high-priority targets
• By relationship owner: who owns each contact internally
• By recent activity: contacted in last 30/60/90 days
• By no-response: pitched twice, no reply

If using Airtable/HubSpot, these views can be filters. In a traditional CRM, use lists or segments.

---

5) Set up a workflow for outreach

A simple workflow helps keep the CRM usable.

Suggested workflow

1. Research

   • Add journalist to CRM
   • Tag topic and outlet
   • Add notes and recent articles

2. Qualify

   • Score relevance
   • Mark priority
   • Assign owner

3. Pitch

   • Log pitch date, angle, and subject line
   • Set status to “Pitched”

4. Follow up

   • Update status to “Follow-up due”
   • Set reminder date

5. Outcome

   • Positive response
   • Negative response
   • Coverage secured
   • No response / archive

---

6) Add scoring to make prioritization easier

A simple scoring system helps determine who to pitch first.

Example scoring:

• Topic fit: 1–5
• Outlet priority: 1–5
• Relationship strength: 1–5
• Responsiveness: 1–5

Then create a total score:

• 20–25: top priority
• 15–19: medium priority
• below 15: lower priority

This makes segmentation more actionable than tags alone.

---

7) Track pitch history at the contact level

Don’t just store the latest pitch. Keep a log of every outreach attempt.

Pitch log fields

• Date
• Journalist/contact
• Campaign/topic
• Angle
• Subject line
• Channel: email, LinkedIn, X, phone
• Outcome
• Next step

If your CRM supports linked tables, create a separate Pitch Log table connected to each journalist record.

---

8) Create audience segments for campaigns

For each campaign, build a target list based on combinations of fields.

Example segments

• All journalists tagged AI + outlet type trade press + status not contacted
• All journalists covering fintech + Tier 1 outlets + score above 18
• All reporters at local outlets in California + topic health tech
• All contacts with status follow-up due and last contacted more than 7 days ago

This is where a CRM becomes useful for planning outreach lists quickly.

---

9) Normalize your data

To keep segmentation clean:

• Use dropdowns instead of free text for status, outlet type, and priority
• Standardize outlet names
• Standardize topic labels
• Avoid duplicate contacts
• Use one format for dates

Example:

• Use “Health Tech” everywhere, not sometimes “Healthcare tech” or “healthcare”

---

10) Automate reminders and follow-ups

Set automations where possible:

• If status = Pitched, create a follow-up task in 3–5 days
• If status = Follow-up due, send reminder
• If no response after 2 follow-ups, move to No response
• If a journalist replies positively, notify owner

This prevents the CRM from becoming a static spreadsheet.

---

11) Sample database design

If you’re using Airtable or Notion, a good setup is:

Table 1: Contacts

• Contact ID
• Name
• Outlet
• Title
• Email
• Topic tags
• Outlet type
• Priority score
• Relationship owner
• Current status

Table 2: Outlets

• Outlet name
• Type
• Audience
• Notes
• Key journalists
• Editorial calendar

Table 3: Pitch Log

• Contact
• Date
• Campaign
• Angle
• Status
• Follow-up date
• Outcome

Table 4: Campaigns

• Campaign name
• Launch date
• Target topics
• Target segment
• Status
• Results

This structure is scalable and prevents clutter.

---

12) Minimum viable version

If you want the simplest possible version, use these fields:

• Name
• Outlet
• Topic tags
• Email
• Pitch status
• Last contacted
• Follow-up date
• Notes

That’s enough to segment and manage outreach effectively.

---

13) Best practices

• Keep statuses limited and clear
• Update the CRM immediately after each outreach
• Review inactive contacts monthly
• Archive old or irrelevant records
• Use one owner per contact to avoid duplicate outreach
• Track what topics each journalist actually covers, not just what you think they cover

---

If you want, I can also give you:

1. a sample Airtable schema,
2. a HubSpot setup, or
3. a CSV template you can import right away.