In the PR Planner & Tracker template spreadsheet, you will find:
At-A-Glance Media Landscape
In one place, see your plans for when you want to pitch a print magazine like Entrepreneur, and what you want to be pitching blogs or local TV. Because these media types work in different cycles, the content will vary drastically. TV and blogs may be working on Summer subjects, but print magazines are working on Fall and Winter subjects. Keep things straight on this at-a-glance sheet.
Idea Sheets
Once you have your at-a-glance plans down, go into specifics on the idea sheets for each media outlet type. Track your ideas for magazines on one sheet, and your ideas for bloggers on another. Input your intended Media Contacts right there, and a column for if you pitched that idea or not.
Color Coordinated
Individual idea sheets are color coordinated with the At-A-Glance Media Landscape.
Pitching Log
Pitching the media can become a game of numbers. The more you pitch, the more your chances increase of getting picked up. Track each time you pitch and followup in one sheet - the Pitching Log.
Removing Rejection Syndrome
When you pitch the media, you often won't hear back from them. That's OK. But the silence can hurt. Remove this per-occupation by pitching several different media outlets, and following up with them. When you begin pitching a lot, you won't think about who didn't get back to you and why. They will simply be in your rotation of who you want to pitch when.