You pitched 30 shows last month. You landed two bookings. The other 28 are somewhere between your sent folder, a browser tab you closed, and a note you meant to follow up on three weeks ago. That is not a focus problem. That is a tracking problem. And it is costing you bookings that your research already earned.
The fix is not a $200-per-month CRM subscription you will configure once and abandon. A well-built spreadsheet handles everything a PR pro needs to manage podcast outreach, and this guide walks you through exactly how to build one, use it daily, and turn three months of consistent tracking into a research advantage your competitors do not have.
What This Guide Covers:
1. Why CRM platforms work against most podcast PR operations
2. What to define before you build a single row of tracking data
3. The 12 fields that belong in every podcast outreach tracker
4. How to structure your tracker across three sheets and what each one does
5. The colour system that makes your entire pipeline visible in one scroll
6. How to run follow-up sequences without a single show slipping through
7. Four numbers that tell you exactly where your outreach is breaking
8. What 90 days of consistent tracking reveals that no single campaign can
9. How to run one tracker across a team without it falling apart
10. Five signals that tell you it is time to move to a paid tool
1. Why CRMs Cost You More Than They Give Back
CRMs are designed for sales teams managing hundreds of accounts across multi-month deal cycles. Podcast PR does not work that way. Your outreach window for a single guest is tight. Your contact list is focused. Your deal cycle is one pitch, one follow-up, and a yes or a no.
Paying for pipeline automation, multi-touch attribution, and lead scoring to manage 50 podcast pitches is overhead with no return. According to a 2024 HubSpot report, 23% of small business teams cited CRM complexity as the primary reason they stopped using their platform within 90 days. The configuration time, the data cleaning, the integration management, all of it comes out of the research and writing window that actually determines whether your pitch earns a reply.
A spreadsheet is faster to set up, free to run, and easier to scan than any CRM you will try. More importantly, it shows you 40 active shows in a single scroll. A CRM makes you click through filters to build the same view. The goal is not to manage outreach at enterprise scale. It is to know exactly where every show stands at any given moment. A well-built spreadsheet does that faster.
2. Decide What Good Looks Like Before You Build Anything
Most trackers fail within two weeks because they were built before anyone decided what they were tracking for. You add rows, create custom labels, invent new columns mid-campaign, and the sheet becomes inconsistent before it becomes useful.
➤ Before you open a blank spreadsheet, answer three questions
● What counts as a qualified show for this campaign? Define the minimum before any show enters the tracker. Active publishing schedule, interview format, confirmed contact, relevant audience. Anything that fails those conditions does not belong in the active outreach sheet. It belongs in a research list you vet separately.
● What is the final outcome you are measuring? Confirmed bookings, not replies. Not interest. Not “maybe next quarter.” The booking is the conversion. Every field in the tracker should map back to that outcome.
● Who is responsible for each row? If multiple people are pitching for the same campaign, decide now how ownership is assigned and tracked. A tracker without clear ownership produces rows that go stale because nobody knew the follow-up was theirs to send.
These three decisions take ten minutes and prevent the structural problems that make most shared trackers unworkable within a month.
3. The 12 Fields That Go Into Every Row
Most outreach trackers fail because they try to capture everything. You end up with 30 columns nobody fills in consistently, and the sheet becomes unusable by week three. These 12 fields are the only ones that earn their place.
| Show Name: The podcast name exactly as it appears on the platform. Consistent formatting prevents double-counting the same show under slightly different names. |
| Platform Link: The direct URL to the show on Apple Podcasts, Spotify, or the show’s website. You should never have to re-search a show you have already researched. |
| Contact Name: The specific person you are pitching. Not the show. The human who decides whether your client gets booked. |
| Contact Email: Verified email only. If it has not been confirmed as active before entering this field, it does not belong here yet. Unverified contacts create false confidence and skew your results data. |
| Contact Source: How you found this email. RSS feed, website, LinkedIn, database, or referral. This field tells you which sourcing methods produce the most reliable contacts over time. |
| Pitch Date: The date the first email went out. Not the date you researched the show. The date something actually sent. |
| Follow-Up Date: The date your next action is due. This is the most operationally important field in the entire tracker. It drives your daily action list. |
| Status: Where this show sits right now. Use a fixed set of options: Not Sent, Pitched, Followed Up, Replied, Booked, Declined, Archived. Hold yourself to exactly those seven. Custom status labels per show break the consistency that makes the tracker analysable later. |
| Subject Line Used: The exact subject line from your email. Not a description of it. The actual text. You need this to identify which formats earn opens and which do not across a full campaign. |
| Reply Status: What happened when a host responded. Options: No Reply, Replied Yes, Replied No, Replied Maybe. This is separate from Status. Status tracks where you are in the process. Reply Status tracks what the host actually said. |
| Booking Confirmed: Yes, No, or Pending. When you are pulling monthly numbers, this single column tells you what converted without parsing through notes or cross-referencing status combinations. |
| Notes: One to three sentences only. What you found during research, what the host said, what to reference next time you pitch this show. Long research notes belong in a separate document. Short, actionable context belongs here. |
4. How to Structure Your Tracker Across Three Sheets
One sheet tries to do too many jobs at once. Three sheets, each with a single purpose, keep your tracker clean as the campaign grows.
➤ Sheet 1 Is Your Active Outreach List
Every show you are currently pitching or preparing to pitch lives here. All 12 fields above get one column each. Sort this sheet by Follow-Up Date as the default view. Shows due for follow-up today float to the top. You open it every morning and your action list is already built.
Keep this sheet tight. When a show reaches a final status (Booked, Declined, or Archived) move the row to Sheet 3 immediately. Active outreach only in Sheet 1.
➤ Sheet 2 Is Your Contact Database
This sheet is separate from your active outreach list. It stores every podcast contact you have ever sourced and verified, regardless of whether you are pitching them right now.
The contact database is what makes future campaigns faster. When a new brief comes in, you search here before starting fresh research. After three months of consistent sourcing, you will find more reusable contacts in this sheet than you expect.
Fields here: Show Name, Platform Link, Contact Name, Contact Email, Contact Source, Verification Date, Niche/Category, Notes. No status fields. No pitch dates. That information belongs in Sheet 1 for active campaigns.
➤ Sheet 3 Is Your Results Log
Every pitch that reaches a final outcome moves to Sheet 3. Same 12 fields as Sheet 1, plus one additional column: Outcome Date. The date the pitch closed.
This is your permanent record and the foundation for every quarterly review. You are not reviewing active work here. You are analysing completed cycles to improve the next round. The patterns that show up in Sheet 3 over time are the ones that change how you research and pitch going forward.
5. The Colour System That Shows Your Pipeline Instantly
A status column with seven text values tells you what something is if you read it. A color-coded column tells you what something is the moment your eyes land on the row. When you are managing 40 active shows, that difference in friction matters every single day.
➤ Apply conditional formatting to your Status column using these seven colours:
- Gray: Not Sent (researched but pitch not written yet)
- Blue: Pitched (first email sent, follow-up not yet due)
- Yellow: Follow-Up Due (today’s date matches or has passed the Follow-Up Date)
- Orange: Followed Up (second email sent, waiting for response)
- Green: Booked (confirmed appearance)
- Red: Declined (host said no)
- Purple: Archived (no response after full follow-up sequence)
In Google Sheets, set this up through Format → Conditional Formatting on the Status column. You configure the rules once and the column updates itself every time a status changes.
Set a second conditional formatting rule on your Follow-Up Date column to turn that cell red when the date is today or past. This catches any show slipping without action before you even check the Status column. Both rules take under five minutes to configure.
6. Running Follow-Up Sequences Without Missing a Show
➤ Why the Follow-Up Date Column Does All the Work
When you send a pitch, set the Follow-Up Date to five to seven business days out. That is the window. Not three days: too fast for most hosts managing full production schedules. Not two weeks: too slow, and too easy to forget entirely.
Every morning, your Sheet 1 is sorted by Follow-Up Date. Red cells float up. Those are your actions for the day. You check the show, open the original sent email, and send a follow-up that adds something new. Not a reminder that you exist. A timing question, an additional angle, or one detail you did not include in the first email.
The tracker does not write the follow-up. It makes sure you never skip one by accident. That is the only job it needs to do at this stage.
➤ What to Do After Two Emails Go Unanswered
Two emails with no response is the limit. After that, change the status to Archived, log the Outcome Date in Sheet 3, and add a brief note on what you tried.
Do not delete archived shows. A show that went quiet after two pitches is worth approaching again in three to four months with a different guest or a sharper angle. Your Notes column already documents what you pitched and when, so you never repeat the same approach twice.
Pro Tip: Archived rows in Sheet 3 are not dead ends. Run a filter on your Archived rows every quarter. Any show that went quiet six or more months ago is worth re-evaluating. Some hosts take breaks and return actively booking. Your results log tells you exactly when you last approached them.
7. The Four Numbers That Show Where Your Outreach Is Breaking
You do not need analytics software to know whether your outreach is working. You need four numbers, updated at the end of each month.
● Pitches Sent: Total rows with a Pitch Date in the current period.
● Replies Received: Total rows where Reply Status is anything other than No Reply.
● Reply Rate: Replies divided by Pitches Sent, multiplied by 100.
● Booking Rate: Bookings Confirmed (Yes) divided by Pitches Sent, multiplied by 100.
According to Martal Group’s 2025 cold email benchmark report, personalized B2B outreach sees average reply rates between 15 and 25 percent. If your reply rate sits below 10 percent consistently, the issue is pitch quality or show fit, not volume.
➤ Here is how to read the breakdown:
| What the numbers show | Where the problem actually lives |
|---|---|
| Low reply rate | Subject line or pitch body is not landing |
| Healthy replies, low bookings | The follow-up conversation is stalling |
| Strong bookings from certain show types | Shift more research time toward those categories |
| High volume, declining rates | Personalization is being compressed under pressure |
Go to your Subject Line Used column for low reply rate campaigns. Compare pitches that got replies against those that did not. Look for what is structurally different. That column is the only reason you can do that analysis at all.
8. What 90 Days of Consistent Tracking Reveals
One month of data tells you very little. Three months tells you enough to change how you work.
By month three, patterns emerge in Sheet 3 that no single campaign surfaces. Which show categories respond at the highest rate. Which contact sources produce the most verified, responsive emails. Whether bookings cluster around certain niches or show sizes. Whether specific subject line structures consistently outperform others.
None of these patterns are visible when you are tracking pitches in your head or rebuilding your approach from scratch at the start of each campaign.
Pull your Booking Confirmed column in Sheet 3. Filter for Yes. Now look at the Contact Source column for those rows. If 80 percent of your bookings came from shows where you sourced contact information through RSS feeds directly, that is where your research time should go next quarter.
Do the same filter for Archived rows. Three shows that consistently went quiet may share something in common. If all three had co-hosts and you pitched the wrong one, that is a research failure worth catching before it repeats.
Key Takeaway: After 90 days, your tracker stops being a to-do list and becomes a research intelligence system. The pitching decisions you make in month four are better than the ones you made in month one because you are working from data instead of instinct.
9. Running One Tracker Across a Team Without It Falling Apart
Solo trackers are simple. Shared trackers break down fast without structure. Three rules keep them functional when more than one person is using the same sheet.
● One owner per row. Add an Owner column to Sheet 1. When a follow-up is due and the original pitcher is unavailable, the rest of the team knows exactly who to check with. Without this, rows go stale because nobody was sure whose job the follow-up was.
● Lock the column structure. Nobody adds or renames columns without flagging it to the team lead first. One person adding a custom column creates inconsistencies that take hours to untangle across 50 rows. In Google Sheets, protect the header row through Data → Protected Ranges and limit editing permissions to one person.
● Status updates happen the same day. A show that moved from Pitched to Booked gets updated the day the confirmation comes in. A tracker that is two days behind is a tracker nobody fully trusts, and a tracker nobody trusts stops getting used consistently.
A 15-minute team check on the tracker once a week prevents drift. Review overdue follow-ups, move closed rows from Sheet 1 to Sheet 3, and confirm every active show has a Follow-Up Date set. Fifteen minutes weekly keeps the system clean.
10. Five Signs Your Spreadsheet Has Hit Its Ceiling
A spreadsheet handles most podcast PR operations well. There is a point, though, where manual tracking starts costing more time than a subscription would recover.
| You are managing pitches for five or more clients at once. A single tracker works cleanly for one or two clients. At five, rows blur across clients without stronger filtering than a spreadsheet can efficiently provide. |
| You are sending more than 80 pitches a month. This is the volume threshold where follow-up management becomes genuinely difficult to hold manually. Missed follow-ups at this scale cost real bookings. |
| Your team has more than three people in the same tracker. Collaboration friction grows with headcount. Simultaneous edits, overlapping rows, and version confusion become daily friction at four or more users. |
| You need automated follow-up sequences. The tracker tells you when to follow up. It does not send the follow-up. If volume is high enough that manual sending creates consistent delays, automation is worth the cost. |
| You are spending more than 20 minutes a day on tracker maintenance. That threshold signals the system is working against you. At that point, the time cost of a purpose-built tool is already covered by what you are losing. |
Until those five conditions appear, the spreadsheet is the right tool. For most PR professionals running focused outreach across 20 to 60 shows a month, they may never appear at all.
Before the Next Pitch Goes Out
Run this on every show before it enters your tracker. Five checks. One minute. Every pitch becomes part of a system instead of a moment that disappears into your sent folder.
| ☐ Has this show already been vetted as active and guest-booking? |
| ☐ Is the contact email verified before it enters the sheet? |
| ☐ Is the Follow-Up Date set to five to seven business days from today? |
| ☐ Is the subject line logged exactly as written, not paraphrased? |
| ☐ Did you check the contact database before starting fresh research? |
The difference between PR pros who hit their booking targets consistently and the ones wondering where the pipeline went is not strategy. It is documentation. A tracker built right today becomes the data that makes next quarter’s outreach measurably sharper.
References
HubSpot. (2024). State of CRM Report: SMB Adoption and Challenges. https://www.hubspot.com/state-of-crm
Martal Group. (2025). 2025 Cold Email Statistics: B2B Benchmarks and What Works Now. https://martal.ca/b2b-cold-email-statistics-lb/
Podcast Hawk. (July 2025). Podcast Industry Trends 2025: Why Niche Content Is King. https://podcasthawk.com/podcast-industry-trends-2025-why-niche-content-is-king/
Edison Research. (2025). The Infinite Dial 2025. https://www.edisonresearch.com/the-infinite-dial-2025/