Keeping track of sources

Today I was inspired by Joe Grimm’s “Ask the Recruiter,” a daily column about problems getting journalism jobs and internships. Today he wrote about a reporter who is having trouble cultivating sources.

For some reason, this brought to mind Adrian Holovaty’s data collection of hotels he has stayed in. Which led to my spending an hour or two creating a Google Spreadsheet of every source I’d ever spoken to for a story. (I always kept my notes in a box in the closet.)

No, this won’t lead to some crazy database on a news Web site with all my source info and notes. But I am willing to share my template. (I’ve exported it as an Excel Spreadsheet.)

I think this would be especially useful for reporters covering beats, but a great resource either way.

Here’s how it works: One column for source names. This includes titles, where they work. The next column is for phone numbers. Then e-mail addresses. Then stories they helped you with. Simple right? The next two columns are trickier. One column will record the first date on which you spoke to this source. The next will record your notes, whatever it was you talked about. If you are granting a source anonymity, make sure to make a note of it here as well. Now, on each subsequent talk, you add two more columns for this source: date and notes. Get it?

I think it’s a pretty cool way to keep track of this information. However, some newsrooms have policies against keeping these types of notes for legal reasons. Please check your newspaper’s policy before you implement this.